#存在自增键,并以日期列为分区的样例
CREATE TABLE `vr_day_test_partition` (
`id` INT(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID;自增',
`vr_id` CHAR(16) NOT NULL COMMENT '作品ID',
`vr_mp_id` INT(11) NOT NULL COMMENT 'MapperID',
`dt_date` DATE NOT NULL COMMENT '数据日期',
`dt_data_create` DATETIME DEFAULT NULL COMMENT '数据采集时间',
`dt_create` DATETIME DEFAULT NULL COMMENT '创建日期',
PRIMARY KEY (`dt_date`,id),
UNIQUE KEY( id,`dt_date` ),
KEY `idx_vr_mp_id` (`vr_mp_id`)
) ENGINE=INNODB AUTO_INCREMENT=38992913 DEFAULT CHARSET=utf8 COMMENT='综艺日表'
PARTITION BY RANGE COLUMNS(dt_date)
(
PARTITION p161001 VALUES LESS THAN ('2016-10-01')
,PARTITION p181001 VALUES LESS THAN ('2018-10-01')
,PARTITION p_99991231 VALUES LESS THAN ('9999-12-31')
)
存在自增键,并以日期列为分区的样例
最新推荐文章于 2023-01-09 09:46:31 发布