title: How do I create a partition for every month of the current year
body: <p>I want to partition my data by "MONTH"</p>
  
  <p>I am trying this,</p>
  
  <pre><code>ALTER TABLE t1 PARTITION BY RANGE(TO_DAYS(FROM_UNIXTIME(transaction_date)))(
  PARTITION JAN VALUES LESS THAN (TO_DAYS('2013-02-01')),
  PARTITION FEB VALUES LESS THAN (TO_DAYS('2013-03-01')),
  PARTITION MAR VALUES LESS THAN (TO_DAYS('2013-04-01')),
  PARTITION APR VALUES LESS THAN (TO_DAYS('2013-05-01')),
  PARTITION MAY VALUES LESS THAN (TO_DAYS('2013-06-01')),
  PARTITION JUN VALUES LESS THAN (TO_DAYS('2013-07-01')),
  PARTITION JUL VALUES LESS THAN (TO_DAYS('2013-08-01')),
  PARTITION AUG VALUES LESS THAN (TO_DAYS('2013-09-01')),
  PARTITION SEP VALUES LESS THAN (TO_DAYS('2013-10-01')),
  PARTITION `OCT` VALUES LESS THAN (TO_DAYS('2013-11-01')),
  PARTITION NOV VALUES LESS THAN (TO_DAYS('2013-12-01')),
  PARTITION `DEC` VALUES LESS THAN (TO_DAYS('2014-01-01'))
  </code></pre>
  
  <p>); </p>
  
  <pre><code>transaction_date INT NOT NULL //store date by UNIX_TIMESTAMP()
  </code></pre>
  
  <p>Error Code: 1564
  This partition function is not allowed</p>
  
  <p>How do I create a partition for every month of the current year?</p>