List:General Discussion« Previous MessageNext Message »
From:SGreen Date:March 1 2006 4:28pm
Subject:Re: Support for temporary tables inside stored procedures?
View as plain text  
"J A" <my_data_storage_65@stripped> wrote on 03/01/2006 11:08:10 AM:

> Does MySQL have support for temporary tables inside stored procedures?
> 
> _________________________________________________________________
> Express yourself instantly with MSN Messenger! Download today - it's 
FREE! 
> http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
> 
> 

Yes, you can create and destroy temporary tables from within stored 
procedures. 

Remember that all temporary tables and user variables are 
connection-specific. You have to maintain the connection between SPROC 
executions to have the results of one SPROC be available to the next. Drop 
a connection and your user variables and temporary tables created by that 
connection go away (garbage collected by the server).

The obverse situation is also true. Using a pooled connection may result 
in object carry-over from one process to another (because returning the 
connection to the pool does may not actually drop the connection). You 
should always destroy any temporary object when you are through using it 
and always initialize your variables before usage. That way you don't 
accidentally hand old data off to following threads and you don't inherit 
previous threads state values (unless you really want them).

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Thread
Support for temporary tables inside stored procedures?J A1 Mar
  • Re: Support for temporary tables inside stored procedures?SGreen1 Mar