MySQL Forums
Forum List  »  Newbie

SELECT from different databases/servers tables
Posted by: Peter Komanns
Date: August 22, 2004 04:45AM

Hi all!
I can't find the exact MySQL instructions to get data from tables located on a different database in the same engine and/or on different databases in different engines.

I am working to a migration from Informix. In Informix a table name is defined as

<tbl_name> (as usual)

or

<db_name>:<tbl_name> (same engine, different db)

or

<db_name>@<server>:<tbl_name>
(different engine, different db)

How can, if possible, replicate this syntax in MySQL ??

Thanks in advance
Peter

Options: ReplyQuote


Subject
Written By
Posted
SELECT from different databases/servers tables
August 22, 2004 04:45AM


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.