The article contains information about the MySQL Temporary Tables used to create a temporary table in MySQL VTY system.<\/p>\n
The Temporary Table feature in MySQL is used to create a virtual table where data is temporarily stored.<\/p>\n
The temporary table created does not appear when the tables are listed by the list command.<\/p>\n
The temporary table allows to use SELECT, INSERT, UPDATE, DELETE statements.<\/p>\n
Temporary tables are deleted when the session expires, as in MySQL variables.<\/p>\n
Creating a temporary table is created in a similar way to SQL table creation, with the TEMPORARY suffix in front of it.<\/p>\n
The following statement is used to create a temporary table.<\/p>\n
CREATE TEMPORARY TABLE my_temp_table_name (\n column1 data_type restriction,\n column2 data_type restriction,\n column3 data_type restriction,\n ....\n);<\/pre>\nTemporary tables are used to store \/ process frequently used data.<\/p>\n
Copy Table to Temporary Table in MySQL<\/h3>\n
Copying existing tables to temporary tables is similar to copying SQL tables. It is copied by putting the TEMPORARY prefix in front of it.<\/p>\n
The following statement is used to copy a table.<\/p>\n
CREATE TEMPORARY TABLE temp_table_name AS\n SELECT column1, column2, ...\n FROM current_table\n WHERE ...;<\/pre>\nYou can also use it in the following ways.<\/p>\n
CREATE TEMPORARY TABLE temp_table_name LIKE current_table;<\/pre>\nINSERT temp_table_name SELECT * FROM current_table WHERE ...;<\/pre>\nTemporary table names can be the same as existing table names.<\/p>\n
That is, even if there is a table named category, you can create a temporary table named category.<\/p>\n
However, when the categories table is listed, the data in the temporary table are listed.<\/p>\n
Also, the data added to the temporary table will be deleted when the session ends, so it may give undesired results.<\/p>\n
<\/div>\n