Does anyone know whether the use of persistent connections with php will
allow a temp table created by a script to linger around and cause a problem
with the next execution of the script when it tries to create the temp table
again?
You are right. There is a simple workaround though. You can use IF NOT EXISTS when creating your temp table:
create temporary table if not exists t1 (a int);
Also if it does present a problem with the next script execution
trying to create the temp table again, if I drop the temp table at the end
of the script will I still have problems if the script is run by two client
in tandem? For instance two people connect, both hit the script at about
the same time. One script creates the temp table and before it can drop the
table the second script tries to create the table.
Temporary tables are created under connection scope. There is no problem for two clients to use temporary tables with the same names. Physically, these tables are different. The second client can't see a temporary table created by the first client.
Will it see the table created by the other script? Again the use of persistent connections would be a the heart of this I would think.
-- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Alexander Barkov <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Izhevsk, Russia <___/ www.mysql.com +7-912-856-80-21
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
