MySQL Forums
Forum List  »  Connector/ODBC

Re: multiple databases
Posted by: Bogdan Degtyariov
Date: July 28, 2019 08:52PM

Hi Mike,

You need to use the full table specification in your queries. The database name has to be specified before the table name (such as my_db.my_table).
For instance, this SQL syntax example aggregates data from different tables and databases:

SELECT t1.*, t2.* FROM db1.tab1 t1, db2.tab2 t2 WHERE t1.id = t2.id

Options: ReplyQuote


Subject
Written By
Posted
May 29, 2019 10:00AM
May 29, 2019 10:17AM
May 29, 2019 10:21AM
May 30, 2019 09:35AM
Re: multiple databases
July 28, 2019 08:52PM


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.