* Mike Brando > > -----Original Message----- > > From: Chris [mailto:[EMAIL PROTECTED] > > > > 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. > > Looks like he's asking if MySQL supports namespaces. Is there anyway to > simulate namespaces in mysql?
A database is like a namespace... * William IT > > 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? You can simply create a database for each user: CREATE DATABASE USER1; CREATE DATABASE USER2; CREATE DATABASE USER3; Then each user can log into a separate database, and they can have tables with the same names, without conflict. A user with the right privileges can read other users tables with the syntax username.tablename. -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]