数据库表分区

最新推荐文章于 2016-02-25 15:19:17 发布

bendaorong

最新推荐文章于 2016-02-25 15:19:17 发布

阅读量66

点赞数

分类专栏：技术前沿文章标签：分区数据库

本文链接：https://blog.csdn.net/bendaorong/article/details/84382565

版权

技术前沿专栏收录该内容

32 篇文章 0 订阅

订阅专栏

DROP TABLE IF EXISTS analysis_keyword_update;
/*==============================================================*/
/* Table: analysis_keyword_update */
/*==============================================================*/
CREATE TABLE analysis_keyword_update
(
TRANSACTION_TYPE varchar(20) comment '业务类型',
TRANSACTION_NUMBER varchar(20) comment '业务编号',
KEYWORD varchar(30) comment '字段',
VALUE datetime,
PRIMARY KEY (TRANSACTION_NUMBER,KEYWORD)
)partition by range columns(TRANSACTION_NUMBER)
(
PARTITION part1301 VALUES LESS THAN ('1301999999999999') ENGINE = InnoDB,
PARTITION part1302 VALUES LESS THAN ('1302999999999999') ENGINE = InnoDB,
PARTITION part1303 VALUES LESS THAN ('1303999999999999') ENGINE = InnoDB,
PARTITION part1304 VALUES LESS THAN ('1304999999999999') ENGINE = InnoDB,
PARTITION part1305 VALUES LESS THAN ('1305999999999999') ENGINE = InnoDB,
PARTITION part1306 VALUES LESS THAN ('1306999999999999') ENGINE = InnoDB,
PARTITION part1307 VALUES LESS THAN ('1307999999999999') ENGINE = InnoDB,
PARTITION part1308 VALUES LESS THAN ('1308999999999999') ENGINE = InnoDB,
PARTITION part1309 VALUES LESS THAN ('1309999999999999') ENGINE = InnoDB,
PARTITION part1310 VALUES LESS THAN ('1310999999999999') ENGINE = InnoDB,
PARTITION part1311 VALUES LESS THAN ('1311999999999999') ENGINE = InnoDB,
PARTITION part1312 VALUES LESS THAN ('1312999999999999') ENGINE = InnoDB
);