The following list indicates limitations on the use of
TEMPORARYtable can only be of type
Temporary tables are not supported for MySQL Cluster.
You cannot refer to a
TEMPORARYtable more than once in the same query. For example, the following does not work:
SELECT * FROM temp_table, temp_table AS t2;ERROR 1137: Can't reopen table: 'temp_table'
This error also occurs if you refer to a temporary table multiple times in a stored function under different aliases, even if the references occur in different statements within the function.
SHOW TABLESstatement does not list
You cannot use
RENAMEto rename a
TEMPORARYtable. However, you can use
ALTER TABLE orig_name RENAME new_name;
There are known issues in using temporary tables with replication. See Section 17.4.1, “Replication Features and Issues”, for more information.