MySQL Forums
Forum List  »  Stored Procedures

Re: Temporary Tables Aliasing in Stored Procedure
Posted by: Yuri Sprague
Date: August 09, 2005 07:04PM

See Section 13.2.6 CREATE TABLE Syntax of the MySQL 5 manual (manual-a4.pdf in Adobe format). It states,

"From MySQL 3.23 on, you can use the TEMPORARY keyword when creating a table. A TEMPORARY table is visible only to the current connection, and is dropped automatically when the connection is closed. This means that two different connections can use the same temporary table name without conflicting with each other or with an existing non-TEMPORARY table of the same name. (The existing table is hidden until the temporary table is dropped.) From MySQL 4.0.2 on, you must
have the CREATE TEMPORARY TABLES privilege to be able to create temporary tables."

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Temporary Tables Aliasing in Stored Procedure
2994
August 09, 2005 07:04PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.