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
>[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

Reply via email to