Documentation Home
MySQL 9.3 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 40.8Mb
PDF (A4) - 40.9Mb
Man Pages (TGZ) - 261.1Kb
Man Pages (Zip) - 368.3Kb
Info (Gzip) - 4.1Mb
Info (Zip) - 4.1Mb


1.7.2.1 SELECT INTO TABLE Differences

MySQL Server doesn't support theSELECT ... INTO TABLE Sybase SQL extension. Instead, MySQL Server supports theINSERT INTO ... SELECT standard SQL syntax, which is basically the same thing. SeeSection 15.2.7.1, “INSERT ... SELECT Statement”. 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 useSELECT ... INTO OUTFILE orCREATE TABLE ... SELECT.

You can useSELECT ... INTO with user-defined variables. The same syntax can also be used inside stored routines using cursors and local variables. SeeSection 15.2.13.1, “SELECT ... INTO Statement”.