MySQL Forums
Forum List  »  Stored Procedures

Advanced Search
New Topic

Re: Temporary Tables Aliasing in Stored Procedure
Posted by: Andrew Gilfrin
Date: August 10, 2005 06:07AM

You are indeed correct, I stand very much corrected.

Having just checked it out I can confirm the table is deleted when you drop the connection. I didn't realise this was the case and is different to temporary table implementation in other databases.

Sorry for doubting you but I was convinced this was the way they worked.

Regards

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
2162
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
2073
Roland Bouman
July 27, 2005 07:58AM
Re: Temporary Tables Aliasing in Stored Procedure
2212
Yuri Sprague
August 08, 2005 08:53PM
Re: Temporary Tables Aliasing in Stored Procedure
3009
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
2139
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
2240
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.