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
