存在自增键，并以日期列为分区的样例

#存在自增键，并以日期列为分区的样例
  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')  
)