--执行失败的sql
select * from table where id in (select id from table limit 10);
改为如下,子查询多嵌套一层
select * from table where id in (select t.id from (select * from table limit 10)as t)
感谢原文
--执行失败的sql
select * from table where id in (select id from table limit 10);
改为如下,子查询多嵌套一层
select * from table where id in (select t.id from (select * from table limit 10)as t)
感谢原文