title: Partitioning MySQL table column
body: <p>I want to create the table in MySQL with the partitioning like below</p>
  
  <pre><code>CREATE TABLE `ccd` (
    `Created Month` varchar(255) DEFAULT NULL,
    `Created` varchar(255) DEFAULT NULL,
    `Employee Organization Name` varchar(255) DEFAULT NULL,
    `Employee Login` varchar(255) DEFAULT NULL,
    `Service Request #` varchar(255) DEFAULT NULL,
    `Status` varchar(255) DEFAULT NULL,
    `Description` longtext)
  ENGINE=MyISAM DEFAULT CHARSET=latin1
  
  PARTITION BY RANGE (SUBSTRING(`Created Month`,1,4)  )
  
  (PARTITION sp0 VALUES LESS THAN ('2010') ENGINE = MyISAM,
  
   PARTITION sp1 VALUES LESS THAN   ('2012' ) ENGINE = MyISAM,
  
   PARTITION sp2 VALUES LESS THAN ('2014' ) ENGINE = MyISAM
  
  );
  </code></pre>
  
  <p>In the  table , <code>Created Month</code> column will be having the values like </p>
  
  <pre><code>Created Month
  2011 / 02
  2011 / 06
  2012 / 02
  2013 / 01
  2013 / 02
  2013 / 05
  2013 / 05
  </code></pre>
  
  <p>When i'm trying to run the statement, i'm getting the error message like </p>
  
  <pre><code>ERROR: This partition function is not allowed
  Error Code: 1564
  </code></pre>
  
  <p>Anyone tell me, where i'm making the mistake..?</p>