List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:August 15 2002 1:50am
Subject:Re: query quandary
View as plain text  
In the last episode (Aug 14), Mark Jones said:
> Thank you!!!  It works!!
> 
> I'm curious how the creation of the temporary table would behave in a
> web server environment.  At which point does mysql delete the temp
> table?  After the db connection instituted by the script disconnects
> (in my case, after the Perl DBI database handle is disconnected)?

Yes.

From http://www.mysql.com/doc/en/CREATE_TABLE.html:

   In MySQL Version 3.23, you can use the TEMPORARY keyword when you
   create a table. A temporary table will automatically be deleted if a
   connection dies and the name is per connection. This means that two
   different connections can both use the same temporary table name
   without conflicting with each other or with an existing table of the
   same name. (The existing table is hidden until the temporary table is
   deleted.). In MySQL 4.0.2 one must have the CREATE TEMPORARY TABLES
   privilege to be able to create temporary tables.


-- 
	Dan Nelson
	dnelson@stripped
Thread
query quandaryMark Jones12 Aug
  • Re: query quandaryDL Neil13 Aug
  • Re: query quandaryMark Jones15 Aug
    • Re: query quandaryDan Nelson15 Aug