GNU Info

(mysql.info)Temporary table problems

---

Prev: Change column order Up: Table Definition Issues

---

Enter node , (file) or (file)node

TEMPORARY TABLE problems
------------------------

The following are a list of the limitations with `TEMPORARY TABLES'.

   * A temporary table can only be of type `HEAP', `ISAM' or `MyISAM'.

   * You can't use temporary tables more than once in the same query.
     For example, the following doesn't work.

          select * from temporary_table, temporary_table as t2;

     We plan to fix the above in 4.0.

   * You can't use `RENAME' on a `TEMPORARY' table.  Note that `ALTER
     TABLE org_name RENAME new_name' works!

     We plan to fix the above in 4.0.