(mysql.info) temporary-table-problems
Info Catalog
(mysql.info) change-column-order
(mysql.info) 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;
* There are known issues in using temporary tables with replication.
See replication-features, for more information.
Info Catalog
(mysql.info) change-column-order
(mysql.info) table-definition-issues
automatically generated byinfo2html