Can MySql 5.0 have an idea of ​​a table located on another server

Question

Can MySql 5.0 views use tables located on another server? What is the syntax for creating such a view?

Answer 1

Federated Tables: http://dev.mysql.com/doc/refman/5.0/en/federated-storage-engine.html

This allows you to remotely access the table as if the remote table was a local table. It has its limitations, but it seems to meet my needs.

Answer 2

Yes, you can create objects in one database that reference another database and even another host. The syntax for this works something like this:

USE localhost.myDB;

SELECT * FROM host2.db.tableName;