mysql数据库limit与in无法一起使用

首先放上错误

[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再隔开一个查询就行了