persistent temporary tables

[electroteque]

i have come to realise that temporary tables are only persistent for 30 
secs, is there a way to extend that ? My applications is attempting to 
store data before and entry is made and then insert the data from the 
temporary table after the entry is inserted then drop the temp table. 
This should work in theory but even with peristent php connections the 
tables are lost. Any ideas ? I have had to create heap tables with 
random named tables for each user, then drop them as i would with temp 
tables, is this a good idea ?

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]