Re: Temporary table lifespan - SOLVED

2007-02-17 Thread Amer Neely
@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 back out. I do get

RE: Temporary table lifespan - SOLVED

2007-02-16 Thread Jerry Schwartz
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 back out. I do get an error

Temporary table lifespan

2007-02-15 Thread Amer Neely
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 TABLE is issued. My

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

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

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

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

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