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]

(

[Fields]

)

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.

SELECT *

FROM tbl_Product_Temp

mysql

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.

You might also like…

PROCESAMIENTO AJAX EN SCRIPTCASE

Ajax en los formularios de Scriptcase puede usarse para recargar un campo de tipo de select basado e...

IMPORTAR IMAGENES DE LA BASE DE DATOS Y UTILIZAR CLASES DE BOOSTRAP

Como muchas personas ya saben, Bootstrap es una biblioteca de front-end libre y de código abierto p...

TENDENCIAS DE DESARROLLO WEB PARA 2017

Usted verá en este post tendencias para 2017 en Diseño Web, en el medio digital y en el desarrollo...

Comment this post

Get new posts, resources, offers and more each week.

We will use the information you provide to update you about our Newsletter and Special Offers. You can unsubscribe any time you want by clinck in a link in the footer of any email you receive from us, or by contacting us at sales@scriptcase.net. Learn more about our Privacy Police.