sql - 两个 mysql 查询，相同的结果 : is one better then the other?

Question

这两个 mysql 查询返回相同的结果集。要么给我我想要的结果。但是一个比另一个更可取吗？

SELECT links.*, users.user_name 
FROM links 
LEFT JOIN terms 
ON links.link_id = terms.terms_link_id 
LEFT JOIN users 
ON links.link_user = users.user_id 
WHERE terms.terms_tag_id = ?

-

SELECT links.*, users.user_name 
FROM links, users, terms 
WHERE links.link_id = terms.terms_link_id 
AND links.link_user = users.user_id 
AND terms.terms_tag_id = ?

Answer 1

看起来这回答了您的问题: Inner join vs Where