{"id":94039,"date":"2020-04-22T17:32:22","date_gmt":"2020-04-22T09:32:22","guid":{"rendered":"http:\/\/4563.org\/?p=94039"},"modified":"2020-04-22T17:32:22","modified_gmt":"2020-04-22T09:32:22","slug":"%e6%b1%82%e5%8a%a9-mysql-%e4%b8%8d%e5%90%8c%e7%9a%84%e7%b1%bb%e5%9e%8b%e5%95%86%e5%93%81%ef%bc%8c%e5%a6%82%e4%bd%95%e8%ae%be%e8%ae%a1%e8%a1%a8%ef%bc%8c%e6%98%af%e5%88%86%e5%88%ab%e5%bb%ba%e8%a1%a8","status":"publish","type":"post","link":"http:\/\/4563.org\/?p=94039","title":{"rendered":"[\u6c42\u52a9] mysql \u4e0d\u540c\u7684\u7c7b\u578b\u5546\u54c1\uff0c\u5982\u4f55\u8bbe\u8ba1\u8868\uff0c\u662f\u5206\u522b\u5efa\u8868\u8fd8\u662f\u6709\u4e2a\u7edf\u4e00\u8868"},"content":{"rendered":"
\n
\n
\n

[\u6c42\u52a9] mysql \u4e0d\u540c\u7684\u7c7b\u578b\u5546\u54c1\uff0c\u5982\u4f55\u8bbe\u8ba1\u8868\uff0c\u662f\u5206\u522b\u5efa\u8868\u8fd8\u662f\u6709\u4e2a\u7edf\u4e00\u8868 <\/h1>\n

<\/p>\n

\n
\u8cc7\u6df1\u5927\u4f6c : kukala <\/span> <\/i> 21<\/span> <\/div>\n
<\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n
<\/p>\n

\u4e0d\u540c\u7684\u7c7b\u578b\u5546\u54c1\uff0c\u5982\u4f55\u8bbe\u8ba1\u8868\uff0c\u662f\u5206\u522b\u5efa\u8868\u8fd8\u662f\u6709\u4e2a\u7edf\u4e00\u8868<\/h3>\n

\u4f8b\u5982\uff1a\u65c5\u6e38\u7ebf\u8def\uff0c\u9152\u5e97\uff0c\u673a\u7968<\/h3>\n

1. \u63cf\u8ff0\uff1a<\/h4>\n
    \n
  • \n

    \u9996\u9875\u4f1a\u4e00\u8d77\u5bf9\u201c\u65c5\u6e38\u7ebf\u8def\uff0c\u9152\u5e97\uff0c\u673a\u7968\u201d\u7684\u4ea7\u54c1\u8fdb\u884c\u63a8\u8350\u663e\u793a\uff08\u5982\uff1a\u6dd8\u5b9d APP \u9996\u9875\u7684\u731c\u4f60\u559c\u6b22\uff09<\/p>\n<\/li>\n

  • \n

    \u641c\u7d22\u6846\uff0c\u641c\u7d22\u201c\u5317\u4eac\u201d\u65f6\uff0c\u5148\u663e\u793a\u7684\u662f\u641c\u7d22\u5206\u7c7b\u9875\u9762\uff08\u5982\uff1a\u5317\u4eac\u7684\u9152\u5e97\u3001\u5317\u4eac\u7684\u95e8\u7968\u3001\u5317\u4eac\u7684\u65c5\u6e38\u7ebf\u8def\uff09<\/p>\n<\/li>\n

  • \n

    \u8ba2\u5355\u8868\uff0c\u201c\u65c5\u6e38\u7ebf\u8def\uff0c\u9152\u5e97\uff0c\u673a\u7968\u201d\u7684\u4ea7\u54c1\u7684\u8ba2\u5355\u90fd\u662f\u653e\u5728\u540c\u4e00\u4e2a\u8ba2\u5355\u4e2d\u5fc3\u9875\u9762\u663e\u793a\uff08\u5982\uff1a\u6dd8\u5b9d APP \u7684\u6211\u7684\u8ba2\u5355\uff09<\/p>\n<\/li>\n<\/ul>\n

    2. \u521d\u6b65\u8bbe\u60f3\uff1a<\/h4>\n
      \n
    • \u9488\u5bf9\u63cf\u8ff0 1\uff1a\u81ea\u5df1\u521d\u6b65\u662f\u60f3\u9488\u5bf9\u201c\u65c5\u6e38\u7ebf\u8def\uff0c\u9152\u5e97\uff0c\u673a\u7968\u201d\u7684\u4ea7\u54c1\u5206\u522b\u5efa\u8868\uff0c\u7136\u540e\u6709\u4e2a\u7edf\u4e00\u5546\u54c1\u8868\uff0c\u5173\u8054\u8d77\u6765<\/li>\n<\/ul>\n
      \u5982\uff1a  goods->\u7edf\u4e00\u8868\uff0c\u5173\u8054\u201c\u65c5\u6e38\u7ebf\u8def\uff0c\u9152\u5e97\uff0c\u673a\u7968\u201d\u7684\u4ea7\u54c1\u8868  tours->\u65c5\u6e38\u7ebf\u8def\u8868  hotel->\u9152\u5e97\u8868  fight->\u673a\u7968\u8868 <\/code><\/pre>\n
        \n
      • \u9488\u5bf9\u63cf\u8ff0 2\uff1a\u56e0\u4e3a\u662f\u6839\u636e\u4ea7\u54c1\u5206\u522b\u5efa\u8868\u4e86\uff0c\u641c\u7d22\u65f6\u5c31\u67e5\u627e\u5404\u81ea\u7684\u8868\u6570\u636e\u5c31\u884c\u4e86<\/li>\n
      • \u9488\u5bf9\u63cf\u8ff0 3\uff1a\u56e0\u4e3a\u5728\u4e00\u4e2a\u8ba2\u5355\u4e2d\u5fc3\uff0c\u6240\u4ee5\u8bbe\u60f3\u548c\u63cf\u8ff0 1 \u64cd\u4f5c\u4e00\u6837\uff0c\u6709\u4e2a\u7edf\u4e00\u7684\u8ba2\u5355\u8868\uff0c\u5bf9\u5404\u4e2a\u4ea7\u54c1\u8fdb\u884c\u5173\u8054<\/li>\n<\/ul>\n
        \u6700\u540e\uff1a\u4e0d\u77e5\u9053\u8fd9\u6837\u7684\u8bbe\u8ba1\u662f\u5426\u53ef\u884c\uff0c\u662f\u5426\u65b9\u4fbf\u4ee5\u540e\u6570\u636e\u91cf\u5927\u4e86\u540e\u7684\u5206\u8868\u5206\u533a\uff1f\uff1f\uff1f<\/h4>\n
        \u6b22\u8fce\u63d0\u51fa\u66f4\u597d\u5efa\u8bae\uff0c\u8c22\u8c22\u4e86<\/p>\n<\/p><\/div>\n
         \u5927\u4f6c\u6709\u8a71\u8aaa<\/b> (11<\/span>)        <\/div>\n
         <\/div>\n<\/p><\/div>\n<\/p><\/div>\n
          \n
        • \n
          \n
          \n
           \u8cc7\u6df1\u5927\u4f6c : hugedata <\/span>  <\/div>\n
           <\/i>            <\/span> <\/div>\n<\/p><\/div>\n
                                                                       \u6570\u636e\u91cf\u3001\u5e76\u53d1\u8bbf\u95ee\u91cf\u4e0d\u5927\uff0c\u6ca1\u6709\u4efb\u4f55\u95ee\u9898\u3002\u600e\u4e48\u641e\u90fd\u6ca1\u6709\u95ee\u9898\u3002
          \u9488\u5bf9\u4ee5\u4e0a\u7684\u4e09\u4e2a\u9700\u6c42\u63cf\u8ff0\uff0c\u8bbf\u95ee\u91cf\u4e0a\u6765\u65f6\uff0c\u589e\u52a0\u7f13\u5b58\uff0c\u518d\u5927\u4e00\u70b9\uff0c\u53ef\u4ee5\u589e\u52a0\u5b9a\u65f6\u63d0\u524d\u8ba1\u7b97\u653e\u7f13\u5b58\uff0c\u518d\u5927\uff0c\u4e0a es \u505a\u641c\u7d22\u3002
          \u629b\u5f00\u6570\u636e\u91cf\u548c\u5e76\u53d1\u6570\u7684\u8bdd\uff0c\u4e0d\u592a\u597d\u5b9a\u4e49\u600e\u4e48\u8bbe\u8ba1\u66f4\u597d\u3002                                                            <\/div>\n<\/p><\/div>\n<\/li>\n
        • \n
          \n
          \n
           \u8cc7\u6df1\u5927\u4f6c : hugedata <\/span>  <\/div>\n
           <\/i>            <\/span> <\/div>\n<\/p><\/div>\n
                                                                       \u6211\u8fd8\u662f\u6bd4\u8f83\u8d5e\u6210\u5206\u5f00\u5b58\u50a8\uff0c\u81f3\u4e8e\u4f60\u8981\u4e0d\u8981\u5f04\u4e2a\u7edf\u4e00\u5546\u54c1\u8868\u6765\u5173\u8054\uff0c\u8fd8\u662f\u770b\u4f60\u7684\u53d6\u820d\uff0c\u7edf\u4e00\u5173\u8054\u4e86\u8d77\u6765\uff0c\u4f60\u8981\u628a\u9700\u8981\u641c\u7d22\u7684\u5b57\u6bb5\u4e5f\u5173\u8054\u8fdb\u6765\u3002\u4e0d\u7136\u4f60\u7684 sql \u8bed\u53e5\u8fd8\u662f\u8981\u628a\u51e0\u4e2a\u8868\u7684\u67e5\u8be2\u7ed3\u679c\u90fd union all \u3002                                                            <\/div>\n<\/p><\/div>\n<\/li>\n
        • \n
          \n
          \n
           \u4e3b<\/span> \u8cc7\u6df1\u5927\u4f6c : kukala <\/span>  <\/div>\n
           <\/i>            <\/span> <\/div>\n<\/p><\/div>\n
                                                                       @hugedata \u611f\u8c22\u56de\u590d\uff0c\u641c\u7d22\u521d\u6b65\u5148\u6309\u7167\u7c7b\u522b\u6765\u641c\u7d22\u597d\u4e86\uff0c\u7c7b\u578b tabs \u6807\u7b7e\uff1b                                                            <\/div>\n<\/p><\/div>\n<\/li>\n
        • \n
          \n
          \n
           \u8cc7\u6df1\u5927\u4f6c : lower <\/span>  <\/div>\n
           <\/i>            <\/span> <\/div>\n<\/p><\/div>\n
                                                                       \u5206\u5f00\u5b58\u50a8\uff0c\uff0c\u5c31\u7b97\u6709 \u7edf\u4e00\u641c\u7d22\u7b49\u540e\u7eed\u9700\u6c42\uff0c\u4e5f\u53ef\u4ee5\u7528\u89c6\u56fe\u6216\u8005 \u641c\u7d22\u5f15\u64ce \u6765\u641e\uff1b                                                            <\/div>\n<\/p><\/div>\n<\/li>\n
        • \n
          \n
          \n
           \u8cc7\u6df1\u5927\u4f6c : hugedata <\/span>  <\/div>\n
           <\/i>            <\/span> <\/div>\n<\/p><\/div>\n
                                                                       tabs? tags \u5427\u3002\u6bd4\u8f83\u597d\u5947\uff0c\u5f04\u6807\u7b7e\u7684\u8bdd\uff0c\u6807\u7b7e\u662f\u600e\u4e48\u5b58\uff0c\u600e\u4e48\u641c\u7684\uff1f like \u5de6\u53f3\u5339\u914d\u8fd8\u662f match against \uff1f                                                            <\/div>\n<\/p><\/div>\n<\/li>\n
        • \n
          \n
          \n
           \u8cc7\u6df1\u5927\u4f6c : keleifeng <\/span>  <\/div>\n
           <\/i>            <\/span> <\/div>\n<\/p><\/div>\n
                                                                       \u5206\u5f00\u5b58\u50a8\uff0c\uff0c\u5c31\u7b97\u6709 \u7edf\u4e00\u641c\u7d22\u7b49\u540e\u7eed\u9700\u6c42\uff0c\u4e5f\u53ef\u4ee5\u7528\u89c6\u56fe\u6216\u8005 \u641c\u7d22\u5f15\u64ce \u6765\u641e\uff1b                                                            <\/div>\n<\/p><\/div>\n<\/li>\n
        • \n
          \n
          \n
           \u8cc7\u6df1\u5927\u4f6c : kanepan19 <\/span>  <\/div>\n
           <\/i>            <\/span> <\/div>\n<\/p><\/div>\n
                                                                       \u4e2a\u4eba\u5efa\u8bae\uff0c\u5b58\u540c\u4e00\u4e2a\u8868\uff0c \u7528\u6269\u5c55\u8868\u6269\u5c55\u4e1a\u52a1\u4e13\u7528\u4fe1\u606f\u3002
          \u56e0\u4e3a\u5546\u54c1\uff0c\u8ba2\u5355\uff0c\u652f\u4ed8\uff0c\u7edf\u4e00\u903b\u8f91\uff0c\u591a\u4e2a\u4e1a\u52a1\u53ef\u4ee5\u516c\u7528\u3002                                                            <\/div>\n<\/p><\/div>\n<\/li>\n
        • \n
          \n
          \n
           \u4e3b<\/span> \u8cc7\u6df1\u5927\u4f6c : kukala <\/span>  <\/div>\n
           <\/i>            <\/span> <\/div>\n<\/p><\/div>\n
                                                                       @hugedata 
          \u5206\u5f00\u5b58\u50a8\u7684\u8bdd\uff0c\u641c\u7d22\u9875\u521d\u6b65\u53ef\u4ee5\u8fd9\u6837\u6765
          \u641c\u7d22\u201c\u5317\u4eac\u201d
          \u4e0b\u62c9\u5efa\u8bae\u6846\u5206\u522b\u662f
          \u201c\u5317\u4eac\u201d\u7684\u65c5\u6e38\u7ebf\u8def
          \u201c\u5317\u4eac\u201d\u7684\u9152\u5e97
          \u201c\u5317\u4eac\u201d\u7684\u673a\u7968
          \u70b9\u51fb\u540e\uff0c\u518d\u6309\u7167\u5546\u54c1\u7c7b\u578b\u6765\u641c\u7d22<\/p>\n
          \u770b\u98de\u732a APP \u4e0a\u662f\u8fd9\u6837\u6765\u7684                                                            <\/p><\/div>\n<\/p><\/div>\n<\/li>\n
        • \n
          \n
          \n
           \u4e3b<\/span> \u8cc7\u6df1\u5927\u4f6c : kukala <\/span>  <\/div>\n
           <\/i>            <\/span> <\/div>\n<\/p><\/div>\n
                                                                       @lower \u5546\u54c1\u8868\u548c\u8ba2\u5355\u8868\u90fd\u5206\u5f00\u5b58\u50a8\u5417\uff1f                                                            <\/div>\n<\/p><\/div>\n<\/li>\n
        • \n
          \n
          \n
           \u8cc7\u6df1\u5927\u4f6c : 1ffree <\/span>  <\/div>\n
           <\/i>            <\/span> <\/div>\n<\/p><\/div>\n
                                                                       \u5148\u60f3\u60f3 order \u8868\u91cc\u7684 \u5546\u54c1 id \u600e\u4e48\u53d6\uff1f                                                            <\/div>\n<\/p><\/div>\n<\/li>\n
        • \n
          \n
          \n
           \u8cc7\u6df1\u5927\u4f6c : lower <\/span>  <\/div>\n
           <\/i>            <\/span> <\/div>\n<\/p><\/div>\n
                                                                       @kukala \u8ba2\u5355\u4e0d\u786e\u5b9a\uff0c\u8fd8\u662f\u770b\u5177\u4f53\u7684\u4e1a\u52a1\u573a\u666f\u5427\uff0c\u5982\u679c\u8fd8\u5b58\u5728\u7740\u628a\u5ba2\u6237\u8ba2\u5355\u518d\u62c6\u5206\u5230 \u5546\u5bb6\u5b50\u8ba2\u5355\u7b49\u5230\u590d\u6742\u7684\u540e\u7aef\u4e1a\u52a1\uff0c\u90a3\u6700\u597d\u8003\u8651\u662f\u5426\u5206\u5f00\u3002
          \u7edf\u4e00\u7684\u5546\u54c1\u8868\u4ece\u4f60\u63cf\u8ff0\u7684\u573a\u666f\u611f\u89c9\u7528\u5904\u4e0d\u5927\uff0c\u4e0d\u4ec5\u8981\u591a\u7ef4\u62a4\u8868\u548c\u5173\u7cfb\uff0c\u641c\u7d22\u65f6\u6269\u5c55\u8868\u8fd8\u662f\u8981\u5173\u8054\u67e5\u624d\u884c\u3002                                                            <\/div>\n<\/p><\/div>\n<\/li>\n
        • \n","protected":false},"excerpt":{"rendered":"
          [\u6c42\u52a9] mysql \u4e0d\u540c\u7684\u7c7b\u578b\u5546…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[],"tags":[],"_links":{"self":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/94039"}],"collection":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=94039"}],"version-history":[{"count":0,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/94039\/revisions"}],"wp:attachment":[{"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=94039"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=94039"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=94039"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}