dcsimg
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
 

Tip: Temporary Tables in MySQL

See how to use a temporary table in MySQL.


advertisement

WEBINAR:

On-Demand

Building the Right Environment to Support AI, Machine Learning and Deep Learning


We may want to use a table to store values while computing, which in turn might be used by subsequent processing. But, for sure, this working data must not be stored in an actual table that is part of the product. MySQL has a solution with TEMPORARY tables.

These tables are created using TEMPORARY and are visible for the current session only and thereafter cease to exist.

Syntax:

CREATE TEMPORARY TABLE new_table

 

Visit the DevX Tip Bank

 





   
Sridhar M S. is a Java developer from Bangalore, India. He holds a master's degree in Computer Science.
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date