Examples of MYSQL Temporary Table
In this example, we are going to talk about MySQL Temporary Table. First of all, let’s create a Temporary table named StudentDetailsTemp.
Example:
CREATE TEMPORARY TABLE StudentDetailsTemp(
id int PRIMARY KEY,
name varchar(255),
gender char(1),
age int
);
Output:
CREATE TEMPORARY TABLE
Now, to see the structure of the temporary table created above, we can use the DESC keyword just like how you see the structure of the normal table.
DESC StudentDetailsTemp;
DESCRIBE TABLE
MySQL Temporary Table
Do you want to store the intermediate results of your query in some table but only for a given DB session and not persist for the lifetime? Is there some way to hold temporary data for a short time without making it permanent on the database forever? If you have ever thought about this and wondered how to do that, then you have arrived at the right place. In this article, we will take a brief look at how to store intermittent data temporarily.
As the name suggests, Temporary Tables are used when we need to store data temporarily. A Temporary Table is a special kind of table that is not stored in the DB but persists while the current database session is active in which that temporary table was created. The Temporary Tables help us to store and process intermediate results.
In this article, we will look at what a Temporary Table is, how to create and insert data, and how to drop temporary tables along with their syntax with the help of various examples.