Copying to a Temporary Table : Temporary Table « Table Index « SQL / MySQL






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

Copying to a Temporary Table

     

CREATE TEMPORARY TABLE <new_table_name>
SELECT * FROM <old_table_name>;








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.Creating Temporary Tables
4.A temporary table can be created by adding the keyword TEMPORARY to the CREATE TABLE statement:
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;