MySQL Server doesn't support the SELECT ... INTO TABLE Sybase SQL extension. MySQL Server不支持SELECT ... INTO TABLE Sybase SQL扩展。Instead, MySQL Server supports the INSERT INTO ... SELECT standard SQL syntax, which is basically the same thing. 相反，MySQL Server支持INSERT INTO ... SELECT标准SQL语法，基本上是一样的。See Section 13.2.6.1, “INSERT ... SELECT Statement”. 请参阅第13.2.6.1节，“INSERT ... SELECT语句”。For example:例如：

INSERT INTO tbl_temp2 (fld_id)
    SELECT tbl_temp1.fld_order_id
    FROM tbl_temp1 WHERE tbl_temp1.fld_order_id > 100;

Alternatively, you can use SELECT ... INTO OUTFILE or CREATE TABLE ... SELECT.或者，您可以使用SELECT ... INTO OUTFILE或CREATE TABLE ... SELECT。

You can use SELECT ... INTO with user-defined variables. The same syntax can also be used inside stored routines using cursors and local variables. 您可以使用SELECT ... INTO与用户定义的变量。同样的语法也可以在使用游标和局部变量的存储例程中使用。See Section 13.2.10.1, “SELECT ... INTO Statement”.请参阅第13.2.10.1节，“SELECT ... INTO语句”。