Is it possible to create temporary MYSQL table?

Asked By Mega Joe Gardner 20 points N/A Posted on - 06/06/2012

I would like to know whether it is possible to create temporary MYSQL table like that in SQL Server.

And Oracle using PL/SQL language.

Will it affect the data fetching speed or time?

• Status: Open
• Question Views: 1092
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MySQL Server

Answered By Harold Ances 0 points N/A #151698

Is it possible to create temporary MYSQL table?

For creating the table in MySQL you have the privileges to creating the table.

If a temporary table already exist in your database the there will a error which shows that the temporary table is already exists in the database. When you create the temp table it creates in the a MyISAM table storage engine of your database.

MySQL does not support the InnoDB for creating the temp tables.

Yes by creating the temp table you can speed up your MYSQL DB.

You may download the code that attached below.

About Harold Ances

Questions
0

Answers
20

Best Answers
2

• Vote Up 0 Vote Down

• Posted on - 06/13/2012
• Question Category: MySQL Server