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 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
>ngoncalves@stripped
>
>
>
>
>
>---------------------------------------------------------------------
>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 <mysql-thread96384@stripped>
>To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
