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
]
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
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
- 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
Is db2 a symlink to db1?
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
- 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
Nuno Gonçalves writes:
- 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
release 7.0 (Guinness)
Kernel 2.2.16-22 on an i586
-Mensaje original-
De: Gerald Clark [mailto:[EMAIL PROTECTED]]
Enviado el: martes, 15 de enero de 2002 15:35
Para: Nuno Gonçalves
CC: Mailing list MySql
Asunto: Re: MySQL can't tell the difference between two databases???
Is db2
: Tuesday, January 15, 2002 3:28 PM
Subject: RE: MySQL can't tell the difference between two databases???
I really don´t undarstand
My Linux is working fine in a situation like yours. I´ve simulated your
situation
mysql use db2;
Reading table information for completion of table and column