CREATE TABLE part_date3
          ( c1 bigint(20) unsigned NOT NULL AUTO_INCREMENT,
     c2 varchar(40) not null default '',
     c3 datetime not  NULL,
     PRIMARY KEY (c1,c3),
     KEY partidx(c3))  ENGINE=InnoDB DEFAULT CHARSET=utf8 
         partition by range (to_days(c3))
     (
     PARTITION p200912 VALUES LESS THAN (to_days('2010-01-01')),
     PARTITION p201001 VALUES LESS THAN (to_days('2010-02-01')),
     PARTITION p201002 VALUES LESS THAN (to_days('2010-03-01')),
     PARTITION p201003 VALUES LESS THAN (to_days('2010-04-01')),
     PARTITION p201004 VALUES LESS THAN (to_days('2010-05-01')),
     PARTITION p201005 VALUES LESS THAN (to_days('2010-06-01')),
     PARTITION p201006 VALUES LESS THAN (to_days('2010-07-01')),
     PARTITION p201007 VALUES LESS THAN (to_days('2010-08-01')),
     PARTITION p201008 VALUES LESS THAN (to_days('2010-09-01')),
     PARTITION p201009 VALUES LESS THAN (to_days('2010-10-01')),
     PARTITION p201010 VALUES LESS THAN (to_days('2010-11-01')),
     PARTITION p201011 VALUES LESS THAN (to_days('2010-12-01')),
     PARTITION p201012 VALUES LESS THAN (to_days('2011-01-01')),
     PARTITION p201101 VALUES LESS THAN (to_days('2011-02-01')),
     PARTITION p201102 VALUES LESS THAN (to_days('2011-03-01')),
     PARTITION p201103 VALUES LESS THAN (to_days('2011-04-01')),
     PARTITION p201104 VALUES LESS THAN (to_days('2011-05-01')),
     PARTITION p201105 VALUES LESS THAN (to_days('2011-06-01')),
     PARTITION p201106 VALUES LESS THAN (to_days('2011-07-01')),
     PARTITION p201107 VALUES LESS THAN (to_days('2011-08-01')),
     PARTITION p201108 VALUES LESS THAN (to_days('2011-09-01')),
     PARTITION p201109 VALUES LESS THAN (to_days('2011-10-01')),
     PARTITION p201110 VALUES LESS THAN (to_days('2011-11-01')),
     PARTITION p201111 VALUES LESS THAN (to_days('2011-12-01')),
     PARTITION p201112 VALUES LESS THAN (to_days('2012-01-01')),
     PARTITION p201912 VALUES LESS THAN MAXVALUE );
     
     CREATE TABLE part_date4
          ( c1 bigint(20) unsigned NOT NULL AUTO_INCREMENT,
     c2 varchar(40) not null default '',
     c3 datetime not  NULL,
     PRIMARY KEY (c1,c3),
     KEY partidx(c3))  ENGINE=InnoDB DEFAULT CHARSET=utf8 ;
     
     
     DELIMITER $$
DROP PROCEDURE IF EXISTS load_data3 $$
CREATE PROCEDURE load_data3()
BEGIN
    declare v int default 0;
    while v < 1000
    do
         insert into part_date3(c2,c3)
        values (uuid(),TIMESTAMPADD(month,-4,current_timestamp));
insert into part_date3(c2,c3)
        values (uuid(),TIMESTAMPADD(month,-3,current_timestamp));
insert into part_date3(c2,c3)
        values (uuid(),TIMESTAMPADD(month,-2,current_timestamp));
insert into part_date3(c2,c3)
        values (uuid(),TIMESTAMPADD(month,-1,current_timestamp));
insert into part_date3(c2,c3)
        values (uuid(),TIMESTAMPADD(month,0,current_timestamp));
insert into part_date3(c2,c3)
        values (uuid(),TIMESTAMPADD(month,1,current_timestamp));
insert into part_date3(c2,c3)
        values (uuid(),TIMESTAMPADD(month,2,current_timestamp));
insert into part_date3(c2,c3)
        values (uuid(),TIMESTAMPADD(month,3,current_timestamp));
insert into part_date3(c2,c3)
        values (uuid(),TIMESTAMPADD(month,4,current_timestamp));
insert into part_date3(c2,c3)
        values (uuid(),TIMESTAMPADD(month,5,current_timestamp));
insert into part_date3(c2,c3)
        values (uuid(),TIMESTAMPADD(month,6,current_timestamp));
insert into part_date3(c2,c3)
        values (uuid(),TIMESTAMPADD(month,7,current_timestamp));
insert into part_date3(c2,c3)
        values (uuid(),TIMESTAMPADD(month,8,current_timestamp));
         set v = v + 1;
    end while;

END $$
DELIMITER ;

DELIMITER $$
DROP PROCEDURE IF EXISTS load_data4 $$
CREATE PROCEDURE load_data4()
BEGIN
    declare v int default 0;
    while v < 1000
    do
         insert into part_date4(c2,c3)
        values (uuid(),TIMESTAMPADD(month,-4,current_timestamp));
insert into part_date4(c2,c3)
        values (uuid(),TIMESTAMPADD(month,-3,current_timestamp));
insert into part_date4(c2,c3)
        values (uuid(),TIMESTAMPADD(month,-2,current_timestamp));
insert into part_date4(c2,c3)
        values (uuid(),TIMESTAMPADD(month,-1,current_timestamp));
insert into part_date4(c2,c3)
        values (uuid(),TIMESTAMPADD(month,0,current_timestamp));
insert into part_date4(c2,c3)
        values (uuid(),TIMESTAMPADD(month,1,current_timestamp));
insert into part_date4(c2,c3)
        values (uuid(),TIMESTAMPADD(month,2,current_timestamp));
insert into part_date4(c2,c3)
        values (uuid(),TIMESTAMPADD(month,3,current_timestamp));
insert into part_date4(c2,c3)
        values (uuid(),TIMESTAMPADD(month,4,current_timestamp));
insert into part_date4(c2,c3)
        values (uuid(),TIMESTAMPADD(month,5,current_timestamp));
insert into part_date4(c2,c3)
        values (uuid(),TIMESTAMPADD(month,6,current_timestamp));
insert into part_date4(c2,c3)
        values (uuid(),TIMESTAMPADD(month,7,current_timestamp));
insert into part_date4(c2,c3)
        values (uuid(),TIMESTAMPADD(month,8,current_timestamp));
         set v = v + 1;
    end while;

END $$
DELIMITER ;