逗号分隔的联接与MySQL中的语法联接有什么区别? [英] What's the difference between comma separated joins and join on syntax in MySQL?
本文介绍了逗号分隔的联接与MySQL中的语法联接有什么区别?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
例如,如果我要创建一个表"Person",该表的"id"列引用表"Worker"中的"id"列
For example if I were to have a table "Person" with a column "id" that references a column "id" in table "Worker"
这两个查询之间有什么区别?它们产生相同的结果.
What would the difference between these two queries be? They yield the same results.
SELECT *
FROM Person
JOIN Worker
ON Person.id = Worker.id;
和
SELECT *
FROM Person,
Worker
WHERE Person.id = Worker.id;
谢谢
推荐答案
完全没有区别.
第二种表示形式使查询更具可读性,并使得对于哪个联接对应于哪个条件看起来非常清楚.
Second representation makes query more readable and makes it look very clear as to which join corresponds to which condition.
这篇关于逗号分隔的联接与MySQL中的语法联接有什么区别?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文