The following list indicates limitations on the use of
TEMPORARY table can only be of type
You cannot refer to a
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 TABLES statement
does not list
You cannot use
RENAME to rename a
TEMPORARY table. However, you can use
ALTER TABLE instead:
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.
Temporary tables created outside stored functions and referred to across multiple calling and callee functions might result in this error:
ERROR 1137: Can't reopen table: '