Can someone explain to me how to determine just how temporary a temporary table is.
I am trying to use one for a shopping cart system, in which the user stores products in a temporary table. The temporary table would be deleted after they leave.
I've run SQL in a query in mySQL to create a temporary table, and I can access the table for about a minute or two, after which it is gone. How can I extend this time to suit my application?