This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery异常解决方法

1.This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'的意思是，这版本的 MySQL 不支持使用 LIMIT 子句的 

select  * from (select order_id from sdb_b2c_order_items as sboi where sboi.source_name = 'etoneo2o')as t1 where t1.order_id in (select order_id from sdb_b2c_order_items_square as sbois) LIMIT 1000;

DELETE from sdb_b2c_order_items where order_id in (select  * from (select order_id from sdb_b2c_order_items as sboi where sboi.source_name = 'etoneo2o')as t1 where t1.order_id in (select order_id from sdb_b2c_order_items_square as sbois) LIMIT 1000);

 

意思就是说MySQL不支持子查询

IN/ALL/ANY/SOME 子查询，即是支持非 IN/ALL/ANY/SOME 子查询的 LIMIT 子查询。

2.解决办法
*********再套一层就完美解决了**************

DELETE from sdb_b2c_order_items where order_id in (select order_id from (select  * from (select order_id from sdb_b2c_order_items as sboi where sboi.source_name = 'etoneo2o')as t1 where t1.order_id in (select order_id from sdb_b2c_order_items_square as sbois) LIMIT 1000)as t3)

结果：

DELETE from sdb_b2c_order_items where order_id in (select order_id from (select  * from (select order_id from sdb_b2c_order_items as sboi where sboi.source_name = 'etoneo2o')as t1 where t1.order_id in (select order_id from sdb_b2c_order_items_square as sbois) LIMIT 1000)as t3)
> Affected rows: 0
> 时间: 0.502s