A temporary table can be created by adding the keyword TEMPORARY to the CREATE TABLE statement: : Temporary Table « Table Index « SQL / MySQL






  1. SQL / MySQL
  2. Table Index
  3. Temporary Table

A temporary table can be created by adding the keyword TEMPORARY to the CREATE TABLE statement:

     
mysql>
mysql> CREATE TEMPORARY TABLE t (i INT);
Query OK, 0 rows affected (0.00 sec)

mysql>
mysql> drop table t;
Query OK, 0 rows affected (0.00 sec)








Related examples in the same category

1.Using Temporary Tables
2.Give ordinary users the ability to lock (LOCK) tables, create temporary tables, and execute stored procedures.
3.Copying to a Temporary Table
4.Creating Temporary Tables
5.CREATE TEMPORARY TABLE
6.Duplicate table name between normal table and temporary table
7.Memory engine for temporary table
8.Create a TEMPORARY TABLE;