mysql merge分表插入方式_mysql利用merge存储引擎分表的方法

1、创建分表，和主表的表结构相同，这里创建3个表

1

2

CREATE TABLE 新表 LIKE 旧表;

CREATE TABLE nqhuacom1 LIKE nqhuacom;

2、复制主表数据到分表

1

2

3

4

5

6

INSERT INTO nqhuacom1 SELECT * FROM nqhuacom LIMIT 50000;

INSERT INTO nqhuacom2 SELECT * FROM nqhuacom LIMIT 50001,50000;

INSERT INTO nqhuacom3 SELECT * FROM nqhuacom LIMIT 100002,50000;

INSERT INTO nqhuacom4 SELECT * FROM nqhuacom LIMIT 150003,50000;

INSERT INTO nqhuacom5 SELECT * FROM nqhuacom LIMIT 200004,50000;

INSERT INTO nqhuacom6 SELECT * FROM nqhuacom LIMIT 250005,50000;

3、创建汇总表nqhuacomall

1

2

CREATE TABLE nqhuacomAll LIKE nqhuacom;

ALTER TABLE csdnall ENGINE=MERGE UNION=(nqhuacom1,nqhuacom2,nqhuacom3,nqhuacom4,nqhuacom5,nqhuacom6) INSERT_METHOD=LAST;

创建Mysql Merge表的参数 INSERT_METHOD有几个参数 。

LA