What happens if you try select * from db1.products and select * from db2.products;???
Doing that does the same? > -----Mensaje original----- > De: Nuno Gonçalves [mailto:[EMAIL PROTECTED]] > Enviado el: martes, 15 de enero de 2002 13:24 > Para: Mailing list MySql > Asunto: Re: MySQL can't tell the difference between two databases??? > > > > 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 > --------------------------------------------------------------------- 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