(mysql.info.gz) ANSI diff SELECT INTO TABLE
Info Catalog
(mysql.info.gz) ANSI diff Subqueries
(mysql.info.gz) Differences from ANSI
(mysql.info.gz) ANSI diff Transactions
1.5.5.2 `SELECT INTO TABLE'
...........................
MySQL Server doesn't support the Sybase SQL extension: `SELECT ... INTO
TABLE ...'. Instead, MySQL Server supports the standard SQL syntax
`INSERT INTO ... SELECT ...', which is basically the same thing.
`INSERT SELECT' INSERT SELECT.
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'.
From version 5.0, MySQL supports `SELECT ... INTO' with user variables.
The same syntax may also be used inside stored procedures using cursors
and local variables. SELECT INTO Statement.
Info Catalog
(mysql.info.gz) ANSI diff Subqueries
(mysql.info.gz) Differences from ANSI
(mysql.info.gz) ANSI diff Transactions
automatically generated byinfo2html