The following will not work in MySQL:
SELECT * from table WHERE id IN (SELECT id from table2)
MySQL only supports INSERT ... SELECT... and REPLACE
... SELECT.... Independent sub-selects will be probably be available in
3.22.0. One can now use the function IN() in other context
however.
Go to the first, previous, next, last section, table of contents.