MySql教程

MySql-FEDERATED引擎

本文主要是介绍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:123456@127.0.0.1:3306/testdb/users' ROW_FORMAT = Dynamic;
引擎:ENGINE=FEDERATED (我每次会忘记修改这一项)
链接:CONNECTION = 'mysql://root:A服数据库密码@A服数据库ip+端口/A服数据库名称/A服数据库表名称'
这篇关于MySql-FEDERATED引擎的文章就介绍到这儿,希望我们推荐的文章对大家有所帮助,也希望大家多多支持为之网!