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 [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
