Syntax of creating a temporary table in MariaDB or MySQL

Create Temporary Table

Create temporary table is simple just place temporary while using create table command in MySQL or MariaDB:

create temporary table temp_employees
(
id int Primary key,
emp_name varchar(500),
emp_address varchar(500),
)

Create a temporary table from the existing table:

CREATE TEMPORARY TABLE temp_employees
SELECT * FROM employee where 1 = 0;

Note: Temporary table is used at the session level. Once the session closed the temporary table also dropped.

Drop the temporary table:

Drop temporary table temp_employees

Insert statement with temporary table like a base table:

insert into temp_employees(id, emp_name, emp_address)
values
 (201,'Alok Sharma','House No:30 New Delhi');