A very important feature in any database tables are temporary tables, with them you can create a table in a separate part of the database that will automatically deleted when the connection to the user is finished. They are widely used by DBAs on several occasions, a practical example of using this feature is when you need to perform inserts into a table from the SELECT statement, validating the earlier records and thus optimizing data entry.
In MySQL, temporary tables can be easily created using the following syntax:
CREATE TEMPORARY TABLE [Table name]
To illustrate, we will create a table of simple products.
CREATE TEMPORARY TABLE tbl_Product_Temp
cd_Prod INTEGER NOT NULL,
Name VARCHAR(100) NOT NULL
Just like a normal table, the SELECT, INSERT, UPDATE and DELETE will work exactly the same for temporary tables.
MySQL has, in addition to temporary tables, several features that really make it a great option. Learn the advantages of working with MySQL on projects using PHP language on our official page and understand why MySQL is so popular.