分区

分区
ALTER TABLE `sqltest` PARTITION BY RANGE ( `id` ) (
    PARTITION p161130 VALUES LESS THAN ( 2000000 ),
    PARTITION p161231 VALUES LESS THAN ( 4000000 ),
    PARTITION p170531 VALUES LESS THAN ( 8000000 ),
    PARTITION pnow VALUES LESS THAN MAXVALUE 
    );