\u5148\u75282\u5f20\u56fe\u76f4\u89c2\u7684\u8868\u793a\u4e00\u4e0b\u5404\u79cdjoin\u7684\u4f5c\u7528\uff1a<\/p>\n
![\"\"](\"https:\/\/ixyzero.com\/blog\/wp-content\/uploads\/2018\/12\/Visual_SQL_JOINS_orig.jpg\")
<\/p>\n
&<\/p>\n
![\"\"](\"https:\/\/ixyzero.com\/blog\/wp-content\/uploads\/2018\/12\/sql-joins.png\")
<\/p>\n
\u7136\u540e\u518d\u901a\u8fc7\u4e00\u4e9b\u672c\u5730\u73af\u5883\u9020\u6570\u636e\u8fdb\u884c\u6d4b\u8bd5\u4ee5\u52a0\u6df1\u5f71\u54cd\uff1a<\/p>\n
\/*\r\n\u521b\u5efa\u6d4b\u8bd5\u8868\r\n*\/\r\nCREATE DATABASE `do_test` \/*!40100 DEFAULT CHARACTER SET utf8 *\/;\r\nUSE do_test;\r\n\r\nCREATE TABLE `table1` (\r\n `id` int(11) unsigned NOT NULL AUTO_INCREMENT,\r\n `name` varchar(100) NOT NULL,\r\n `sex` varchar(100) NOT NULL,\r\n `age` int(11) unsigned,\r\n PRIMARY KEY (`id`)\r\n) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;\r\n\r\nCREATE TABLE `table2` (\r\n `id` int(11) unsigned NOT NULL AUTO_INCREMENT,\r\n `name` varchar(100) NOT NULL,\r\n `sex` varchar(100) NOT NULL,\r\n `age` int(11) unsigned,\r\n PRIMARY KEY (`id`)\r\n) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4\r\n\r\n\r\n\/*\r\n\u586b\u5145\u6d4b\u8bd5\u6570\u636e\r\n*\/\r\nINSERT INTO `table1`\r\n\t(name, age, sex)\r\nVALUES\r\n\t('Pirate', 22, 'male'),\r\n\t('Monkey', 19, 'male'),\r\n\t('Ninja', 26, 'female'),\r\n\t('Spaghetti', 25, 'male')\r\n;\r\n\r\nINSERT INTO `table2`\r\n\t(name, age, sex)\r\nVALUES\r\n\t('Rutabaga', 22, 'female'),\r\n\t('Pirate', 22, 'male'),\r\n\t('Darth Vader', 25, 'male'),\r\n\t('Ninja', 26, 'female')\r\n;\r\n\r\n\r\n\/*\r\n\u8fdb\u884c\u6d4b\u8bd5\r\n*\/\r\n-- \u4ee5\u4e0b\u4e24\u53e5SQL\u7684\u529f\u80fd\u7b49\u4ef7\r\nselect A.id,A.name,B.name from table1 A, table2 B where A.id = B.id;\r\nselect A.id,A.name,B.name from table1 A inner join table2 B on A.id = B.id;\r\n\r\n-- \u4ee5\u4e0b\u4e24\u53e5SQL\u7684\u529f\u80fd\u7b49\u4ef7\r\nselect A.id,A.name,B.name from table1 A, table2 B where A.name = B.name;\r\nselect A.id,A.name,B.name from table1 A inner join table2 B on A.name = B.name;\r\n\r\nselect * from table1 A left join table2 B on A.name = B.name;\r\n\r\nselect * from table1 A left join table2 B on A.name = B.name where A.id is null or B.id is null;\r\n\r\nselect * from table1 A right join table2 B on A.name = B.name;\r\n<\/pre>\n <\/p>\n
\u53c2\u8003\u94fe\u63a5\uff1a<\/h5>\n\n- Mysql Join\u8bed\u6cd5\u89e3\u6790\u4e0e\u6027\u80fd\u5206\u6790
\nhttps:\/\/www.cnblogs.com\/BeginMan\/p\/3754322.html<\/a><\/li>\n- MySQL JOIN \u591a\u8868\u8fde\u63a5
\nhttps:\/\/www.cnblogs.com\/xiaofeng028\/p\/4098965.html<\/a>
\nhttp:\/\/www.5idev.com\/p-php_mysql_join_multi_table.shtml<\/a><\/li>\n- Mysql \u8fde\u63a5\u7684\u4f7f\u7528 #\u6709\u63d0\u4f9b\u6d4b\u8bd5SQL<\/span>
\nhttp:\/\/www.runoob.com\/mysql\/mysql-join.html<\/a><\/li>\n- MySQL\u591a\u8868\u8fde\u63a5\u67e5\u8be2
\nhttps:\/\/www.cnblogs.com\/geaozhang\/p\/6753190.html<\/a><\/li>\n- MySQL\u4e2d\u7684\u5404\u79cdjoin
\nhttp:\/\/wxb.github.io\/2016\/12\/15\/MySQL%E4%B8%AD%E7%9A%84%E5%90%84%E7%A7%8Djoin.html<\/a><\/li>\n- \u56fe\u89e3 SQL \u91cc\u7684\u5404\u79cd JOIN #nice<\/strong><\/span>
\nhttps:\/\/mazhuang.org\/2017\/09\/11\/joins-in-sql\/<\/a><\/li>\n- MySQL\u591a\u8868\u5173\u8054\u67e5\u8be2\u6548\u7387\u9ad8\u70b9\u8fd8\u662f\u591a\u6b21\u5355\u8868\u67e5\u8be2\u6548\u7387\u9ad8\uff0c\u4e3a\u4ec0\u4e48\uff1f
\nhttps:\/\/www.zhihu.com\/question\/68258877<\/a><\/li>\n- Visual Representation of SQL Joins
\nhttps:\/\/www.codeproject.com\/Articles\/33052\/Visual-Representation-of-SQL-Joins<\/a><\/li>\n<\/ul>\n=END=<\/p>\n","protected":false},"excerpt":{"rendered":"
=Start= \u7f18\u7531\uff1a \u56e0\u4e3a\u5728\u5927\u5b66\u7684\u65f6\u5019SQL\u5b66\u7684\u4e0d\u624e\u5b9e\uff0c\u540e\u6765\u5de5\u4f5c\u4e2d\u4e5f\u6ca1\u6709\u4e13\u95e8\u6df1\u5165\u4e86\u89e3\u8fc7\uff0c\u867d\u7136\u4e00\u4e9b\u5e38\u89c4\/\u5e38\u89c1\u529f […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14,23,7],"tags":[421,1262],"class_list":["post-4211","post","type-post","status-publish","format-standard","hentry","category-database","category-knowledgebase-2","category-programing","tag-join","tag-sql"],"views":12162,"_links":{"self":[{"href":"https:\/\/ixyzero.com\/blog\/wp-json\/wp\/v2\/posts\/4211","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ixyzero.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ixyzero.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ixyzero.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ixyzero.com\/blog\/wp-json\/wp\/v2\/comments?post=4211"}],"version-history":[{"count":2,"href":"https:\/\/ixyzero.com\/blog\/wp-json\/wp\/v2\/posts\/4211\/revisions"}],"predecessor-version":[{"id":4215,"href":"https:\/\/ixyzero.com\/blog\/wp-json\/wp\/v2\/posts\/4211\/revisions\/4215"}],"wp:attachment":[{"href":"https:\/\/ixyzero.com\/blog\/wp-json\/wp\/v2\/media?parent=4211"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ixyzero.com\/blog\/wp-json\/wp\/v2\/categories?post=4211"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ixyzero.com\/blog\/wp-json\/wp\/v2\/tags?post=4211"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}