MOCKSTACKS
EN
Questions And Answers

More Tutorials









MYSQL Temporary Tables

Create Temporary Table


Temporary tables could be very useful to keep temporary data. Temporary tables option is available in MySQL version 3.23 and above.

Temporary table will be automatically destroyed when the session ends or connection is closed. The user can also drop temporary table.

Same temporary table name can be used in many connections at the same time, because the temporary table is only available and accessible by the client who creates that table.

The temporary table can be created in the following types

--->Basic temporary table creation
CREATE TEMPORARY TABLE tempTable1(
 id INT NOT NULL AUTO_INCREMENT,
 title VARCHAR(100) NOT NULL,
 PRIMARY KEY ( id )
 );
--->Temporary table creation from select query
CREATE TEMPORARY TABLE tempTable1
 SELECT ColumnName1,ColumnName2,... FROM table1;

You can add indexes as you build the table:

CREATE TEMPORARY TABLE tempTable1
 ( PRIMARY KEY(ColumnName2) )
 SELECT ColumnName1,ColumnName2,... FROM table1;

IF NOT EXISTS key word can be used as mentioned below to avoid 'table already exists' error. But in that case table will not be created, if the table name which you are using already exists in your current session.

CREATE TEMPORARY TABLE IF NOT EXISTS tempTable1
 SELECT ColumnName1,ColumnName2,... FROM table1;


Conclusion

In this page (written and validated by ) you learned about MYSQL Temporary Tables . What's Next? If you are interested in completing MYSQL tutorial, your next topic will be learning about: MYSQL Customize PS1.



Incorrect info or code snippet? We take very seriously the accuracy of the information provided on our website. We also make sure to test all snippets and examples provided for each section. If you find any incorrect information, please send us an email about the issue: mockstacks@gmail.com.


Share On:


Mockstacks was launched to help beginners learn programming languages; the site is optimized with no Ads as, Ads might slow down the performance. We also don't track any personal information; we also don't collect any kind of data unless the user provided us a corrected information. Almost all examples have been tested. Tutorials, references, and examples are constantly reviewed to avoid errors, but we cannot warrant full correctness of all content. By using Mockstacks.com, you agree to have read and accepted our terms of use, cookies and privacy policy.