----- Original Message -----
From: "Gerald Clark" <[EMAIL PROTECTED]>
To: "Nuno Gonçalves" <[EMAIL PROTECTED]>
Cc: "Mailing list MySql" <[EMAIL PROTECTED]>
Sent: Tuesday, January 15, 2002 2:35 PM
Subject: Re: MySQL can't tell the difference between two databases???
> Is db2 a symlink to db1?
db2 is a symlink, but not to db1. I'm sure of that.
I've done some more tests. It appears that if you change something on one of
the tables (adding a new column on the table products of db1), mysql decides
that both tables on the two databases are different, and it starts to give
the correct results.
I've also tested with INSERT and the same thing happens:
use db1
INSERT INTO products .......;
use db2
INSERT INTO products .......;
The first insert ends up in both databases, and the second only appears in
the first database.
Well, if this isn't a bug I don't know what it is.
>
> Nuno Gonçalves wrote:
>
> >Hi!
> >
> >I've got two mysql databases that have exactly the same structure (same
> >tables using BDB, columns, etc.) and different data.
> >
> >When I try to do a select on a table from database A, I get the right
> >results, but when I try the same select on the same table from database
B, I
> >get the results from the database A.
> >
> >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).
> >
> >Anyone has an idea, of why this happens.
> >
> >Nuno A. S. Gonçalves
> >[EMAIL PROTECTED]
> >
> >
> >
> >
> >
> >---------------------------------------------------------------------
> >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
