Temporary Table « Table Index « SQL / MySQL






  1. SQL / MySQL
  2. Table Index
  3. Temporary Table
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.Memory engine for temporary table
9.Create a TEMPORARY TABLE;