MySQL三种关联查询的方式_ ON vs USING vs 传统风格or USING
(film id
)WHERE
actor id
17 AND
gth
但下面这个就不行:
film. tit
le
FROM
film
JOIN
film act
or oN
(film. fi
lm id=
film act
or·fi1m
d
W豆ERE
actor id
17 AND
i⊥m
en
120;三RRO
R1052
(23000)
Column
i film id
i in
field
⊥
看看下面三个关联查询的 SQL 语句有何区别?
SELECT * FROM film JOIN film_actor ON (film.film_id = film_actor.film_id)
SELECT * FROM film JOIN film_actor USING (film_id)
SELECT * FROM film, film_actor WHERE film.film_id = film_actor.film_id
最大的不同更多是语法糖,但有一些有意思的东西值得关