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