mysql 开启分区_Mysql实现分区功能（一）

1. 创建分区表

CREATE TABLE `表名` (

`EQUIPMENTID` char(17) NOT NULL,

`ATTRIBUTEID` char(4) NOT NULL,

`VALUE` varchar(20) NOT NULL,

`COLLECTTIME` datetime NOT NULL

)

ENGINE=InnoDB (适用大部分引擎,可根据需要调整)

DEFAULT CHARSET=gbk(编码可根据需要修改)

PARTITION BY RANGE (to_days(COLLECTTIME))

(PARTITION pmin VALUES LESS THAN (to_days('2010-01-01')),

PARTITION p201001 VALUES LESS THAN (to_days('2010-02-01')) ,

PARTITION p201002 VALUES LESS THAN (to_days('2010-03-01')) ,

PARTITION p201003 VALUES LESS THAN (to_days('2010-04-01')) ,

PARTITION p201004 VALUES LESS THAN (to_days('2010-05-01')) ,

PARTITION p201005 VALUES LESS THAN (to_days('2010-06-01')) ,

PARTITION p201006 VALUES LESS THAN (to_days('2010-07-01')) ,

PARTITION p201007 VAL