常用SQL语句

1、在一个表内，查询专辑下视频大于500的专辑

SELECT album_id,COUNT(video_id) FROM e.o GROUP BY album_id  ORDER BY COUNT(video_id) DESC

 

---

2.更新语句

 UPDATE monitor_list SET `status`=1 WHERE name LIKE '%无线_广告%'