對這文章發表回應
發表限制: 非會員 可以發表
發表者： 冷日 發表時間： 2016/2/20 8:54:10
Can MySql 5.0 have a view of a table located on another server
Can MySql 5.0 views use tables that are located on another server? What is the syntax for creating such a view?
Federated Tables: http://dev.mysql.com/doc/refman/5.0/en/federated-storage-engine.html
This allows a table to be remotely accessed as if the remote table was a local table. It has its limitations but seems to meet my needs.
Yes, you can create objects in one database that reference another database and even another host. The syntax to do so works something like this:
原文出處：Can MySql 5.0 have a view of a table located on another server - Stack Overflow
Can MySql 5.0 views use tables that are located on another server? What is the syntax for creating such a view?
Federated Tables: http://dev.mysql.com/doc/refman/5.0/en/federated-storage-engine.html
This allows a table to be remotely accessed as if the remote table was a local table. It has its limitations but seems to meet my needs.
Yes, you can create objects in one database that reference another database and even another host. The syntax to do so works something like this:
USE localhost.myDB;
SELECT * FROM host2.db.tableName;
原文出處：Can MySql 5.0 have a view of a table located on another server - Stack Overflow