ERROR 1235 (42000): This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'问题的解...

1、与limit相关的sql语句作为临时表
select * from 临时表
select B.id from (select id from test where id>100 limit 30) as B
缺点：只能查临时表的数据
2、可以查原表的数据
select * from test where id in(临时表)
select * from test where id in(select B.id from (select id from test where id>100 limit 30) as B order by B.id desc limit 10) as foo;

 

转载于:https://www.cnblogs.com/wt7018/p/11117321.html