mySQL: Create a temp table

 Quick reference: Create a temp table in mySQL

CREATE TABLE table_t1 (c1 int) ENGINE=MyISAM;

CREATE TABLE table_t2 (c1 int) ENGINE=MEMORY;

CREATE TEMPORARY TABLE table_t3 (c1 int) ENGINE=MyISAM;

CREATE TEMPORARY TABLE table_t4 (c1 int) ENGINE=MEMORY;

Related docs page:

8.4.4 Internal Temporary Table Use in MySQL