Memory engine for temporary table

     
mysql>
mysql> CREATE TEMPORARY TABLE SUMPENALTIES
    ->    (TOTAL DECIMAL(10,2))
    ->    ENGINE = MEMORY;
mysql>

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.	A temporary table can be created by adding the keyword TEMPORARY to the CREATE TABLE statement:
6.	CREATE TEMPORARY TABLE
7.	Duplicate table name between normal table and temporary table
8.	Create a TEMPORARY TABLE;

Memory engine for temporary table : Temporary Table « Table Index « SQL / MySQL