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

2024-09-06 15:42:36

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;

最新文章

热门文章