Paul is right. I would like to add a small remark, it should better to drop the temp. tables before closing your script. This can free up resources. I had a painful experience that I had created hash temp. tables without dropping them. This lead to memory leak.
Regards, -- Yours, KH Chiu C&A Computer Consultants Ltd. Tel: 3104 2070 Fax: 3010 0896 Email: [EMAIL PROTECTED] Website: www.caconsultant.com > At 23:19 +0000 3/4/03, Mamatha Balasubramanian wrote: > >Thank you once again. > > > >I have a web-interface that does search on a given text and I would > >have a script that creates a temporary table. So according to you, > >in my script, I just to need > >create a temporary table and not have to worry about another client > >using the same web interface (and thereby using the same program). > >Can you please elaborate a little more on this? > > Sure. > > You are incorrect. :-) > > That is, you're making an assumption that cannot necessarily be made. > If you can guarantee that the web script will establish a new > connection, and the connection will terminate when the script ends, > you can indeed do what you describe above. > > But you *cannot* do that if you're running your script in an environment > that uses persistent connections that may be used by successive instances > of the script. PHP persistent connections fall into this class, for > example. Several requests might be served by the same instance of > the web server process, and you don't know that one request won't be > getting the connection used by a previous request. In that case, > the connection won't have closed, and the TEMPORARY table won't > have disappeared. > > You can guard against this by issuing this query before creating the > TEMPORARY table: > > DROP TABLE IF EXISTS tbl_name > > > > >Thanks, > >Mamatha > > > > > > > > > > > >>From: Paul DuBois <[EMAIL PROTECTED]> > >>To: "Mamatha Balasubramanian" > >><[EMAIL PROTECTED]>,[EMAIL PROTECTED] > >>Subject: Re: Temporary Tables > >>Date: Tue, 4 Mar 2003 17:06:30 -0600 > >> > >>At 23:00 +0000 3/4/03, Mamatha Balasubramanian wrote: > >>>Hi, > >>>I would like to know how MySQL handles multiple temporary tables? > >>> > >>>1. Can multiple temporary tables be created at the same time? > >>>2. If so, how does MySQL differentiate them - do we need to > >>>explicitly give them different names inorder to identify them or > >>>does MySQL provide a timestamp (or use some other means) to > >>>identify the tables? > >> > >>You can create multiple temporary tables, but they must have different > >>names. > >> > >>A TEMPORARY table can have the same name as a non-TEMPORARY table. > >>The non-TEMPORARY table is hidden to the client that creates the > >>TEMPORARY table as long as the TEMPORARY table exists. > >>A second TEMPORARY table with the same name cannot be created. > >> > >>This is on a connection-specific basis. Two clients each can create > >>a TEMPORARY table with the same name. Only the table created by a given > >>client is visible to that client. > >> > >>> > >>>I use MySQL 4.0.7 on Red Hat. > >>> > >>>Thanks, > >>>Mamatha > > --------------------------------------------------------------------- > 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 <mysql-unsubscribe- [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