MySQL Forums
Forum List  »  Stored Procedures

Advanced Search
New Topic

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

My reply was aimed more at Conor rather than you Roland.

Nothing stopping you creating a table in the db, using it in the procedure and then dropping it later. If it's something you will be runnig alot then a premanent temporary table will do the trick.

I think what MySQL Stored Procedures need is some sort of complex data structure such as a 'temporary' structure or a multi dimentional array.

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

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Temporary Tables Aliasing in Stored Procedure
3443
conor meegan
July 26, 2005 10:00AM
Re: Temporary Tables Aliasing in Stored Procedure
2273
Roland Bouman
July 26, 2005 12:14PM
Re: Temporary Tables Aliasing in Stored Procedure
2188
conor meegan
July 27, 2005 01:38AM
Re: Temporary Tables Aliasing in Stored Procedure
2249
Roland Bouman
July 27, 2005 02:04AM
Re: Temporary Tables Aliasing in Stored Procedure
2171
Andrew Gilfrin
July 27, 2005 05:06AM
Re: Temporary Tables Aliasing in Stored Procedure
2219
Roland Bouman
July 27, 2005 05:15AM
Re: Temporary Tables Aliasing in Stored Procedure
2917
Melvin Zamora
October 25, 2005 10:58PM
Re: Temporary Tables Aliasing in Stored Procedure
2160
Andrew Gilfrin
July 27, 2005 05:40AM
Re: Temporary Tables Aliasing in Stored Procedure
2163
Roland Bouman
July 27, 2005 06:35AM
Re: Temporary Tables Aliasing in Stored Procedure
2074
Andrew Gilfrin
July 27, 2005 07:53AM
Re: Temporary Tables Aliasing in Stored Procedure
2074
Roland Bouman
July 27, 2005 07:58AM
Re: Temporary Tables Aliasing in Stored Procedure
2213
Yuri Sprague
August 08, 2005 08:53PM
Re: Temporary Tables Aliasing in Stored Procedure
3010
Yuri Sprague
August 09, 2005 07:04PM
Re: Temporary Tables Aliasing in Stored Procedure
2209
Andrew Gilfrin
August 09, 2005 04:19AM
Re: Temporary Tables Aliasing in Stored Procedure
2140
Andrew Gilfrin
August 10, 2005 06:07AM
Re: Temporary Tables Aliasing in Stored Procedure
2263
conor meegan
September 29, 2005 03:30AM
Re: Temporary Tables Aliasing in Stored Procedure
2350
Andrew Gilfrin
September 30, 2005 03:09AM
Re: Temporary Tables Aliasing in Stored Procedure
2283
Frank Maas
October 07, 2005 04:10AM
Re: Temporary Tables Aliasing in Stored Procedure
2241
Roland Bouman
October 07, 2005 04:29AM
Re: Temporary Tables Aliasing in Stored Procedure
3453
Roland Bouman
October 26, 2005 01:29AM


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.