DROP TABLE IF EXISTS tbname;
CREATE TABLE `tbname` (
`ID` int NOT NULL AUTO_INCREMENT COMMENT '主键自增长',
`PV_NO` varchar(100) DEFAULT NULL COMMENT '字段说明',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
ALTER TABLE tbnameCOMMENT '测试表';
alter table tbname PARTITION BY RANGE COLUMNS (ID)
(
partition p0 values less than (200000),
partition p1 values less than (400000),
partition p2 values less than (MAXVALUE)
);
//使用RANGE方式进行分区,适用于连续的值，如自增长:AUTO_INCREMENT；