using 等价于 join 操作中的 on,如:
SELECT id FROM table1 AS a
JOIN table2 AS b
ON a.id=b.id
等价于:
SELECT id FROM table1 AS a
JOIN table2 AS b
using(id)
using 等价于 join 操作中的 on,如:
SELECT id FROM table1 AS a
JOIN table2 AS b
ON a.id=b.id
等价于:
SELECT id FROM table1 AS a
JOIN table2 AS b
using(id)
本文标题:MySQL USING 用法
本文链接:https://www.haomeiwen.com/subject/nokmxktx.html
网友评论