 <p>you can use given query.</p> <pre><code>CREATE TABLE TABLE_NAME1 ( id BIGINT(20) NOT NULL AUTO_INCREMENT, Ctime DATETIME DEFAULT NULL, KEY id (id) ) ENGINE=INNODB AUTO_INCREMENT=286802795 DEFAULT CHARSET=utf8 PARTITION BY RANGE( TO_DAYS(Ctime) ) ( PARTITION p1 VALUES LESS THAN (TO_DAYS('2011-04-02')), PARTITION p2 VALUES LESS THAN (TO_DAYS('2011-04-03')), PARTITION p3 VALUES LESS THAN (TO_DAYS('2011-04-04')), PARTITION p4 VALUES LESS THAN (TO_DAYS('2011-04-05')), PARTITION p5 VALUES LESS THAN (TO_DAYS('2011-04-06')), PARTITION p6 VALUES LESS THAN (TO_DAYS('2011-04-07')) ); </code></pre>