MySQL – Create temporary table

mysql-tutorials

How to create and drop Temporary table in MySQL 

In MySQL, a temporary table is a special type of table that allows you to store a temporary result set.

A temporary table is very handy when it is impossible or expensive to query data that requires a single SELECT statement with the JOIN clauses. In this case, you can use a temporary table to store the immediate result and use another query to process it.

Create Temporary table SynTax

CREATE TEMPORARY TABLE <<NEW TABLE>> SELECT * FROM EMPLOYEE

Drop Temporary Table in MySQL

DROP TEMPORARY TABLE vsCustomerScore;

Related posts

Leave a Comment