MySQL does not support the use of the limit solution in subqueries

MySQL does not support the use of the limit solution in subqueries

This version of MySQL doesn ' t yet support ' LIMIT & in/all/any/some subquery '

The use of the Limit keyword in a subquery is not supported in the literal sense.

After searching, an alternative solution was found.

is to add a sub-query to the outer layer of the limit subquery.

Like what:

The original SQL statement that could have been an error is: Select *from cidy where ID in (select ID from cidy limit 0,10);

The modified SQL is: Select *from cidy where ID in (select ID from cidy limit 0,10);

Tested, modified SQL statement execution times error: Every derived table must has its own alias

The literal meaning of the error is: Aliases required

As you can see from the SQL statement above, our extra layer of SQL not only has no alias and no table name, is there a problem here? You'll find out if you test it.

The modified SQL statement is: SELECT *from cidy where ID in (SELECT ID from (SELECT ID from Cidy limit 0,10) as CD);

After testing, as we have thought, finally succeeded.

MySQL does not support the use of the limit solution in subqueries