Temporary table
Temporary table :
TEMPORARY table is visible only to the current connection, and is dropped automatically when the connection is closed. To create temporary tables, We must have the CREATE TEMPORARY TABLES privilege.
CREATE TEMPORARY TABLE does not automatically commit the current active transaction .
Syntax:
CREATE TEMPORARY TABLE table_name(field1 type,field2 type,field3 type, . . . .)
Example:
CREATE TEMPORARY TABLE temp_table (name varchar(20),……);
