连接来自两个不同服务器的表

本文介绍了连接来自两个不同服务器的表的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

我有两个不同的服务器server1和server2，现在在server1中有db1，在server2中有db2.我试图像这样在MySQL中加入这两个表.

I have two different server server1 and server2, now I have db1 in server1 and db2 in server2.I am trying to join these two table in MySQL like this.

Select a.field1,b.field2
FROM  [server1, 3306].[db1].table1 a
Inner Join [server2, 3312].[db2].table2 b
ON a.field1=b.field2

但是我遇到了错误.在MYSQL中是可能的.

But I am getting error. Is is possible in MYSQL.

是的，在MySQL中是可能的.

以前也有类似的问题.您必须使用 FEEDATED ENGINE 来执行此操作.这个想法是这样的:

Yes, it is possible in MySQL.

There are similar questions asked previously too. You have to use FEDERATED ENGINE to do this. The idea goes like this:

您必须具有基于另一个远程位置的表的联合表，才能使用所需的方式.表的结构必须完全相同.

You have to have a federated table based on the table at another remote location to use the way you want. The structure of the table have to exactly same.

CREATE TABLE federated_table (
    id     INT(20) NOT NULL AUTO_INCREMENT,
    name   VARCHAR(32) NOT NULL DEFAULT '',
    other  INT(20) NOT NULL DEFAULT '0',
    PRIMARY KEY  (id),
    INDEX name (name),
    INDEX other_key (other)
)
ENGINE=FEDERATED
DEFAULT CHARSET=latin1
CONNECTION='mysql://fed_user@remote_host:9306/federated/test_table';

[源答案]

这篇关于连接来自两个不同服务器的表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！