A TEMPORARY table can only be of type HEAP, 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 Section 6.8, “Replication Features and Known Problems”, for more information.