{"id":83,"date":"2020-12-28T19:20:32","date_gmt":"2020-12-28T11:20:32","guid":{"rendered":"https:\/\/www.52dixiaowo.com\/database\/?p=83"},"modified":"2021-09-09T16:21:13","modified_gmt":"2021-09-09T08:21:13","slug":"%e7%a0%81%e4%b8%8e%e5%87%bd%e6%95%b0%e4%be%9d%e8%b5%96","status":"publish","type":"post","link":"https:\/\/www.52dixiaowo.com\/db\/post-83.html","title":{"rendered":"SQL \u51fd\u6570\u4f9d\u8d56, \u7801, \u4e3b\u5c5e\u6027 \u7b49\u76f8\u5173\u6982\u5ff5"},"content":{"rendered":"\n<p>\u51fd\u6570\u4f9d\u8d56\u662f\u6307\u8868\u5b57\u6bb5\u95f4\u7684\u51b3\u5b9a\u5173\u7cfb<\/p>\n\n\n\n<h5>1.\u51fd\u6570\u4f9d\u8d56<\/h5>\n\n\n\n<p>\u901a\u8fc7 A \u5c5e\u6027\uff08\u6216\u5c5e\u6027\u7ec4\uff09\u53ef\u4ee5\u552f\u4e00\u786e\u5b9a B \u7684\u503c\uff0c\u79f0 B \u4f9d\u8d56\u4e8e A<\/p>\n\n\n\n<p class=\"has-text-align-center\">\u5b66\u751f\u8868<\/p>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><tbody><tr><td>\u5b66\u53f7<\/td><td>\u59d3\u540d<\/td><td>\u8bfe\u7a0b\u540d\u79f0<\/td><td>\u5206\u6570<\/td><\/tr><tr><td>10001<\/td><td>\u5f20\u4e09<\/td><td>\u9ad8\u7b49\u6570\u5b66<\/td><td>77<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>\u4f8b\u5982\uff1a\u5b66\u53f7&#8211;&gt;\u59d3\u540d \uff0c(\u5b66\u53f7, \u8bfe\u7a0b\u540d)&#8211;&gt;\u5206\u6570<\/p>\n\n\n\n<h5>2.\u5b8c\u5168\u51fd\u6570\u4f9d\u8d56<\/h5>\n\n\n\n<p>\u5047\u8bbe A  \u662f\u4e00\u4e2a\u5c5e\u6027\u7ec4\uff0c\u5219 B \u7684\u786e\u5b9a\uff0c\u9700\u8981\u4f9d\u8d56\u4e8e A \u4e2d\u7684\u6240\u6709\u5c5e\u6027\u503c<\/p>\n\n\n\n<p>\u4f8b\u5982\uff1a(\u5b66\u53f7, \u8bfe\u7a0b\u540d\u79f0)&#8211;&gt;\u5206\u6570<\/p>\n\n\n\n<h5>3.\u90e8\u5206\u51fd\u6570\u4f9d\u8d56<\/h5>\n\n\n\n<p>\u5982\u679c A \u662f\u4e00\u4e2a\u5c5e\u6027\u7ec4\uff0c\u5219 B \u7684\u786e\u5b9a\uff0c\u53ea\u9700\u8981\u4f9d\u8d56\u4e8e A \u5c5e\u6027\u7ec4\u4e2d\u7684\u90e8\u5206\u503c\u5373\u53ef<\/p>\n\n\n\n<p>\u4f8b\u5982\uff1a(\u5b66\u53f7, \u8bfe\u7a0b\u540d\u79f0)&#8211;&gt;\u59d3\u540d\uff0c \u800c  \u5b66\u53f7-&gt;\u59d3\u540d<\/p>\n\n\n\n<h5>4.\u4f20\u9012\u51fd\u6570\u4f9d\u8d56<\/h5>\n\n\n\n<p>\u6709 A&#8211;&gt;B, B&#8211;&gt;C\uff0c\u5219\u79f0 C \u4f9d\u8d56\u4e8e A <\/p>\n\n\n\n<p class=\"has-text-align-center\">\u5b66\u751f\u8868<\/p>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><tbody><tr><td>\u5b66\u53f7<\/td><td>\u7cfb\u540d<\/td><td>\u7cfb\u4e3b\u4efb<\/td><\/tr><tr><td>10001<\/td><td>\u7ecf\u6d4e\u7cfb<\/td><td>\u5f20\u4e09<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>\u4f8b\u5982\uff1a\u5b66\u53f7&#8211;&gt;\u7cfb\u540d\uff0c\u7cfb\u540d&#8211;&gt;\u7cfb\u4e3b\u4efb<\/p>\n\n\n\n<h5>5.\u7801\uff08\u4e5f\u53eb\u5019\u9009\u7801\uff09<\/h5>\n\n\n\n<p>\u901a\u8fc7\u7801\uff0c\u53ef\u4ee5\u786e\u5b9a\u5176\u4ed6\u552f\u4e00\u7684\u5c5e\u6027<\/p>\n\n\n\n<p class=\"has-text-align-center\">\u5b66\u751f\u8868<\/p>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><tbody><tr><td>\u5b66\u53f7<\/td><td>\u59d3\u540d<\/td><td>\u7cfb\u540d<\/td><td>\u7cfb\u4e3b\u4efb<\/td><td>\u8bfe\u7a0b\u540d\u79f0<\/td><td>\u5206\u6570<\/td><\/tr><tr><td>10001<\/td><td>\u5f20\u4e09<\/td><td>\u6cd5\u5f8b\u7cfb<\/td><td>\u674e\u56db<\/td><td>\u9ad8\u7b49\u6570\u5b66<\/td><td>77<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>\u5206\u6790\uff1a\u5b66\u53f7&#8211;&gt;\u59d3\u540d\uff0c\u5b66\u53f7&#8211;&gt;\u7cfb\u540d\uff0c\u7cfb\u540d&#8211;&gt;\u7cfb\u4e3b\u4efb\uff0c(\u5b66\u53f7, \u8bfe\u7a0b\u540d\u79f0)&#8211;&gt;\u5206\u6570<\/p>\n\n\n\n<p>\u5219\uff0c\u5f53\u5019\u9009\u7801\u4e3a (\u5b66\u53f7,\u8bfe\u7a0b\u540d\u79f0)\u65f6\uff0c\u53ef\u4ee5\u552f\u4e00\u786e\u5b9a\u5176\u4ed6\u7684\u6240\u6709\u5217\u7684\u503c<\/p>\n\n\n\n<p>\u6545\u672c\u8868\u7684\u7801\uff0c\u5c31\u662f (\u5b66\u53f7, \u8bfe\u7a0b\u540d\u79f0)<\/p>\n\n\n\n<h5>6.\u4e3b\u5c5e\u6027\u4e0e\u975e\u4e3b\u5c5e\u6027<\/h5>\n\n\n\n<p>1.\u4e3b\u5c5e\u6027\uff1a\u7801\u5c5e\u6027\u4e2d\u7684\u6240\u6709\u5c5e\u6027<\/p>\n\n\n\n<p>2.\u975e\u4e3b\u5c5e\u6027\uff1a\u9664\u4e86\u7801\u5c5e\u6027\u4e2d\u7684\u5176\u4ed6\u5c5e\u6027<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u51fd\u6570\u4f9d\u8d56\u662f\u6307\u8868\u5b57\u6bb5\u95f4\u7684\u51b3\u5b9a\u5173\u7cfb 1.\u51fd\u6570\u4f9d\u8d56 \u901a\u8fc7 A \u5c5e\u6027\uff08\u6216\u5c5e\u6027\u7ec4\uff09\u53ef\u4ee5\u552f\u4e00\u786e\u5b9a B \u7684\u503c\uff0c\u79f0 B \u4f9d\u8d56\u4e8e&hellip; <a href=\"https:\/\/www.52dixiaowo.com\/db\/post-83.html\" class=\"more-link\">\u7ee7\u7eed\u9605\u8bfb <span class=\"screen-reader-text\">SQL \u51fd\u6570\u4f9d\u8d56, \u7801, \u4e3b\u5c5e\u6027 \u7b49\u76f8\u5173\u6982\u5ff5<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[4],"tags":[],"_links":{"self":[{"href":"https:\/\/www.52dixiaowo.com\/db\/wp-json\/wp\/v2\/posts\/83"}],"collection":[{"href":"https:\/\/www.52dixiaowo.com\/db\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.52dixiaowo.com\/db\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.52dixiaowo.com\/db\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.52dixiaowo.com\/db\/wp-json\/wp\/v2\/comments?post=83"}],"version-history":[{"count":3,"href":"https:\/\/www.52dixiaowo.com\/db\/wp-json\/wp\/v2\/posts\/83\/revisions"}],"predecessor-version":[{"id":87,"href":"https:\/\/www.52dixiaowo.com\/db\/wp-json\/wp\/v2\/posts\/83\/revisions\/87"}],"wp:attachment":[{"href":"https:\/\/www.52dixiaowo.com\/db\/wp-json\/wp\/v2\/media?parent=83"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.52dixiaowo.com\/db\/wp-json\/wp\/v2\/categories?post=83"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.52dixiaowo.com\/db\/wp-json\/wp\/v2\/tags?post=83"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}