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)*/;

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)*/;