MySQL报错：This version of MySQL doesn’t yet support ‘LIMIT & IN/ALL/ANY/SOME

最近使用MySQL5.6查询表的前几条数据，使用了limit语句，结果出现错误：This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery';

查询资料发现是内层select语句不能带有limit语句，如下：

select t1.* 
from t1
where t1.id in (select t.id from t limit 0,2);

执行上述语句会报错 1235 - This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery';

可将上述语句改为

select t1.*
from t1
where t1.id in(select t2.* from(select t.id from t limit 0,2) as t2);

参考博文：http://blog.chinaunix.net/uid-22414998-id-2945656.html
原文：https://blog.csdn.net/u012161134/article/details/51393816