Test your skills
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?
CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name
For creating the table in MySql you have the privileges to creating the table.
If a temporary table already exist in your data base the there will a error which shows that the temporary table is already exists in the data base. When you create the temp table it creates in the a MyISAM table storage engine of your data base. MySQL does not suppor the InnoDB for creating the temp tables.
Yes by creating the temp table you can speed up your MYSQL DB.