It's something like this:
mysql> use db1 mysql> select * from products; +----+-----+---------+------+------+ | Id | Ref | Version | Type | Name | +----+-----+---------+------+------+ | 1 | XXX | 1 | 1 | XXX | +----+-----+---------+------+------+ 1 row in set (0.27 sec) mysql> use db2 mysql> select * from products; +----+-----+---------+------+------+ | Id | Ref | Version | Type | Name | +----+-----+---------+------+------+ | 1 | XXX | 1 | 1 | XXX | +----+-----+---------+------+------+ 1 row in set (0.16 sec) I'm sure the table products on database db2 is empty, because of the results I get when I remove db1 from the system. The same select returns empty. Hope that helps. Thanks. Nuno A. S. Gonçalves [EMAIL PROTECTED] ----- Original Message ----- From: "Duncan Hill" <[EMAIL PROTECTED]> To: "Nuno Gonçalves" <[EMAIL PROTECTED]> Cc: "Mailing list MySql" <[EMAIL PROTECTED]> Sent: Tuesday, January 15, 2002 12:13 PM Subject: Re: MySQL can't tell the difference between two databases??? > On Tue, 15 Jan 2002, Nuno Gonçalves wrote: > > > The only way I seem to be able to access the data on database B is to > > remove the other database from MySQL. >From my tests it seems that MySQL > > only uses the table name to access the data (not using also the database > > name). > > The sql queries you are using on your database would help. We are not > mind-readers (well, I'm not!). > > --------------------------------------------------------------------- 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