講的不錯,從實質出發(fā),鞭辟入里;那些 雞蛋里挑骨頭的 sb,不看滾蛋 ,有本事,你丫也出教程,也給講講?眼高手低的低素質SB
2018-03-13
SELECT actor.first_name,actor.last_name,COUNT(*)
FROM actor
INNER JOIN film_actor USING(actor_id)
GROUP BY actor.actor_id;
actor和film_actor換一下,也沒產(chǎn)生臨時表。
FROM actor
INNER JOIN film_actor USING(actor_id)
GROUP BY actor.actor_id;
actor和film_actor換一下,也沒產(chǎn)生臨時表。
2018-03-08
為什么不直接使用左外連接:EXPLAIN SELECT a.first_name, a.last_name, count(*) FROM film_actor f LEFT JOIN actor a USING (actor_id) GROUP BY f.actor_id
2018-02-02