MySql-FEDERATED引擎

场景：我在B服读取A服的数据库表

A服-表结构

CREATE TABLE `users`  (   `Id` int(0) NOT NULL AUTO_INCREMENT,   `Name` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '姓名',   PRIMARY KEY (`Id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1878 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

B服-表结构（感觉就是视图）

CREATE TABLE `a_users`  (   `Id` int(0) NOT NULL AUTO_INCREMENT,   `Name` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '姓名',   PRIMARY KEY (`Id`) USING BTREE ) ENGINE = FEDERATED CHARACTER SET = utf8 COLLATE = utf8_general_ci CONNECTION = 'mysql://root:[email protected]:3306/testdb/users' ROW_FORMAT = Dynamic;

引擎：ENGINE=FEDERATED （我每次会忘记修改这一项）
链接：CONNECTION = 'mysql://root:A服数据库密码@A服数据库ip+端口/A服数据库名称/A服数据库表名称'