No of visitors who read this post:
229
Category:
MySQL Server
Type:
Question
Author:
Mega Joe Gardner
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?
- Login or Signup Now to post comments
CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name
[(create_definition,...)]
[table_options]
[partition_options]
select_statement
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
MyISAMtable 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.