这里简单讲下使用merge实现分表的过程
我们增删改查只需要操作users表即可
1-建立user1和users表并插入数据
CREATE TABLE user1 (id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, name CHAR(20), pass CHAR(32), sex tinyint(1)) ENGINE=Myisam;
CREATE TABLE users (id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, name CHAR(20), pass CHAR(32), sex tinyint(1)) ENGINE=MERGE UNION=(user1) INSERT_METHOD=LAST;
INSERT INTO users (name,pass,sex) VALUES ('user11','123456',1),('user12','123456',1),('user13','123456',0);
2-建立user2和修改users
CREATE TABLE user2 (id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, name CHAR(20), pass CHAR(32), sex tinyint(1)) ENGINE=Myisam;
ALTER TABLE users UNION=(user1,user2) INSERT_METHOD=LAST;
INSERT INTO users (name,pass,sex) VALUES ('user21','123456',1),('user22','123456',1),('user23','123456',0);
2-建立user3和修改users
CREATE TABLE user3 (id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, name CHAR(20), pass CHAR(32), sex tinyint(1)) ENGINE=Myisam;
ALTER TABLE users UNION=(user1,user2,user3) INSERT_METHOD=LAST;
INSERT INTO users (name,pass,sex) VALUES ('user33','123456',1),('user34','123456',1),('user35','123456',0);
