Temporary Tables


A temporary table lasts only for the current MySQL session. Therefore, after you have disconnected from the database, the table will no longer be available after you reconnect. To create a temporary table, use CREATE TEMPORARY TABLE instead of CREATE TABLE.

Temporary tables are useful if you need to manipulate data using temporary storage within an application and you do not want the tables you use to remain on the system when you are finished with them.

A temporary table name can be used simultaneously in multiple MySQL sessions. Therefore, if two instances of your program run at the same time, it is not necessary to generate a unique name for the temporary table in each instance.




Sams Teach Yourself MySQL in 10 Minutes
Sams Teach Yourself MySQL in 10 Minutes
ISBN: 0672328631
EAN: 2147483647
Year: 2006
Pages: 165
Authors: Chris Newman

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net