注意:DB1库和DB2库不在同一台物理主机
1.查询本地mysql数据库的FEDERATED引擎是否开启:NO未开启,开启YES
show engines;
2.查询库DB2表结构
SHOW CREATE TABLE prd_table;
3.查询到的结果
CREATE TABLE `prd_table` (
`ID` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'l',
UNIQUE KEY `PK_PRD_BASE` (`SEQID`) USING BTREE,
KEY `IDX_PRD_BASE_PRDCODE` (`PRD`) USING BTREE
)
4.连接DB2的地址
ENGINE=FEDERATED CONNECTION='mysql://user:pwd@11.18.66.121:3306/prd_db/prd_table';
5.合并语句执行,完成
CREATE TABLE `prd_table` (
`ID` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'l',
UNIQUE KEY `PK_PRD_BASE` (`SEQID`) USING BTREE,
KEY `IDX_PRD_BASE_PRDCODE` (`PRD`) USING BTREE
) ENGINE=FEDERATED CONNECTION='mysql://user:pwd@11.18.66.121:3306/prd_db/prd_table';
04-11
2万+
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
12-14
04-26