MySql - Union across different Servers

Is there any way to do something like this?

select * from server1.database_name.table union all select * from server2.database_name.table

Thanks.


ANSWERS:


You can create a table on server1 that uses the FEDERATED storage engine to connect to server2.

Read more here.



 MORE:


 ? MySQL select inner join and union
 ? MySQL Union (or similar) query
 ? Mysql UNION with dynamic query
 ? MYSQL: UNION results between two tables where omitting records from first table if PK found in second table
 ? How can I leverage an ORM for a database whose schema is unknown until runtime?
 ? How can I leverage an ORM for a database whose schema is unknown until runtime?
 ? How can I leverage an ORM for a database whose schema is unknown until runtime?
 ? Which ORM can preserve the correspondence between db schema and domain model?
 ? how to minimize application downtime when updating database and application ORM
 ? Can we use MongoDB with ORMs we used to use with relational databases, such as linq2sql, entity framework, subsonic,...?