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?
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.