GNU Info

(mysql.info)Missing SELECT INTO TABLE

---

Next: Missing Transactions Prev: Missing Sub-selects Up: Missing functions

---

Enter node , (file) or (file)node

`SELECT INTO TABLE'
...................

MySQL doesn't yet support the Oracle SQL extension: `SELECT ... INTO
TABLE ...'.  MySQL supports instead the ANSI SQL syntax `INSERT INTO
... SELECT ...', which is basically the same thing. Note: INSERT
SELECT.

     INSERT INTO tblTemp2 (fldID) SELECT tblTemp1.fldOrder_ID FROM tblTemp1 WHERE
     tblTemp1.fldOrder_ID > 100;

Alternatively, you can use `SELECT INTO OUTFILE...' or `CREATE TABLE
... SELECT' to solve your problem.