Temporary Tables : Temporary Table « Table « MySQL Tutorial

1. MySQL Tutorial
2. Table
3. Temporary Table

Temporary tables are fleeting in nature lasting only for the length of the MySQL session.

The syntax for creating temporary tables is:

CREATE TEMPORARY TABLE <table> (
      field definitions
 );

mysql>
mysql> CREATE TEMPORARY TABLE temp (
    ->      id int
    -> );
Query OK, 0 rows affected (0.00 sec)

mysql>
mysql> show tables;
Empty set (0.00 sec)

mysql>
mysql> drop TEMPORARY TABLE temp;
Query OK, 0 rows affected (0.00 sec)