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. 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]