最近项目常用的几条Mysql查询语句汇总

1、将查询结果直接写入数据库中的表（已经建好）

INSERT INTO final_song_avescore
SELECT * FROM songidavescore WHERE SongId IN (
                   SELECT SongID  FROM user_seed
);

2、显示联合查询结果

SELECT SeedID FROM `seed_songid` WHERE SeedID NOT IN (
                   SELECT SeedID FROM final_seed
)

3、分组查询语句

SELECT SeedID,COUNT(SongID) AS 'Song Count' FROM seed_songid GROUP BY SeedID ORDER BY COUNT(SongID) DESC;