SpringBoot结合ShardingSphere实现分库分表、读写分离
2021-01-15 06:15
-- ----------------------------
-- Table structure for `user0`
-- ----------------------------
DROP TABLE IF EXISTS `user0`;
CREATE TABLE `user0` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(10) DEFAULT NULL,
`age` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=105 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of user0
-- ----------------------------
INSERT INTO `user0` VALUES (‘1‘, ‘wangxin02‘, ‘99‘);
-- ----------------------------
-- Table structure for `user1`
-- ----------------------------
DROP TABLE IF EXISTS `user1`;
CREATE TABLE `user1` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(10) DEFAULT NULL,
`age` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1000 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of user1
-- ----------------------------
INSERT INTO `user1` VALUES (‘1‘, ‘wangxin‘, ‘99‘);
文章标题：SpringBoot结合ShardingSphere实现分库分表、读写分离
文章链接：http://soscw.com/index.php/essay/42138.html