hi, > -----Original Message----- > From: William R. Mussatto [mailto:[EMAIL PROTECTED] > Sent: 30 October 2003 01:14 > To: [EMAIL PROTECTED] > Subject: RE: Multiuser Programming > > > Chris said: > > I'm not familiar with that function in MS SQL, and you're a bit unclear, > > but it looks like you might be able to use temporary tables. > > > > http://www.mysql.com/doc/en/CREATE_TABLE.html > > > > Temporary tables are on a per-connection basis, and are unique per > > connection (each connection can have a temporary table that won't > > conflict with others). Temporary tables are dropped as soon as the > > connection is dropped. > > > > Chris > > > > -----Original Message----- > > From: William IT [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, October 29, 2003 5:01 PM > > To: [EMAIL PROTECTED] > > Subject: Multiuser Programming > > > > > > I am doing transfer from MS SQL. > > In MS SQL while I connect as "USER1" my table will be create as > > User1.TableName. This will avoid conlict with other user. > > > > Now, how do I do that in Mysql? Or, maybe there is such system in Mysql. > > Is there any Mysql reference talk about this matter? > > I thought this list wanted bottom posting? Sorry if I've got it > backwards. > > How does connection pooling figure into this? I would assume a drop table > command would be needed since from MySQL's point of view, the connection > never gets dropped.
Yes, I believe that a drop is`needed in such cases. Thanks, Mike > > William R. Mussatto, Senior Systems Engineer > Ph. 909-920-9154 ext. 27 > FAX. 909-608-7061 > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]