mysql创建分区表_创建MySQL分区表

CREATE TABLE`table1` (

....

) ENGINE=InnoDB DEFAULT CHARSET=utf8/*!50500 PARTITION BY RANGE COLUMNS(Create_Date)

(PARTITION P2011_10 VALUES LESS THAN ('2011-10-01') ENGINE = InnoDB,

PARTITION P2011_11 VALUES LESS THAN ('2011-11-01') ENGINE = InnoDB,

PARTITION P2011_12 VALUES LESS THAN ('2011-12-01') ENGINE = InnoDB,

PARTITION P2012_01 VALUES LESS THAN ('2012-01-01') ENGINE = InnoDB,

PARTITION P2012_02 VALUES LESS THAN ('2012-02-01') ENGINE = InnoDB,

PARTITION P2012_03 VALUES LESS THAN ('2012-03-01') ENGINE = InnoDB,

PARTITION P2012_04 VALUES LESS THAN ('2012-04-01') ENGINE = InnoDB,

PARTITION P2012_05 VALUES LESS THAN ('2012-05-01') ENGINE = InnoDB,

PARTITION P2012_06 VALUES LESS THAN ('2012-06-01') ENGINE = InnoDB,

PARTITION P2012_07 VALUES LESS THAN ('2012-07-01') ENGINE = InnoDB,

PARTITION P2012_08 VALUES LESS THAN ('2012-08-01') ENGINE = InnoDB,

PARTITION P2012_09 VALUES LESS THAN ('2012-09-01') ENGINE = InnoDB,

PARTITION P2012_10 VALUES LESS THAN ('2012-10-01') ENGINE = InnoDB,

PARTITION P2012_11 VALUES LESS THAN ('2012-11-01') ENGINE = InnoDB,

PARTITION P2012_12 VALUES LESS THAN ('2012-12-01') ENGINE = InnoDB,

PARTITION P2013_01 VALUES LESS THAN ('2013-01-01') ENGINE = InnoDB,

PARTITION P2013_02 VALUES LESS THAN ('2013-02-01') ENGINE = InnoDB,

PARTITION P2013_03 VALUES LESS THAN ('2013-03-01') ENGINE = InnoDB,

PARTITION P2013_04 VALUES LESS THAN ('2013-04-01') ENGINE = InnoDB,

PARTITION P2013_05 VALUES LESS THAN ('2013-05-01') ENGINE = InnoDB,

PARTITION PMaxValue VALUES LESS THAN (MAXVALUE) ENGINE = InnoDB)*/;