----- Original Message -----
From: "Javier Armendáriz" <[EMAIL PROTECTED]>
To: "Mailing list MySql" <[EMAIL PROTECTED]>
Sent: Tuesday, January 15, 2002 12:49 PM
Subject: RE: MySQL can't tell the difference between two databases???
> What happens if you try select * from db1.products and select * from
> db2.products;???
>
> Doing that does the same?
>
Yes, it's exactly the same results.
>
>
> > -----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
>
>
---------------------------------------------------------------------
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
