MySQL Forums
Forum List  »  Stored Procedures

Re: Temporary Tables Aliasing in Stored Procedure
Posted by: Andrew Gilfrin
Date: July 27, 2005 05:06AM

I think you're confusing the point of temporary tables, the data in them is temporary not the table itself.

It doesn't really make sense to create the table in the procedure, you should just create it as a permanent entity in the db and then reference it in the stored procedure.

If you don't want to make your database untidy by having various temporary tables hanging around, create another database and store the temporary tables in there.

I can see the point of having a temporary structure in a procedure such as Oracle's PL/SQL tables but currently this isn't supported.

Andrew Gilfrin
------------------
http://gilfster.blogspot.com
My MySQL related Blog

http://www.mysqldevelopment.com
MySQL Stored Procedure,Trigger, View.... (Just about most things these days) Information

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Temporary Tables Aliasing in Stored Procedure
2171
July 27, 2005 05:06AM


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.