MySQL全连接(Full Join)实现

时间:2014-03-10 17:22:25   收藏:0   阅读:1311
MySQL本身不支持你所说的full join(全连接),但可以通过union来实现
下面是一个简单测试,可以看看:

mysql> CREATE TABLE a(id int,name char(1)); 
Query OK, 0 rows affected (0.00 sec)

mysql> CREATE TABLE b(id int,name char(1)); 
Query OK, 0 rows affected (0.00 sec)

mysql> INSERT INTO a VALUES(1,‘a‘),(2,‘b‘); 
Query OK, 2 rows affected (0.00 sec)
Records: 2 Duplicates: 0 Warnings: 0

mysql> INSERT INTO b VALUES(2,‘b‘),(3,‘c‘);
Query OK, 2 rows affected (0.00 sec)
Records: 2 Duplicates: 0 Warnings: 0

mysql> SELECT * FROM a LEFT JOIN b ON a.id=b.id 
-> UNION 
-> SELECT * FROM a RIGHT JOIN b ON a.id=b.id;
+------+------+------+------+
| id | name | id | name |
+------+------+------+------+
| 1 | a | NULL | NULL |
| 2 | b | 2 | b |
| NULL | NULL | 3 | c |
+------+------+------+------+
3 rows in set (0.00 sec)
mysql>
 
参考:http://www.artfulsoftware.com/infotree/queries.php
更多:http://www.jb51.net/article/20798.htm
http://bbs.csdn.net/topics/220062899

MySQL全连接(Full Join)实现,布布扣,bubuko.com

原文:http://www.cnblogs.com/youxin/p/3591779.html

评论(0
© 2014 bubuko.com 版权所有 - 联系我们:wmxa8@hotmail.com
打开技术之扣,分享程序人生!