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) */;
(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) */;
- MYSQL--表分区、查看分区
- mysql表分区
- MySql表分区
- MySQL的表分区
- MYSQL 表分区技术
- MySQL的表分区
- MySQL表分区
- MySql表分区
- mysql的表分区
- MySQL的表分区
- Mysql 表分区
- mysql 表分区
- MySQL的表分区
- Mysql的表分区
- mysql表分区
- mysql表分区
- MySQL的表分区
- mysql表分区
- 分享一套 python 试题
- 基类函数的this指针和派生类函数的this指针
- linux svn安装和配置
- Oracle RAC学习笔记:基本概念及入门 01
- 解决“Connection to https://dl-ssl.google.com refused”问题
- mysql表分区
- Oracle RAC学习笔记:基本概念及入门 02
- Guava源码分析——ServiceManager
- 32位和64位数据类型
- listView隔行设置颜色重写SimpleAdapter
- Oracle RAC学习笔记:基本概念及入门 03
- 百度腾讯面试题
- Java用native2ascii命令做unicode编码转换
- linux cache swap 以及 虚拟内存等