按照月份分区

CREATE TABLE `pingstart_v1_hourly_report` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '标识ID',
  `geo` char(2) NOT NULL DEFAULT '' COMMENT '国家编码',
  `hour` int not null default 0 comment '小时',
  `day` date NOT NULL COMMENT '日期 YYYY-MM-DD',
  `v1_requests` int(10) NOT NULL DEFAULT 0 COMMENT 'v1请求数',
  `v1_fills` int(10) NOT NULL DEFAULT 0 COMMENT 'v1填充数',
  `v1_clicks` int(10) NOT NULL DEFAULT 0 COMMENT 'v1点击数',
  `last_update` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`,`day`),
  UNIQUE KEY `unique` (`geo`,`hour`,`day`) USING BTREE
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='pingstartv1每小时报表 一休'
 PARTITION BY RANGE (TO_DAYS(day))
(
 PARTITION part_201806 VALUES LESS THAN (201807) ENGINE = MyISAM,
 PARTITION part_201807 VALUES LESS THAN (201808) ENGINE = MyISAM,
 PARTITION part_201808 VALUES LESS THAN (201809) ENGINE = MyISAM,
 PARTITION part_201809 VALUES LESS THAN (201810) ENGINE = MyISAM,
 PARTITION part_201810 VALUES LESS THAN (201811) ENGINE = MyISAM,
 PARTITION part_201811 VALUES LESS THAN (201812) ENGINE = MyISAM,
 PARTITION part_201812 VALUES LESS THAN (201901) ENGINE = MyISAM,
 PARTITION part_201901 VALUES LESS THAN (201902) ENGINE = MyISAM,
 PARTITION part_201902 VALUES LESS THAN (201903) ENGINE = MyISAM,
 PARTITION part_201903 VALUES LESS THAN (201904) ENGINE = MyISAM,
 PARTITION part_201904 VALUES LESS THAN (201905) ENGINE = MyISAM,
 PARTITION part_201905 VALUES LESS THAN (201906) ENGINE = MyISAM,
 PARTITION part_201906 VALUES LESS THAN (201907) ENGINE = MyISAM,
 PARTITION part_201907 VALUES LESS THAN (201908) ENGINE = MyISAM,
 PARTITION part_201908 VALUES LESS THAN (201909) ENGINE = MyISAM,
 PARTITION part_201909 VALUES LESS THAN (201910) ENGINE = MyISAM,
 PARTITION part_201910 VALUES LESS THAN (201911) ENGINE = MyISAM,
 PARTITION part_201911 VALUES LESS THAN (201912) ENGINE = MyISAM,
 PARTITION part_201912 VALUES LESS THAN (202001) ENGINE = MyISAM,
 PARTITION part_202001 VALUES LESS THAN (202002) ENGINE = MyISAM,
 PARTITION part_202002 VALUES LESS THAN (202003) ENGINE = MyISAM,
 PARTITION part_202003 VALUES LESS THAN (202004) ENGINE = MyISAM,
 PARTITION part_202004 VALUES LESS THAN (202005) ENGINE = MyISAM,
 PARTITION part_202005 VALUES LESS THAN (202006) ENGINE = MyISAM,
 PARTITION part_202006 VALUES LESS THAN (202007) ENGINE = MyISAM,
 PARTITION part_202007 VALUES LESS THAN (202008) ENGINE = MyISAM,
 PARTITION part_202008 VALUES LESS THAN (202009) ENGINE = MyISAM,
 PARTITION part_202009 VALUES LESS THAN (202010) ENGINE = MyISAM
 )