使用mysql数据库编写sql语句时,可能会遇到如下情况:
select * from sms_content
where id in (SELECT id from sms_content limit 0,5);
出现错误:
[SQL]select * from sms_content
where id in (SELECT id from sms_content limit 0,5);
[Err] 1235 - This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'
mysql当中limit和in不能同时使用。
如何解决这个问题呢?可以将sql语句改为如下:
select * from sms_content
where id in
(select sc.id from (select id from sms_content LIMIT 0,5)as sc);
这样再加一层select就可以绕过limit和in不能一起使用的尴尬场景了!