Pre-General Availability Draft: 2017-11-24
MySQL Server doesn't support the
SELECT ... INTO
TABLE Sybase SQL extension. Instead, MySQL Server
INSERT INTO ...
SELECT standard SQL syntax, which is basically the
same thing. See Section 220.127.116.11, “INSERT ... SELECT Syntax”. For example:
INSERT INTO tbl_temp2 (fld_id) SELECT tbl_temp1.fld_order_id FROM tbl_temp1 WHERE tbl_temp1.fld_order_id > 100;