USING等价于join on中的on,联合查询时会用到
例如:
select a.id,b.name from table_a a join table_b b on a.id = b.id
等价于:
select a.id,b.name from table_a a join table_b b USING(id)
USING等价于join on中的on,联合查询时会用到
例如:
select a.id,b.name from table_a a join table_b b on a.id = b.id
等价于:
select a.id,b.name from table_a a join table_b b USING(id)
Google Chrome
Windows 10
Google Chrome
Windows 10