This version of MySQL doesn't yet support 'limi... Solution

This version of MySQL doesn't yet support 'limi... resolving This version of MySQL doesn't yet support 'limit & IN/ALL/ANY/SOME subquery' means, mySQL of this version does not support IN/ALL/ANY/SOME subqueries using the LIMIT clause, that is, LIMIT subqueries that support non-IN/ALL/ANY/SOME subqueries. That is to say, such statements cannot be correctly executed.

Select * from table where id in (select id from table limit 10)

 

However, you only need to add one more layer .. For example:

Select * from table where id in (select t. id from (select * from table limit 10) as t)