(mysql.info) ansi-diff-select-into-table

Info Catalog

(mysql.info) ansi-diff-subqueries

(mysql.info) differences-from-ansi

(mysql.info) ansi-diff-transactions

 
 1.9.5.2 `SELECT INTO TABLE'
 ...........................
 
 MySQL Server doesn't support the `SELECT ... INTO TABLE' Sybase SQL
 extension. Instead, MySQL Server supports the `INSERT INTO ... SELECT'
 standard SQL syntax, which is basically the same thing. See 
 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'.
 
 As of MySQL 5.0, you can use `SELECT ...  INTO' with user-defined
 variables. The same syntax can also be used inside stored routines
 using cursors and local variables. See  select-into-statement.
 

Info Catalog

(mysql.info) ansi-diff-subqueries

(mysql.info) differences-from-ansi

(mysql.info) ansi-diff-transactions