MySQL Forums
Forum List  »  Partitioning

Re: range columns including datetime column
Posted by: Rob Voyer
Date: August 16, 2012 07:15AM

Thanks Mattias,

I changed the partition rules as follows:


PARTITION BY RANGE COLUMNS(period,start) (
PARTITION p123 VALUES LESS THAN (3, MAXVALUE),
PARTITION p4_1205 VALUES LESS THAN (4,'20120601000000'),
PARTITION p4_1206 VALUES LESS THAN (4,'20120701000000'),
PARTITION p4_1207 VALUES LESS THAN (4,'20120801000000'),
PARTITION p4_1208 VALUES LESS THAN (4,'20120901000000'),
PARTITION p4_1209 VALUES LESS THAN (4,'20121001000000'),
PARTITION p4_1210 VALUES LESS THAN (4,'20121101000000'),
PARTITION p4_1211 VALUES LESS THAN (4,'20121201000000'),
PARTITION p4_1212 VALUES LESS THAN (4,'20130101000000'),
PARTITION p5_1205 VALUES LESS THAN (5,'20120601000000'),
PARTITION p5_1206 VALUES LESS THAN (5,'20120701000000'),
PARTITION p5_1207 VALUES LESS THAN (5,'20120801000000'),
PARTITION p5_1208 VALUES LESS THAN (5,'20120901000000'),
PARTITION p5_1209 VALUES LESS THAN (5,'20121001000000'),
PARTITION p5_1210 VALUES LESS THAN (5,'20121101000000'),
PARTITION p5_1211 VALUES LESS THAN (5,'20121201000000'),
PARTITION p5_1212 VALUES LESS THAN (5,'20130101000000'),
PARTITION p6 VALUES LESS THAN (6,MAXVALUE)

This works but I have partitions for periods 4 and 5 when merging them together would have been better. But I can live with this.

Options: ReplyQuote


Subject
Views
Written By
Posted
2384
August 15, 2012 10:01PM
Re: range columns including datetime column
1293
August 16, 2012 07:15AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.