DB研討會 : [轉貼]MySQL Cross Server Select Query

• 發表新主題

發表者	討論內容
冷日 (冷日)	發表時間：2016/2/20 8:54
Webmaster 註冊日: 2008/2/19 來自: 發表數: 15773	[轉貼]Can MySql 5.0 have a view of a table located on another server 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: USE localhost.myDB; SELECT * FROM host2.db.tableName; 原文出處：Can MySql 5.0 have a view of a table located on another server - Stack Overflow
回覆

平面展開

前一個主題 | 下一個主題 | | | |

討論串

•    [轉貼]MySQL Cross Server Select Query (冷日
  (冷日), 2016/2/20 8:48)
•      [轉貼]Join tables from two different server（MySql） (冷日
  (冷日), 2016/2/20 8:52)
•      » [轉貼]Can MySql 5.0 have a view of a table located on another server (冷日
  (冷日), 2016/2/20 8:54)
•          [轉貼]MySQL FEDERATED引擎使用示例, 類似Oracle DBLINK (冷日
  (冷日), 2016/2/20 8:57)