Re: Temporary table lifespan - SOLVED

2007-02-17 Thread Amer Neely
mysql@lists.mysql.com Subject: Re: Temporary table lifespan - SOLVED Amer Neely wrote: Daniel Kasak wrote: Amer Neely wrote: OK, that makes sense. As far as I know, my connection is still live - I don't do a disconnect anywhere. So I'm still not sure why I can't pull the data b

RE: Temporary table lifespan - SOLVED

2007-02-16 Thread Jerry Schwartz
l@lists.mysql.com > Subject: Re: Temporary table lifespan - SOLVED > > Amer Neely wrote: > > Daniel Kasak wrote: > >> Amer Neely wrote: > >> > >>>> OK, that makes sense. As far as I know, my connection is > still live > >>>> - I don

Re: Temporary table lifespan - SOLVED

2007-02-15 Thread Amer Neely
Amer Neely wrote: Daniel Kasak wrote: Amer Neely wrote: OK, that makes sense. As far as I know, my connection is still live - I don't do a disconnect anywhere. So I'm still not sure why I can't pull the data back out. I do get an error telling me about a problem with my statement near w

Re: Temporary table lifespan

2007-02-15 Thread Amer Neely
Daniel Kasak wrote: Amer Neely wrote: OK, that makes sense. As far as I know, my connection is still live - I don't do a disconnect anywhere. So I'm still not sure why I can't pull the data back out. I do get an error telling me about a problem with my statement near which is where it tr

Re: Temporary table lifespan

2007-02-15 Thread Daniel Kasak
Amer Neely wrote: OK, that makes sense. As far as I know, my connection is still live - I don't do a disconnect anywhere. So I'm still not sure why I can't pull the data back out. I do get an error telling me about a problem with my statement near which is where it tries to execute the F

Re: Temporary table lifespan

2007-02-15 Thread Amer Neely
Amer Neely wrote: Daniel Kasak wrote: Amer Neely wrote: I'm writing a perl script in which I need to save some session data. My first attempt is to use a temporary table to store some data. However, I'm a little unclear as to the lifespan of the temporary table. My understanding is they las

Re: Temporary table lifespan

2007-02-15 Thread Daniel Kasak
Amer Neely wrote: I'm writing a perl script in which I need to save some session data. My first attempt is to use a temporary table to store some data. However, I'm a little unclear as to the lifespan of the temporary table. My understanding is they last until the session ends, or a DELETE T