(mysql.info.gz) Temporary table problems

Info Catalog

(mysql.info.gz) Change column order

(mysql.info.gz) Table Definition Issues

 
 A.7.3 `TEMPORARY TABLE' Problems
 --------------------------------
 
 The following list indicates limitations on the use of `TEMPORARY'
 tables:
 
    * A `TEMPORARY' table can only be of type `HEAP', `ISAM', `MyISAM',
      `MERGE', or `InnoDB'.
 
    * You cannot refer to a `TEMPORARY' table more than once in the same
      query.  For example, the following does not work:
 
           mysql> SELECT * FROM temp_table, temp_table AS t2;
           ERROR 1137: Can't reopen table: 'temp_table'
 
    * The `SHOW TABLES' statement does not list `TEMPORARY' tables.
 
    * You cannot use `RENAME' to rename a `TEMPORARY' table.  However,
      you can use `ALTER TABLE' instead:
 
           mysql> ALTER TABLE orig_name RENAME new_name;
 
 

Info Catalog

(mysql.info.gz) Change column order

(mysql.info.gz) Table Definition Issues