MySQL:从另一台服务器选择 [英] MySQL: SELECT from another server

问题描述

恐怕我已经知道我问题的答案了，但是我还是会问:

I'm afraid that I already know the answer to my question, but I'll ask it anyway:

当有两个MySQL DB服务器时，我可以访问存储在另一个服务器上的数据吗?

When there are two MySQL DB servers, can I access data that is stored on the other server?

换句话说:我能以某种方式做到这一点:

In other words: Can I somehow do this:

INSERT INTO table (x, y, z)
   SELECT x, y, x+y
      FROM [otherserver].[database].[table]

答案真的是否"吗?

推荐答案

您可以在MySQL中设置联合表来完成您要执行的操作.有一些限制.

You can set up federated tables in MySQL to accomplish what you're trying to do. There are some limitations.

http://dev.mysql.com/doc/refman/zh-CN/federated-storage-engine.html http://dev.mysql.com/doc/refman/en/federated -usagenotes.html

这篇关于MySQL:从另一台服务器选择的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！