European Experts Exchange (EEE.org) :: Free Experts PHP MySql Oracle Microsoft Web SQL Delphi


Databases :: MySql :: Different table owners
By: Squibi	Date: 08/02/2003 00:00:00	Points: 75	Status: Answered Quality : Excellent
I'm about to change from a SQLServer 2000 to MySQL. The problem is that my database has tables with same name but different table owners. Looks like TO1.TABLENAME and TO2.TABLENAME. But MySQL doesn't seem to support tableowners or am I wrong? Anyone who knows how to get around the problem. I don't want to merge the tables, but I know that is an option. That would create a lot of other problems. :-/
By: VGR	Date: 08/02/2003 05:47:00		Type : Answer
yes and no what you call a table owner is treated as a database in MySql I suggest concatenating nameofowner and tablename so that you end up with TO1tablename and TO2tablename ; this way you'll stay in the same database. In short, you are right, MySql doesn't support "table owners". SQL 92 neither ;-)

By: Squibi	Date: 09/02/2003 00:28:00		Type : Comment
Thanks for the answer. I don't think concatenating nameofowner and tablename will solve the problem though. It would create a lot of work in the business layer. But I might be able to work with more than one database. That seem to be the easiest solution without a lot of changes in the code.

By: VGR	Date: 09/02/2003 00:38:00		Type : Comment
yes, it's not that difficult. You could even have a database per "previous owner", but then you would have to consolidate tables from multiple databases in case you wanted "all owners' thattable"

Do register to be able to answer

page generated in 62.142130 milliseconds