mysql的分区
CREATE TABLE `test100` (`xuhao` int(11) NOT NULL,
`xuhao2` int(11) NOT NULL,
) ENGINE=innodb DEFAULT CHARSET=utf8 PARTITION BY RANGE (xuhao)
(PARTITION p201303 VALUES LESS THAN (unix_timestamp('2013-04-01')),PARTITION p201304 VALUES LESS THAN (unix_timestamp('2013-05-01')),PARTITION p201305 VALUES LESS THAN (unix_timestamp('2013-06-01')),PARTITION p201306 VALUES LESS THAN (unix_timestamp('2013-07-01')),PARTITION p201307 VALUES LESS THAN (unix_timestamp('2013-08-01')),PARTITION p201308 VALUES LESS THAN (unix_timestamp('2013-09-01')),PARTITION p201309 VALUES LESS THAN (unix_timestamp('2013-10-01')),PARTITION p201310 VALUES LESS THAN (unix_timestamp('2013-11-01')),PARTITION p201311 VALUES LESS THAN (unix_timestamp('2013-12-01')),PARTITION p201312 VALUES LESS THAN (unix_timestamp('2014-01-01')),PARTITION p201401 VALUES LESS THAN (unix_timestamp('2014-02-01'))
);
页:
[1]