DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH
 

(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