mysql使用技巧 行类视图子查询
时间：2021-07-01 10:21:17
帮助过：23人阅读
c.name,
COUNT(f.film_id)
AS amount
FROM film
AS f, film_category
AS fc, category
AS c,
(SELECT category_id
FROM film_category
GROUP BY category_id
HAVING COUNT(category_id)
>= 5)
AS cc
WHERE f.description
LIKE ‘%robot%‘
AND f.film_id
= fc.film_id
AND fc.category_id
= c.category_id
AND c.category_id
= cc.category_id
mysql使用技巧 行类视图子查询
标签：key font where cell 分类 使用 mount 而且 creat
