I am a newbie into partition. First I have a table with auto increment with its primary key and many other fields. I wanted to partition based on dataInsertDateTime column. It have me error so I had to rebuild the primary inclusive of the dataID and dataInsertDateTime which I think is correct step. I just tried like below scripts. How to verify if my partition is being build accordingly? I tried explain a query with the dataInsertTime<'2012-12-11' is showing me both p0 and p1. Kind of confuse here.
ALTER TABLE tblData PARTITION BY RANGE (to_days(`dataInsertDateTime`)) ( PARTITION p0 VALUES LESS THAN (to_days('2012-12-10')), PARTITION p1 VALUES LESS THAN (to_days('2012-12-11')) )