Thank You. That is what I was hoping for. I would assume that this would be faster than actually coming up with a random name, using srand and rand, for a table, creating it and deleting it when done.
Thanks Steve Buehler At 02:19 PM 4/8/2002, you wrote: >Yes a TEMPORARY TABLE is specific to the connection >if 100 people have the same name on a Temporary table >they are still separate tables that only exist to the connection that >created them. > >-----Original Message----- >From: Steve Buehler [mailto:[EMAIL PROTECTED]] >Sent: Monday, April 08, 2002 2:40 PM >To: mysql >Subject: CREATE TEMPORARY TABLE > > > If I want to use temporary tables I know I can create tables that >are >unique without using "CREATE TEMPORARY TABLE table_name". What I want to >know, because it might be more efficient, is if I use "CREATE TEMPORARY >TABLE table_name" and more than one person hits the page (I am using PHP to >access the MySQL DB), does the second person have to wait until the first >person is done and the temporary table is gone before the temporary table >is created again, or is it unique for each connection. Example: if 100 >people hit the page at the same time, will each have a temporary table >called "table_name" that only their connection can see, meaning that there >would actually be 100 tables with the same name? > >I sure hope that makes since. > >Thanks >Steve Buehler > > > >--------------------------------------------------------------------- >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 --------------------------------------------------------------------- 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
