- MySQL doesn’t yet support the Oracle SQL extension: SELECT … INTO TABLE …. MySQL supports instead the ANSI SQL syntax INSERT INTO … SELECT …, which is basically the same thing.
- Alternatively, you can use SELECT INTO OUTFILE… or CREATE TABLE … SELECT to solve your problem.