|
mysql> Select * from value1;
+-----+-----+
| i | j |
+-----+-----+
| 1 | 1 |
| 2 | 2 |
+-----+-----+
2 rows in set (0.00 sec)
mysql> Select * from value2;
+------+------+
| i | j |
+------+------+
| 1 | 1 |
| 3 | 3 |
+------+------+
2 rows in set (0.00 sec) Now, the following query will do the DIFFERENCE between tables ‘value1’ and ‘value2’ − mysql> Select * from value1 left join value2 using(i,j) where value2.i is NULL UNION Select * from value2 left join value1 using(i,j) Where value1.i is NULL;
+------+-----+
| i | j |
+------+-----+
| 2 | 2 |
| 3 | 3 |
+-----+------+
2 rows in set (0.07 sec) 登录后复制 |
