{"id":196058,"date":"2020-07-29T09:39:20","date_gmt":"2020-07-29T01:39:20","guid":{"rendered":"https:\/\/lrxjmw.cn\/?p=196058"},"modified":"2020-07-20T09:52:33","modified_gmt":"2020-07-20T01:52:33","slug":"mysql-cross-database","status":"publish","type":"post","link":"https:\/\/lrxjmw.cn\/mysql-cross-database.html","title":{"rendered":"MySQL\u4e2d\u8de8\u5e93\u67e5\u8be2\u600e\u4e48\u641e\uff1f"},"content":{"rendered":"<table>\n<tbody>\n<tr>\n<td style=\"padding: 5px 12px; width: 25px; font-size: 22px; text-align: center; background: #E8E8E8; line-height: 30px; color: #999;\">\u5bfc\u8bfb<\/td>\n<td style=\"padding: 10px 10px 12px; line-height: 20px;\"><strong>\u5728MySQL\u4e2d\u8de8\u5e93\u67e5\u8be2\u4e3b\u8981\u5206\u4e3a\u4e24\u79cd\u60c5\u51b5\uff0c\u4e00\u79cd\u662f\u540c\u670d\u52a1\u7684\u8de8\u5e93\u67e5\u8be2;\u53e6\u4e00\u79cd\u662f\u4e0d\u540c\u670d\u52a1\u7684\u8de8\u5e93\u67e5\u8be2;\u5b83\u4eec\u8fdb\u884c\u8de8\u5e93\u67e5\u8be2\u662f\u4e0d\u540c\u7684\uff0c\u4e0b\u9762\u5c31\u5177\u4f53\u4ecb\u7ecd\u8fd9\u4e24\u79cd\u8de8\u5e93\u67e5\u8be2\u3002<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u5728MySQL\u4e2d\u8de8\u5e93\u67e5\u8be2\u4e3b\u8981\u5206\u4e3a\u4e24\u79cd\u60c5\u51b5\uff0c\u4e00\u79cd\u662f\u540c\u670d\u52a1\u7684\u8de8\u5e93\u67e5\u8be2;\u53e6\u4e00\u79cd\u662f\u4e0d\u540c\u670d\u52a1\u7684\u8de8\u5e93\u67e5\u8be2;\u5b83\u4eec\u8fdb\u884c\u8de8\u5e93\u67e5\u8be2\u662f\u4e0d\u540c\u7684\uff0c\u4e0b\u9762\u5c31\u5177\u4f53\u4ecb\u7ecd\u8fd9\u4e24\u79cd\u8de8\u5e93\u67e5\u8be2\u3002<\/p>\n<div   id="j6sjwn9j3u"    style=\"font-size: 14pt; color: white; background-color: black; border-left: red 10px solid; padding-left: 14px; margin-bottom: 20px; margin-top: 20px;\"><strong>\u4e00\u3001\u540c\u670d\u52a1\u7684\u8de8\u5e93\u67e5\u8be2<\/strong><\/div>\n<p>\u540c\u670d\u52a1\u7684\u8de8\u5e93\u67e5\u8be2\u53ea\u9700\u8981\u5728\u5173\u8054\u67e5\u8be2\u7684\u65f6\u5019\u5e26\u4e0a\u6570\u636e\u540d\uff0cSQL\u7684\u5199\u6cd5\u662f\u8fd9\u6837\u7684\uff1aSELECT * FROM \u6570\u636e\u5e931.table1 x JOIN \u6570\u636e\u5e932.table2 y ON x.field1=y.field2;\u4f8b\u5982\uff1a<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/lrxjmw.cn\/wp-content\/uploads\/2020\/07\/62f6abbf9905b05ee4b0ee07b597fdcb.jpeg-wh_651x-s_454036231.jpeg\" alt=\"\" width=\"640\" height=\"382\" class=\"aligncenter size-full wp-image-196066\" srcset=\"https:\/\/lrxjmw.cn\/wp-content\/uploads\/2020\/07\/62f6abbf9905b05ee4b0ee07b597fdcb.jpeg-wh_651x-s_454036231.jpeg 640w, https:\/\/lrxjmw.cn\/wp-content\/uploads\/2020\/07\/62f6abbf9905b05ee4b0ee07b597fdcb.jpeg-wh_651x-s_454036231-300x179.jpeg 300w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/p>\n<div   id="j6sjwn9j3u"    style=\"font-size: 14pt; color: white; background-color: black; border-left: red 10px solid; padding-left: 14px; margin-bottom: 20px; margin-top: 20px;\"><strong>\u4e8c\u3001\u4e0d\u540c\u670d\u52a1\u7684\u8de8\u5e93\u67e5\u8be2<\/strong><\/div>\n<p>\u4e0d\u540c\u670d\u52a1\u7684\u8de8\u5e93\u67e5\u8be2\uff0c\u76f4\u63a5\u901a\u8fc7\u6570\u636e\u540d\u52a0\u8868\u660e\u662f\u65e0\u6cd5\u8fdb\u884c\u5173\u8054\u7684\uff0c\u8fd9\u91cc\u9700\u8981\u7528\u5230MySQL\u6570\u636e\u5e93\u4e2d\u7684federated\u5f15\u64ce\u3002\u5177\u4f53\u8fc7\u7a0b\u5982\u4e0b\uff1a<\/p>\n<p>\u9700\u6c42\uff1a\u670d\u52a1A\u4e0a\u7684\u6570\u636e\u5e93X\u7684\u8868A\u9700\u8981\u5173\u8054\u670d\u52a1B\u4e0a\u7684\u6570\u636e\u5e93Y\u4e2d\u7684\u8868B\uff0c\u67e5\u8be2\u9700\u8981\u7684\u6570\u636e;<\/p>\n<p>1\u3001\u5148\u67e5\u770bMySQL\u6570\u636e\u5e93\u662f\u5426\u5b89\u88c5\u4e86FEDERATED\u5f15\u64ce\uff0c\u901a\u8fc7\u547d\u4ee4show engines;\u5982\u4e0b\u56fe\uff1a<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/lrxjmw.cn\/wp-content\/uploads\/2020\/07\/cf4141784f2f7cbd09a678ce3cedfe58.jpeg-wh_600x-s_1157728331.jpeg\" alt=\"\" width=\"600\" height=\"141\" class=\"aligncenter size-full wp-image-196067\" srcset=\"https:\/\/lrxjmw.cn\/wp-content\/uploads\/2020\/07\/cf4141784f2f7cbd09a678ce3cedfe58.jpeg-wh_600x-s_1157728331.jpeg 600w, https:\/\/lrxjmw.cn\/wp-content\/uploads\/2020\/07\/cf4141784f2f7cbd09a678ce3cedfe58.jpeg-wh_600x-s_1157728331-300x71.jpeg 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p>\u5982\u4e0a\u56fe\u6240\u793a\uff0cMySQL\u5b89\u88c5\u4e86FEDERATED\u5f15\u64ce\uff0c\u4f46Support\u662fNo,\u8868\u793a\u6ca1\u6709\u542f\u7528\uff0c\u53bbmy.cnf\u6587\u4ef6\u672b\u52a0\u4e0a1\u884cFEDERATED\uff0c\u91cd\u542fMySQL\u5373\u53ef\u3002\u82e5\u6ca1\u6709\u627e\u5230FEDERATED\u5f15\u64ce\uff0c\u5219\u9700\u8981\u53bb\u5b89\u88c5\u4e86\u3002<\/p>\n<p>2\u3001\u5728\u670d\u52a1A\u4e0a\u7684\u6570\u636e\u5e93X\u4e2d\u521b\u5efa\u4e00\u4e2a\u8868B\uff0c\u8bed\u53e5\u5982\u4e0b\uff1aCREATE TABLE table_name(\u2026\u2026)ENGINE=FEDERATED CONNECTION='mysql:\/\/[username]:[password]@[localtion]:[port]\/[db-name]\/[table-name]'<\/p>\n<p>\u8bf4\u660e\uff1a\u901a\u8fc7FEDERATED\u5f15\u64ce\u521b\u5efa\u7684\u8868\u53ea\u662f\u5728\u672c\u5730\u6709\u8868\u5b9a\u4e49\u6587\u4ef6\uff0c\u6570\u636e\u6587\u4ef6\u5219\u5b58\u5728\u4e8e\u8fdc\u7a0b\u6570\u636e\u5e93\u4e2d\uff0c\u901a\u8fc7\u8fd9\u4e2a\u5f15\u64ce\u53ef\u4ee5\u5b9e\u73b0\u8fdc\u7a0b\u6570\u636e\u8bbf\u95ee\u529f\u80fd\u3002\u6362\u53e5\u8bdd\u8bf4\uff0c\u8fd9\u79cd\u5efa\u8868\u65b9\u5f0f\u4f1a\u5728\u670d\u52a1A\u4e0a\u7684\u6570\u636e\u5e93X\u4e2d\u521b\u5efa\u4e86\u4e00\u4e2a\u8868\u7ed3\u6784\u6587\u4ef6(\u5373\u670d\u52a1B\u4e0a\u7684\u6570\u636e\u5e93Y\u7684B\u8868\u7684\u8868\u7ed3\u6784\u6587\u4ef6)\uff0c\u8868\u7684\u7d22\u5f15\u3001\u6570\u636e\u7b49\u6587\u4ef6\u8fd8\u5728\u670d\u52a1B\u4e0a\u7684\u6570\u636e\u5e93Y\u4e2d\uff0c\u76f8\u5f53\u4e8e\u4e00\u79cd\u5feb\u6377\u65b9\u5f0f\uff0c\u65b9\u4fbf\u5173\u8054\u3002<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/lrxjmw.cn\/wp-content\/uploads\/2020\/07\/39aba7cd6e5a20d5eb4fe8f69332d5a5.jpeg\" alt=\"\" width=\"640\" height=\"222\" class=\"aligncenter size-full wp-image-196068\" srcset=\"https:\/\/lrxjmw.cn\/wp-content\/uploads\/2020\/07\/39aba7cd6e5a20d5eb4fe8f69332d5a5.jpeg 640w, https:\/\/lrxjmw.cn\/wp-content\/uploads\/2020\/07\/39aba7cd6e5a20d5eb4fe8f69332d5a5-300x104.jpeg 300w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/p>\n<p>3\u3001\u5728\u670d\u52a1A\u4e0a\u7684\u6570\u636e\u5e93X\u4e2d\u76f4\u63a5\u8fdb\u884cA\u8868\u4e0eB\u8868\u5173\u8054\uff0c\u5c31\u53ef\u4ee5\u67e5\u8be2\u51fa\u9700\u8981\u7684\u6570\u636e\u4e86\u3002<\/p>\n<p>\u8fd9\u79cd\u65b9\u5f0f\u6709\u4ee5\u4e0b\u51e0\u70b9\u662f\u9700\u8981\u6ce8\u610f\u7684\uff1a1)\u3001\u8be5\u8de8\u5e93\u67e5\u8be2\u65b9\u5f0f\u4e0d\u652f\u6301\u4e8b\u52a1\uff0c\u6700\u597d\u522b\u4f7f\u7528\u4e8b\u52a1\u30022)\u3001\u4e0d\u80fd\u4fee\u6539\u8868\u7ed3\u6784\u30023)\u3001MySQL\u4f7f\u7528\u8fd9\u79cd\u8de8\u5e93\u67e5\u8be2\u65b9\u5f0f\uff0c\u8fdc\u7a0b\u6570\u636e\u5e93\u76ee\u524d\u4ec5\u652f\u6301MySQL\uff0c\u5176\u4ed6\u6570\u636e\u5e93\u4e0d\u652f\u6301\u30024)\u3001\u8868\u7ed3\u6784\u5fc5\u987b\u548c\u76ee\u6807\u6570\u636e\u5e93\u8868\u5b8c\u5168\u4e00\u81f4\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5728MySQL\u4e2d\u8de8\u5e93\u67e5\u8be2\u4e3b\u8981\u5206\u4e3a\u4e24\u79cd\u60c5\u51b5\uff0c\u4e00\u79cd\u662f\u540c\u670d\u52a1\u7684\u8de8\u5e93\u67e5\u8be2;\u53e6\u4e00\u79cd\u662f\u4e0d\u540c\u670d\u52a1\u7684\u8de8\u5e93\u67e5\u8be2;\u5b83\u4eec\u8fdb\u884c\u8de8\u5e93\u67e5\u8be2\u662f [&hellip;]<\/p>\n","protected":false},"author":317,"featured_media":108865,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[55],"tags":[],"class_list":["post-196058","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thread"],"acf":[],"_links":{"self":[{"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/posts\/196058","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/users\/317"}],"replies":[{"embeddable":true,"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/comments?post=196058"}],"version-history":[{"count":2,"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/posts\/196058\/revisions"}],"predecessor-version":[{"id":196070,"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/posts\/196058\/revisions\/196070"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/media\/108865"}],"wp:attachment":[{"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/media?parent=196058"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/categories?post=196058"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/tags?post=196058"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}