mysql中的using

mysql 中using

The USING(column_list) clause names a list of columns that must exist in both tables. If tables a and b both contain columns c1, c2, and c3, the following join compares corresponding columns from the two tables

a LEFT JOIN b USING (c1, c2, c3)

也就是说要使用using,那么表a和表b必须要有相同的列

如:

select tb1.* from tb1 inner join tb2 on tb1.id=tb2.id

也可以写成

select tb1.* from tb1 inner join tb2 using(id)