Re: DROP TEMP TABLES

Oli Filth wrote:

> Jay said the following on 14/10/2005 14:57:
>> Hey there,
>> I have a question. Is it possible to to construct something through
>> a combination of php and javascript that (when a browser window is
>> closed)
>
> No.
>
>> would drop temp tables that are used? I've tried to use an
>> override of the SESSION functions, but that isn't working in the way I
>> would like it to.

Stick at it - this is the only way to solve the problem.

>> from one page to another, those temp tables are gone. Any suggestions?
>>
>
> Temporary tables are exactly that - temporary. They are designed to be
> used for a short period of time, e.g. within one SQL transaction.
>

Erm, bad terminology - they last one MySQL *session* i.e. between
mysql_connect() and mysql_close() (or end of script).

But as Oli says - are you *really* sure you need a temporary table?

C.
Received on Tue Oct 18 02:41:33 2005