首先放上错误
[SQL]SELECT music.musicname FROM music WHERE music.musicid in(SELECT DISTINCT image.imageid FROM image LIMIT 2);
[Err] 1235 - This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'
SELECT music.musicname FROM music WHERE music.musicid in(SELECT DISTINCT image.imageid FROM image LIMIT 2);
这是错误的sql语句
去掉limit 2
SELECT music.musicname FROM music WHERE music.musicid in(SELECT DISTINCT image.imageid FROM image );
这说明在mysql数据库中limit与in无法同时使用
怎么解决
SELECT music.musicname FROM music WHERE music.musicid in(SELECT aa.imageid FROM (SELECT DISTINCT image.imageid FROM image LIMIT 10)AS aa);
可以正常执行
就像这样,把limit与in再隔开一个查询就行了