mysql无法创建partition_mysql创建分区表的时候，死活说PARTITION p1305 这行有错误，帮看看谢谢...

CREATETABLE`myawr_io_info`(`id`bigint(20)NOTNULLAUTO_INCREMENT,`snap_id`int(11)NOTNULL,`host_id`int(11)NOTNULL,`rd_ios_s`float(10,2)DEFAULTNULL,`wr_ios_s`float(10,2)DEFAU...

CREATE TABLE `myawr_io_info` (

`id` bigint(20) NOT NULL AUTO_INCREMENT,

`snap_id` int(11) NOT NULL,

`host_id` int(11) NOT NULL,

`rd_ios_s` float(10,2) DEFAULT NULL,

`wr_ios_s` float(10,2) DEFAULT NULL,

`rkbs` float(10,2) DEFAULT NULL,

`wkbs` float(10,2) DEFAULT NULL,

`queue` float(10,2) DEFAULT NULL,

`wait` float(10,2) DEFAULT NULL,

`svc_t` float(10,2) DEFAULT NULL,

`busy` float(10,2) DEFAULT NULL,

`snap_time` datetime DEFAULT NULL,

PRIMARY KEY (`id`,`snap_time`),

KEY `idx_myawr_io_info_snap_time` (`snap_time`),

KEY `idx_myawr_io_info_snap_host_id` (`snap_id`,`host_id`),

KEY `idx_myawr_io_info_host_id` (`host_id`)

) ENGINE=InnoDB AUTO_INCREMENT=22806 DEFAULT CHARSET=utf8

PARTITION BY RANGE (to_days(snap_time))

(

PARTITION p1305 VALUES LESS THAN (to_days('2013-06-01')) ENGINE = InnoDB,

PARTITION p1306 VALUES LESS THAN (to_days('2013-07-01')) ENGINE = InnoDB,

PARTITION p1307 VALUES LESS THAN (to_days('2013-08-01')) ENGINE = InnoDB,

PARTITION p1308 VALUES LESS THAN (to_days('2013-09-01')) ENGINE = InnoDB,

PARTITION p1309 VALUES LESS THAN (to_days('2013-10-01')) ENGINE = InnoDB,

PARTITION p1310 VALUES LESS THAN (to_days('2013-11-01')) ENGINE = InnoDB,

PARTITION p1311 VALUES LESS THAN (to_days('2013-12-01')) ENGINE = InnoDB,

PARTITION p1312 VALUES LESS THAN (to_days('2014-01-01')) ENGINE = InnoDB

);

展开