How to implement INTERSECTION between tables with the help of MySQL connection?

Actually, INTERSECTION is just an inner join of all columns. Let's take two tables as an example, the data is as follows -

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 perform the intersection between these tables -

mysql> Select * from value1 join value2 using(i,j);
+------+------+
| i    | j    |
+------+------+
| 1    | 1    |
+------+------+
1 row in set (0.08 sec)

The above is the detailed content of How to implement INTERSECTION between tables with the help of MySQL connection?. For more information, please follow other related articles on the PHP Chinese website!