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
