title: How to make partitioning in existing mysql table?
body: <p>I have a table called tbl_rtdata. I was dropped the all partitions in that table and create  the new partition in the below manner.</p>
  
  <pre><code>ALTER TABLE tbl_rtdata  PARTITION BY RANGE (Month(fld_date))
  
  SUBPARTITION BY HASH (Day(fld_date)) SUBPARTITIONS 12(   
  PARTITION Apr_0 VALUES LESS THAN (2012-05-01),
  PARTITION May_1 VALUES LESS THAN (2012-06-01),    
  PARTITION Jun_2 VALUES LESS THAN (2012-07-01),  
  PARTITION Jul_3 VALUES LESS THAN (2012-08-01),
  PARTITION Aug_4 VALUES LESS THAN (2012-09-01),
  PARTITION Sep_5 VALUES LESS THAN (2012-10-01),
  PARTITION Oct_6 VALUES LESS THAN (2012-11-01),  
  PARTITION Nov_7 VALUES LESS THAN (2012-12-01),
  PARTITION Dec_8 VALUES LESS THAN MAXVALUE );
  </code></pre>
  
  <p>But I got an Error : 
  <code>VALUES LESS THAN value must be strictly increasing for each partition.</code></p>
  
  <p>If I remove the subpartition in query it shows the error VALUES value for partition 'Apr_0' must have type INT</p>
  
  <p>What I should do to recover from this ?</p>