如何通过联邦创建远程mysql表? [英] how to create a remote mysql table by federate?

问题描述

我已阅读此联合表现在，我想知道如果要从远程创建test_table(请参见链接中的示例)该怎么办? 据我了解，必须先在联邦服务器上创建test_table.但是我想通过本地服务器来创建它.

I have read this federate TABLE and now I would like to know what to do if I want to create the test_table (see this example in the link) from remote? As I do understand that test_table must be created on the federate server before. But I would like to create this by doing so from my local server.

任何人都可以帮忙吗?

更新:

我试图手动创建远程表的最低版本，然后让alter table tablename add columnname运行.现在我得到了这个错误. (该字段是表上的mannerpivot中的ACA.PA.)

I tried to create a minimal version of the remote table by my own manually and let alter table tablename add columnname run. Now I get this error. (The Fields is ACA.PA in table levermanneasypivot.)

   Field:  ACA.PA does not exists
   Error at: Do an alter ADD COLUMN  ACA.PA @ easy
   Error at: cmd: alter table `levermanneasypivot` add ` ACA.PA` int(9) 
   default NULL;
   Errormsg: cmd: Table storage engine for 'levermanneasypivot' doesn't have this option

非常感谢.

推荐答案

这是不可能的，如

以下各项表示FEDERATED存储引擎支持和不支持的功能:

The following items indicate features that the FEDERATED storage engine does and does not support:

• 在尝试通过FEDERATED表访问表之前，FEDERATED表指向 的远程表必须存在.

• The remote table that a FEDERATED table points to must exist before you try to access the table through the FEDERATED table.

您可以使用 connect 命令从mysql客户端内部连接到远程服务器.但是，您可以直接使用mysql -h remote_addr连接到远程服务器.

You can use the connect command to connect to a remote server from inside the mysql client. But then, you could just connect to the remote server with mysql -h remote_addr directly.

这篇关于如何通过联邦创建远程mysql表?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！