最近遇到一个需要在in里面写limit子查询的情况,然后执行SQL的时候就遇到这个错误:
Error Code: 1235. This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery',
比如查询是:
select * from owner_ship where owner_id in (select id from user limit 4);
MySQL不支持在IN里面有limit,解决办法是再多嵌套一重子查询:
select * from owner_ship where owner_id in (select id from (select id from user limit 4)t);
虽然性能上又差了一点,但是至少解决了目前的问题,应该比增加SQL的数量要好一些。