Is there a way to search two databases as one
I want to search TWO separate databases with one MYSQL QUERY as if they where the same table. Both contain the same tables and structure. Is there a way to do this and what are the minimum MYSQL requirements...
I am currently trying:
SELECT * FROM DB1.table,DB2.table;
HOWEVER I ONLY GET RESULTS FROM THE LAST DATABASE TABLE SPECIFIED... It seems it is just ignoring the first DATABASE specified.
I am currently running MYSQL version: 4.1.10a
Any help is appreciated.
Thanks,
Subject
Written By
Posted
Is there a way to search two databases as one
April 14, 2005 11:37AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.