mysql表分区

来源:互联网 发布:淘宝客怎样推广产品 编辑:程序博客网 时间:2024/05/12 01:17
/*!50100 PARTITION BY RANGE (to_days(COLLECTTIME))
(PARTITION pmin VALUES LESS THAN (734138) ENGINE = InnoDB,
 PARTITION p201001 VALUES LESS THAN (734169) ENGINE = InnoDB,
 PARTITION p201002 VALUES LESS THAN (734197) ENGINE = InnoDB,
 PARTITION p201003 VALUES LESS THAN (734228) ENGINE = InnoDB,
 PARTITION p201004 VALUES LESS THAN (734258) ENGINE = InnoDB,
 PARTITION p201005 VALUES LESS THAN (734289) ENGINE = InnoDB,
 PARTITION p201006 VALUES LESS THAN (734319) ENGINE = InnoDB,
 PARTITION p201007 VALUES LESS THAN (734350) ENGINE = InnoDB,
 PARTITION p201008 VALUES LESS THAN (734381) ENGINE = InnoDB,
 PARTITION p201009 VALUES LESS THAN (734411) ENGINE = InnoDB,
 PARTITION p201010 VALUES LESS THAN (734442) ENGINE = InnoDB,
 PARTITION p201011 VALUES LESS THAN (734472) ENGINE = InnoDB,
 PARTITION p201012 VALUES LESS THAN (734503) ENGINE = InnoDB,
 PARTITION p201101 VALUES LESS THAN (734534) ENGINE = InnoDB,
 PARTITION p201102 VALUES LESS THAN (734562) ENGINE = InnoDB,
 PARTITION p201103 VALUES LESS THAN (734593) ENGINE = InnoDB,
 PARTITION p201104 VALUES LESS THAN (734623) ENGINE = InnoDB,
 PARTITION p201105 VALUES LESS THAN (734654) ENGINE = InnoDB,
 PARTITION p201106 VALUES LESS THAN (734684) ENGINE = InnoDB,
 PARTITION p201107 VALUES LESS THAN (734715) ENGINE = InnoDB,
 PARTITION p201108 VALUES LESS THAN (734746) ENGINE = InnoDB,
 PARTITION p201109 VALUES LESS THAN (734776) ENGINE = InnoDB,
 PARTITION p201110 VALUES LESS THAN (734807) ENGINE = InnoDB,
 PARTITION p201111 VALUES LESS THAN (734837) ENGINE = InnoDB,
 PARTITION p201112 VALUES LESS THAN (734868) ENGINE = InnoDB,
 PARTITION p201201 VALUES LESS THAN (734899) ENGINE = InnoDB,
 PARTITION p201202 VALUES LESS THAN (734928) ENGINE = InnoDB,
 PARTITION p201203 VALUES LESS THAN (734959) ENGINE = InnoDB,
 PARTITION p201204 VALUES LESS THAN (734989) ENGINE = InnoDB,
 PARTITION p201205 VALUES LESS THAN (735020) ENGINE = InnoDB,
 PARTITION p201206 VALUES LESS THAN (735050) ENGINE = InnoDB,
 PARTITION p201207 VALUES LESS THAN (735081) ENGINE = InnoDB,
 PARTITION p201208 VALUES LESS THAN (735112) ENGINE = InnoDB,
 PARTITION p201209 VALUES LESS THAN (735142) ENGINE = InnoDB,
 PARTITION p201210 VALUES LESS THAN (735173) ENGINE = InnoDB,
 PARTITION p201211 VALUES LESS THAN (735203) ENGINE = InnoDB,
 PARTITION p201212 VALUES LESS THAN (735234) ENGINE = InnoDB,
 PARTITION p201301 VALUES LESS THAN (735265) ENGINE = InnoDB,
 PARTITION p201302 VALUES LESS THAN (735293) ENGINE = InnoDB,
 PARTITION p201303 VALUES LESS THAN (735324) ENGINE = InnoDB,
 PARTITION p201304 VALUES LESS THAN (735354) ENGINE = InnoDB,
 PARTITION p201305 VALUES LESS THAN (735385) ENGINE = InnoDB,
 PARTITION p201306 VALUES LESS THAN (735415) ENGINE = InnoDB,
 PARTITION p201307 VALUES LESS THAN (735446) ENGINE = InnoDB,
 PARTITION p201308 VALUES LESS THAN (735477) ENGINE = InnoDB,
 PARTITION p201309 VALUES LESS THAN (735507) ENGINE = InnoDB,
 PARTITION p201310 VALUES LESS THAN (735538) ENGINE = InnoDB,
 PARTITION p201311 VALUES LESS THAN (735568) ENGINE = InnoDB,
 PARTITION p201312 VALUES LESS THAN (735599) ENGINE = InnoDB,
 PARTITION pmax VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */;
原创粉丝点击