业务场景，某大型医院的检验检查执行用药表有2亿多，数据同步查询sql和业务查询 sql性能很差，有十几秒甚至更多，索引已经加了，因为数据太大，没办法只能采用分区分方案，以前做过oracle表分区看了下mysql分区的语法应该差不多，大概了解了下数据特征打算采用某个时间字段来做分区时间字段，平均一个月的数据也有600万左右，还是太大，所以打算针对半个月做分区，
分区sql：
##按照半个月分区
CREATE TABLE `yx_test` (
`id` int(10) NOT NULL,
`order_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '对应医嘱id',
`group_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '分组号',
`patient_ident` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`hospital_number` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`plan_time` datetime NOT NULL COMMENT '计划执行时间',
`update_by` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`create_by` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=REDUNDANT COMMENT='医嘱执行计划表\r\n'
PARTITION BY RANGE(TO_DAYS (plan_time))
(
PARTITION p0 VALUES LESS THAN(TO_DAYS('2001-01-01')),
PARTITION p1 VALUES LESS THAN(TO_DAYS('2001-01-15')),
PARTITION p2 VALUES LESS THAN(TO_DAYS('2001-02-01')),
PARTITION p3 VALUES LESS THAN(TO_DAYS('2001-02-15')),
PARTITION p4 VALUES LESS THAN(TO_DAYS('2001-03-01')),
PARTITION p5 VALUES LESS THAN(TO_DAYS('2001-03-15')),
PARTITION p6 VALUES LESS THAN(TO_DAYS('2001-04-01')),
PARTITION p7 VALUES LESS THAN(TO_DAYS('2001-04-15')),
PARTITION p8 VALUES LESS THAN(TO_DAYS('2001-05-01')),
PARTITION p9 VALUES LESS THAN(TO_DAYS('2001-05-15')),
PARTITION p10 VALUES LESS THAN(TO_DAYS('2001-06-01')),
PARTITION p11 VALUES LESS THAN(TO_DAYS('2001-06-15')),
PARTITION p12 VALUES LESS THAN(TO_DAYS('2001-07-01')),
PARTITION p13 VALUES LESS THAN(TO_DAYS('2001-07-15')),
PARTITION p14 VALUES LESS THAN(TO_DAYS('2001-08-01')),
PARTITION p15 VALUES LESS THAN(TO_DAYS('2001-08-15')),
PARTITION p16 VALUES LESS THAN(TO_DAYS('2001-09-01')),
PARTITION p17 VALUES LESS THAN(TO_DAYS('2001-09-15')),
PARTITION p18 VALUES LESS THAN(TO_DAYS('2001-10-01')),
PARTITION p19 VALUES LESS THAN(TO_DAYS('2001-10-15')),
PARTITION p20 VALUES LESS THAN(TO_DAYS('2001-11-01')),
PARTITION p21 VALUES LESS THAN(TO_DAYS('2001-11-15')),
PARTITION p22 VALUES LESS THAN(TO_DAYS('2001-12-01')),
PARTITION p23 VALUES LESS THAN(TO_DAYS('2001-12-15')),
PARTITION p24 VALUES LESS THAN(TO_DAYS('2002-01-01')),
PARTITION p25 VALUES LESS THAN(TO_DAYS('2002-01-15')),
PARTITION p26 VALUES LESS THAN(TO_DAYS('2002-02-01')),
PARTITION p27 VALUES LESS THAN(TO_DAYS('2002-02-15')),
PARTITION p28 VALUES LESS THAN(TO_DAYS('2002-03-01')),
PARTITION p29 VALUES LESS THAN(TO_DAYS('2002-03-15')),
PARTITION p30 VALUES LESS THAN(TO_DAYS('2002-04-01')),
PARTITION p31 VALUES LESS THAN(TO_DAYS('2002-04-15')),
PARTITION p32 VALUES LESS THAN(TO_DAYS('2002-05-01')),
PARTITION p33 VALUES LESS THAN(TO_DAYS('2002-05-15')),
PARTITION p34 VALUES LESS THAN(TO_DAYS('2002-06-01')),
PARTITION p35 VALUES LESS THAN(TO_DAYS('2002-06-15')),
PARTITION p36 VALUES LESS THAN(TO_DAYS('2002-07-01')),
PARTITION p37 VALUES LESS THAN(TO_DAYS('2002-07-15')),
PARTITION p38 VALUES LESS THAN(TO_DAYS('2002-08-01')),
PARTITION p39 VALUES LESS THAN(TO_DAYS('2002-08-15')),
PARTITION p40 VALUES LESS THAN(TO_DAYS('2002-09-01')),
PARTITION p41 VALUES LESS THAN(TO_DAYS('2002-09-15')),
PARTITION p42 VALUES LESS THAN(TO_DAYS('2002-10-01')),
PARTITION p43 VALUES LESS THAN(TO_DAYS('2002-10-15')),
PARTITION p44 VALUES LESS THAN(TO_DAYS('2002-11-01')),
PARTITION p45 VALUES LESS THAN(TO_DAYS('2002-11-15')),
PARTITION p46 VALUES LESS THAN(TO_DAYS('2002-12-01')),
PARTITION p47 VALUES LESS THAN(TO_DAYS('2002-12-15')),
PARTITION p48 VALUES LESS THAN(TO_DAYS('2003-01-01')),
PARTITION p49 VALUES LESS THAN(TO_DAYS('2003-01-15')),
PARTITION p50 VALUES LESS THAN(TO_DAYS('2003-02-01')),
PARTITION p51 VALUES LESS THAN(TO_DAYS('2003-02-15')),
PARTITION p52 VALUES LESS THAN(TO_DAYS('2003-03-01')),
PARTITION p53 VALUES LESS THAN(TO_DAYS('2003-03-15')),
PARTITION p54 VALUES LESS THAN(TO_DAYS('2003-04-01')),
PARTITION p55 VALUES LESS THAN(TO_DAYS('2003-04-15')),
PARTITION p56 VALUES LESS THAN(TO_DAYS('2003-05-01')),
PARTITION p57 VALUES LESS THAN(TO_DAYS('2003-05-15')),
PARTITION p58 VALUES LESS THAN(TO_DAYS('2003-06-01')),
PARTITION p59 VALUES LESS THAN(TO_DAYS('2003-06-15')),
PARTITION p60 VALUES LESS THAN(TO_DAYS('2003-07-01')),
PARTITION p61 VALUES LESS THAN(TO_DAYS('2003-07-15')),
PARTITION p62 VALUES LESS THAN(TO_DAYS('2003-08-01')),
PARTITION p63 VALUES LESS THAN(TO_DAYS('2003-08-15')),
PARTITION p64 VALUES LESS THAN(TO_DAYS('2003-09-01')),
PARTITION p65 VALUES LESS THAN(TO_DAYS('2003-09-15')),
PARTITION p66 VALUES LESS THAN(TO_DAYS('2003-10-01')),
PARTITION p67 VALUES LESS THAN(TO_DAYS('2003-10-15')),
PARTITION p68 VALUES LESS THAN(TO_DAYS('2003-11-01')),
PARTITION p69 VALUES LESS THAN(TO_DAYS('2003-11-15')),
PARTITION p70 VALUES LESS THAN(TO_DAYS('2003-12-01')),
PARTITION p71 VALUES LESS THAN(TO_DAYS('2003-12-15')),
PARTITION p72 VALUES LESS THAN(TO_DAYS('2004-01-01')),
PARTITION p73 VALUES LESS THAN(TO_DAYS('2004-01-15')),
PARTITION p74 VALUES LESS THAN(TO_DAYS('2004-02-01')),
PARTITION p75 VALUES LESS THAN(TO_DAYS('2004-02-15')),
PARTITION p76 VALUES LESS THAN(TO_DAYS('2004-03-01')),
PARTITION p77 VALUES LESS THAN(TO_DAYS('2004-03-15')),
PARTITION p78 VALUES LESS THAN(TO_DAYS('2004-04-01')),
PARTITION p79 VALUES LESS THAN(TO_DAYS('2004-04-15')),
PARTITION p80 VALUES LESS THAN(TO_DAYS('2004-05-01')),
PARTITION p81 VALUES LESS THAN(TO_DAYS('2004-05-15')),
PARTITION p82 VALUES LESS THAN(TO_DAYS('2004-06-01')),
PARTITION p83 VALUES LESS THAN(TO_DAYS('2004-06-15')),
PARTITION p84 VALUES LESS THAN(TO_DAYS('2004-07-01')),
PARTITION p85 VALUES LESS THAN(TO_DAYS('2004-07-15')),
PARTITION p86 VALUES LESS THAN(TO_DAYS('2004-08-01')),
PARTITION p87 VALUES LESS THAN(TO_DAYS('2004-08-15')),
PARTITION p88 VALUES LESS THAN(TO_DAYS('2004-09-01')),
PARTITION p89 VALUES LESS THAN(TO_DAYS('2004-09-15')),
PARTITION p90 VALUES LESS THAN(TO_DAYS('2004-10-01')),
PARTITION p91 VALUES LESS THAN(TO_DAYS('2004-10-15')),
PARTITION p92 VALUES LESS THAN(TO_DAYS('2004-11-01')),
PARTITION p93 VALUES LESS THAN(TO_DAYS('2004-11-15')),
PARTITION p94 VALUES LESS THAN(TO_DAYS('2004-12-01')),
PARTITION p95 VALUES LESS THAN(TO_DAYS('2004-12-15')),
PARTITION p96 VALUES LESS THAN(TO_DAYS('2005-01-01')),
PARTITION p97 VALUES LESS THAN(TO_DAYS('2005-01-15')),
PARTITION p98 VALUES LESS THAN(TO_DAYS('2005-02-01')),
PARTITION p99 VALUES LESS THAN(TO_DAYS('2005-02-15')),
PARTITION p100 VALUES LESS THAN(TO_DAYS('2005-03-01')),
PARTITION p101 VALUES LESS THAN(TO_DAYS('2005-03-15')),
PARTITION p102 VALUES LESS THAN(TO_DAYS('2005-04-01')),
PARTITION p103 VALUES LESS THAN(TO_DAYS('2005-04-15')),
PARTITION p104 VALUES LESS THAN(TO_DAYS('2005-05-01')),
PARTITION p105 VALUES LESS THAN(TO_DAYS('2005-05-15')),
PARTITION p106 VALUES LESS THAN(TO_DAYS('2005-06-01')),
PARTITION p107 VALUES LESS THAN(TO_DAYS('2005-06-15')),
PARTITION p108 VALUES LESS THAN(TO_DAYS('2005-07-01')),
PARTITION p109 VALUES LESS THAN(TO_DAYS('2005-07-15')),
PARTITION p110 VALUES LESS THAN(TO_DAYS('2005-08-01')),
PARTITION p111 VALUES LESS THAN(TO_DAYS('2005-08-15')),
PARTITION p112 VALUES LESS THAN(TO_DAYS('2005-09-01')),
PARTITION p113 VALUES LESS THAN(TO_DAYS('2005-09-15')),
PARTITION p114 VALUES LESS THAN(TO_DAYS('2005-10-01')),
PARTITION p115 VALUES LESS THAN(TO_DAYS('2005-10-15')),
PARTITION p116 VALUES LESS THAN(TO_DAYS('2005-11-01')),
PARTITION p117 VALUES LESS THAN(TO_DAYS('2005-11-15')),
PARTITION p118 VALUES LESS THAN(TO_DAYS('2005-12-01')),
PARTITION p119 VALUES LESS THAN(TO_DAYS('2005-12-15')),
PARTITION p120 VALUES LESS THAN(TO_DAYS('2006-01-01')),
PARTITION p121 VALUES LESS THAN(TO_DAYS('2006-01-15')),
PARTITION p122 VALUES LESS THAN(TO_DAYS('2006-02-01')),
PARTITION p123 VALUES LESS THAN(TO_DAYS('2006-02-15')),
PARTITION p124 VALUES LESS THAN(TO_DAYS('2006-03-01')),
PARTITION p125 VALUES LESS THAN(TO_DAYS('2006-03-15')),
PARTITION p126 VALUES LESS THAN(TO_DAYS('2006-04-01')),
PARTITION p127 VALUES LESS THAN(TO_DAYS('2006-04-15')),
PARTITION p128 VALUES LESS THAN(TO_DAYS('2006-05-01')),
PARTITION p129 VALUES LESS THAN(TO_DAYS('2006-05-15')),
PARTITION p130 VALUES LESS THAN(TO_DAYS('2006-06-01')),
PARTITION p131 VALUES LESS THAN(TO_DAYS('2006-06-15')),
PARTITION p132 VALUES LESS THAN(TO_DAYS('2006-07-01')),
PARTITION p133 VALUES LESS THAN(TO_DAYS('2006-07-15')),
PARTITION p134 VALUES LESS THAN(TO_DAYS('2006-08-01')),
PARTITION p135 VALUES LESS THAN(TO_DAYS('2006-08-15')),
PARTITION p136 VALUES LESS THAN(TO_DAYS('2006-09-01')),
PARTITION p137 VALUES LESS THAN(TO_DAYS('2006-09-15')),
PARTITION p138 VALUES LESS THAN(TO_DAYS('2006-10-01')),
PARTITION p139 VALUES LESS THAN(TO_DAYS('2006-10-15')),
PARTITION p140 VALUES LESS THAN(TO_DAYS('2006-11-01')),
PARTITION p141 VALUES LESS THAN(TO_DAYS('2006-11-15')),
PARTITION p142 VALUES LESS THAN(TO_DAYS('2006-12-01')),
PARTITION p143 VALUES LESS THAN(TO_DAYS('2006-12-15')),
PARTITION p144 VALUES LESS THAN(TO_DAYS('2007-01-01')),
PARTITION p145 VALUES LESS THAN(TO_DAYS('2007-01-15')),
PARTITION p146 VALUES LESS THAN(TO_DAYS('2007-02-01')),
PARTITION p147 VALUES LESS THAN(TO_DAYS('2007-02-15')),
PARTITION p148 VALUES LESS THAN(TO_DAYS('2007-03-01')),
PARTITION p149 VALUES LESS THAN(TO_DAYS('2007-03-15')),
PARTITION p150 VALUES LESS THAN(TO_DAYS('2007-04-01')),
PARTITION p151 VALUES LESS THAN(TO_DAYS('2007-04-15')),
PARTITION p152 VALUES LESS THAN(TO_DAYS('2007-05-01')),
PARTITION p153 VALUES LESS THAN(TO_DAYS('2007-05-15')),
PARTITION p154 VALUES LESS THAN(TO_DAYS('2007-06-01')),
PARTITION p155 VALUES LESS THAN(TO_DAYS('2007-06-15')),
PARTITION p156 VALUES LESS THAN(TO_DAYS('2007-07-01')),
PARTITION p157 VALUES LESS THAN(TO_DAYS('2007-07-15')),
PARTITION p158 VALUES LESS THAN(TO_DAYS('2007-08-01')),
PARTITION p159 VALUES LESS THAN(TO_DAYS('2007-08-15')),
PARTITION p160 VALUES LESS THAN(TO_DAYS('2007-09-01')),
PARTITION p161 VALUES LESS THAN(TO_DAYS('2007-09-15')),
PARTITION p162 VALUES LESS THAN(TO_DAYS('2007-10-01')),
PARTITION p163 VALUES LESS THAN(TO_DAYS('2007-10-15')),
PARTITION p164 VALUES LESS THAN(TO_DAYS('2007-11-01')),
PARTITION p165 VALUES LESS THAN(TO_DAYS('2007-11-15')),
PARTITION p166 VALUES LESS THAN(TO_DAYS('2007-12-01')),
PARTITION p167 VALUES LESS THAN(TO_DAYS('2007-12-15')),
PARTITION p168 VALUES LESS THAN(TO_DAYS('2008-01-01')),
PARTITION p169 VALUES LESS THAN(TO_DAYS('2008-01-15')),
PARTITION p170 VALUES LESS THAN(TO_DAYS('2008-02-01')),
PARTITION p171 VALUES LESS THAN(TO_DAYS('2008-02-15')),
PARTITION p172 VALUES LESS THAN(TO_DAYS('2008-03-01')),
PARTITION p173 VALUES LESS THAN(TO_DAYS('2008-03-15')),
PARTITION p174 VALUES LESS THAN(TO_DAYS('2008-04-01')),
PARTITION p175 VALUES LESS THAN(TO_DAYS('2008-04-15')),
PARTITION p176 VALUES LESS THAN(TO_DAYS('2008-05-01')),
PARTITION p177 VALUES LESS THAN(TO_DAYS('2008-05-15')),
PARTITION p178 VALUES LESS THAN(TO_DAYS('2008-06-01')),
PARTITION p179 VALUES LESS THAN(TO_DAYS('2008-06-15')),
PARTITION p180 VALUES LESS THAN(TO_DAYS('2008-07-01')),
PARTITION p181 VALUES LESS THAN(TO_DAYS('2008-07-15')),
PARTITION p182 VALUES LESS THAN(TO_DAYS('2008-08-01')),
PARTITION p183 VALUES LESS THAN(TO_DAYS('2008-08-15')),
PARTITION p184 VALUES LESS THAN(TO_DAYS('2008-09-01')),
PARTITION p185 VALUES LESS THAN(TO_DAYS('2008-09-15')),
PARTITION p186 VALUES LESS THAN(TO_DAYS('2008-10-01')),
PARTITION p187 VALUES LESS THAN(TO_DAYS('2008-10-15')),
PARTITION p188 VALUES LESS THAN(TO_DAYS('2008-11-01')),
PARTITION p189 VALUES LESS THAN(TO_DAYS('2008-11-15')),
PARTITION p190 VALUES LESS THAN(TO_DAYS('2008-12-01')),
PARTITION p191 VALUES LESS THAN(TO_DAYS('2008-12-15')),
PARTITION p192 VALUES LESS THAN(TO_DAYS('2009-01-01')),
PARTITION p193 VALUES LESS THAN(TO_DAYS('2009-01-15')),
PARTITION p194 VALUES LESS THAN(TO_DAYS('2009-02-01')),
PARTITION p195 VALUES LESS THAN(TO_DAYS('2009-02-15')),
PARTITION p196 VALUES LESS THAN(TO_DAYS('2009-03-01')),
PARTITION p197 VALUES LESS THAN(TO_DAYS('2009-03-15')),
PARTITION p198 VALUES LESS THAN(TO_DAYS('2009-04-01')),
PARTITION p199 VALUES LESS THAN(TO_DAYS('2009-04-15')),
PARTITION p200 VALUES LESS THAN(TO_DAYS('2009-05-01')),
PARTITION p201 VALUES LESS THAN(TO_DAYS('2009-05-15')),
PARTITION p202 VALUES LESS THAN(TO_DAYS('2009-06-01')),
PARTITION p203 VALUES LESS THAN(TO_DAYS('2009-06-15')),
PARTITION p204 VALUES LESS THAN(TO_DAYS('2009-07-01')),
PARTITION p205 VALUES LESS THAN(TO_DAYS('2009-07-15')),
PARTITION p206 VALUES LESS THAN(TO_DAYS('2009-08-01')),
PARTITION p207 VALUES LESS THAN(TO_DAYS('2009-08-15')),
PARTITION p208 VALUES LESS THAN(TO_DAYS('2009-09-01')),
PARTITION p209 VALUES LESS THAN(TO_DAYS('2009-09-15')),
PARTITION p210 VALUES LESS THAN(TO_DAYS('2009-10-01')),
PARTITION p211 VALUES LESS THAN(TO_DAYS('2009-10-15')),
PARTITION p212 VALUES LESS THAN(TO_DAYS('2009-11-01')),
PARTITION p213 VALUES LESS THAN(TO_DAYS('2009-11-15')),
PARTITION p214 VALUES LESS THAN(TO_DAYS('2009-12-01')),
PARTITION p215 VALUES LESS THAN(TO_DAYS('2009-12-15')),
PARTITION p216 VALUES LESS THAN(TO_DAYS('2010-01-01')),
PARTITION p217 VALUES LESS THAN(TO_DAYS('2010-01-15')),
PARTITION p218 VALUES LESS THAN(TO_DAYS('2010-02-01')),
PARTITION p219 VALUES LESS THAN(TO_DAYS('2010-02-15')),
PARTITION p220 VALUES LESS THAN(TO_DAYS('2010-03-01')),
PARTITION p221 VALUES LESS THAN(TO_DAYS('2010-03-15')),
PARTITION p222 VALUES LESS THAN(TO_DAYS('2010-04-01')),
PARTITION p223 VALUES LESS THAN(TO_DAYS('2010-04-15')),
PARTITION p224 VALUES LESS THAN(TO_DAYS('2010-05-01')),
PARTITION p225 VALUES LESS THAN(TO_DAYS('2010-05-15')),
PARTITION p226 VALUES LESS THAN(TO_DAYS('2010-06-01')),
PARTITION p227 VALUES LESS THAN(TO_DAYS('2010-06-15')),
PARTITION p228 VALUES LESS THAN(TO_DAYS('2010-07-01')),
PARTITION p229 VALUES LESS THAN(TO_DAYS('2010-07-15')),
PARTITION p230 VALUES LESS THAN(TO_DAYS('2010-08-01')),
PARTITION p231 VALUES LESS THAN(TO_DAYS('2010-08-15')),
PARTITION p232 VALUES LESS THAN(TO_DAYS('2010-09-01')),
PARTITION p233 VALUES LESS THAN(TO_DAYS('2010-09-15')),
PARTITION p234 VALUES LESS THAN(TO_DAYS('2010-10-01')),
PARTITION p235 VALUES LESS THAN(TO_DAYS('2010-10-15')),
PARTITION p236 VALUES LESS THAN(TO_DAYS('2010-11-01')),
PARTITION p237 VALUES LESS THAN(TO_DAYS('2010-11-15')),
PARTITION p238 VALUES LESS THAN(TO_DAYS('2010-12-01')),
PARTITION p239 VALUES LESS THAN(TO_DAYS('2010-12-15')),
PARTITION p240 VALUES LESS THAN(TO_DAYS('2011-01-01')),
PARTITION p241 VALUES LESS THAN(TO_DAYS('2011-01-15')),
PARTITION p242 VALUES LESS THAN(TO_DAYS('2011-02-01')),
PARTITION p243 VALUES LESS THAN(TO_DAYS('2011-02-15')),
PARTITION p244 VALUES LESS THAN(TO_DAYS('2011-03-01')),
PARTITION p245 VALUES LESS THAN(TO_DAYS('2011-03-15')),
PARTITION p246 VALUES LESS THAN(TO_DAYS('2011-04-01')),
PARTITION p247 VALUES LESS THAN(TO_DAYS('2011-04-15')),
PARTITION p248 VALUES LESS THAN(TO_DAYS('2011-05-01')),
PARTITION p249 VALUES LESS THAN(TO_DAYS('2011-05-15')),
PARTITION p250 VALUES LESS THAN(TO_DAYS('2011-06-01')),
PARTITION p251 VALUES LESS THAN(TO_DAYS('2011-06-15')),
PARTITION p252 VALUES LESS THAN(TO_DAYS('2011-07-01')),
PARTITION p253 VALUES LESS THAN(TO_DAYS('2011-07-15')),
PARTITION p254 VALUES LESS THAN(TO_DAYS('2011-08-01')),
PARTITION p255 VALUES LESS THAN(TO_DAYS('2011-08-15')),
PARTITION p256 VALUES LESS THAN(TO_DAYS('2011-09-01')),
PARTITION p257 VALUES LESS THAN(TO_DAYS('2011-09-15')),
PARTITION p258 VALUES LESS THAN(TO_DAYS('2011-10-01')),
PARTITION p259 VALUES LESS THAN(TO_DAYS('2011-10-15')),
PARTITION p260 VALUES LESS THAN(TO_DAYS('2011-11-01')),
PARTITION p261 VALUES LESS THAN(TO_DAYS('2011-11-15')),
PARTITION p262 VALUES LESS THAN(TO_DAYS('2011-12-01')),
PARTITION p263 VALUES LESS THAN(TO_DAYS('2011-12-15')),
PARTITION p264 VALUES LESS THAN(TO_DAYS('2012-01-01')),
PARTITION p265 VALUES LESS THAN(TO_DAYS('2012-01-15')),
PARTITION p266 VALUES LESS THAN(TO_DAYS('2012-02-01')),
PARTITION p267 VALUES LESS THAN(TO_DAYS('2012-02-15')),
PARTITION p268 VALUES LESS THAN(TO_DAYS('2012-03-01')),
PARTITION p269 VALUES LESS THAN(TO_DAYS('2012-03-15')),
PARTITION p270 VALUES LESS THAN(TO_DAYS('2012-04-01')),
PARTITION p271 VALUES LESS THAN(TO_DAYS('2012-04-15')),
PARTITION p272 VALUES LESS THAN(TO_DAYS('2012-05-01')),
PARTITION p273 VALUES LESS THAN(TO_DAYS('2012-05-15')),
PARTITION p274 VALUES LESS THAN(TO_DAYS('2012-06-01')),
PARTITION p275 VALUES LESS THAN(TO_DAYS('2012-06-15')),
PARTITION p276 VALUES LESS THAN(TO_DAYS('2012-07-01')),
PARTITION p277 VALUES LESS THAN(TO_DAYS('2012-07-15')),
PARTITION p278 VALUES LESS THAN(TO_DAYS('2012-08-01')),
PARTITION p279 VALUES LESS THAN(TO_DAYS('2012-08-15')),
PARTITION p280 VALUES LESS THAN(TO_DAYS('2012-09-01')),
PARTITION p281 VALUES LESS THAN(TO_DAYS('2012-09-15')),
PARTITION p282 VALUES LESS THAN(TO_DAYS('2012-10-01')),
PARTITION p283 VALUES LESS THAN(TO_DAYS('2012-10-15')),
PARTITION p284 VALUES LESS THAN(TO_DAYS('2012-11-01')),
PARTITION p285 VALUES LESS THAN(TO_DAYS('2012-11-15')),
PARTITION p286 VALUES LESS THAN(TO_DAYS('2012-12-01')),
PARTITION p287 VALUES LESS THAN(TO_DAYS('2012-12-15')),
PARTITION p288 VALUES LESS THAN(TO_DAYS('2013-01-01')),
PARTITION p289 VALUES LESS THAN(TO_DAYS('2013-01-15')),
PARTITION p290 VALUES LESS THAN(TO_DAYS('2013-02-01')),
PARTITION p291 VALUES LESS THAN(TO_DAYS('2013-02-15')),
PARTITION p292 VALUES LESS THAN(TO_DAYS('2013-03-01')),
PARTITION p293 VALUES LESS THAN(TO_DAYS('2013-03-15')),
PARTITION p294 VALUES LESS THAN(TO_DAYS('2013-04-01')),
PARTITION p295 VALUES LESS THAN(TO_DAYS('2013-04-15')),
PARTITION p296 VALUES LESS THAN(TO_DAYS('2013-05-01')),
PARTITION p297 VALUES LESS THAN(TO_DAYS('2013-05-15')),
PARTITION p298 VALUES LESS THAN(TO_DAYS('2013-06-01')),
PARTITION p299 VALUES LESS THAN(TO_DAYS('2013-06-15')),
PARTITION p300 VALUES LESS THAN(TO_DAYS('2013-07-01')),
PARTITION p301 VALUES LESS THAN(TO_DAYS('2013-07-15')),
PARTITION p302 VALUES LESS THAN(TO_DAYS('2013-08-01')),
PARTITION p303 VALUES LESS THAN(TO_DAYS('2013-08-15')),
PARTITION p304 VALUES LESS THAN(TO_DAYS('2013-09-01')),
PARTITION p305 VALUES LESS THAN(TO_DAYS('2013-09-15')),
PARTITION p306 VALUES LESS THAN(TO_DAYS('2013-10-01')),
PARTITION p307 VALUES LESS THAN(TO_DAYS('2013-10-15')),
PARTITION p308 VALUES LESS THAN(TO_DAYS('2013-11-01')),
PARTITION p309 VALUES LESS THAN(TO_DAYS('2013-11-15')),
PARTITION p310 VALUES LESS THAN(TO_DAYS('2013-12-01')),
PARTITION p311 VALUES LESS THAN(TO_DAYS('2013-12-15')),
PARTITION p312 VALUES LESS THAN(TO_DAYS('2014-01-01')),
PARTITION p313 VALUES LESS THAN(TO_DAYS('2014-01-15')),
PARTITION p314 VALUES LESS THAN(TO_DAYS('2014-02-01')),
PARTITION p315 VALUES LESS THAN(TO_DAYS('2014-02-15')),
PARTITION p316 VALUES LESS THAN(TO_DAYS('2014-03-01')),
PARTITION p317 VALUES LESS THAN(TO_DAYS('2014-03-15')),
PARTITION p318 VALUES LESS THAN(TO_DAYS('2014-04-01')),
PARTITION p319 VALUES LESS THAN(TO_DAYS('2014-04-15')),
PARTITION p320 VALUES LESS THAN(TO_DAYS('2014-05-01')),
PARTITION p321 VALUES LESS THAN(TO_DAYS('2014-05-15')),
PARTITION p322 VALUES LESS THAN(TO_DAYS('2014-06-01')),
PARTITION p323 VALUES LESS THAN(TO_DAYS('2014-06-15')),
PARTITION p324 VALUES LESS THAN(TO_DAYS('2014-07-01')),
PARTITION p325 VALUES LESS THAN(TO_DAYS('2014-07-15')),
PARTITION p326 VALUES LESS THAN(TO_DAYS('2014-08-01')),
PARTITION p327 VALUES LESS THAN(TO_DAYS('2014-08-15')),
PARTITION p328 VALUES LESS THAN(TO_DAYS('2014-09-01')),
PARTITION p329 VALUES LESS THAN(TO_DAYS('2014-09-15')),
PARTITION p330 VALUES LESS THAN(TO_DAYS('2014-10-01')),
PARTITION p331 VALUES LESS THAN(TO_DAYS('2014-10-15')),
PARTITION p332 VALUES LESS THAN(TO_DAYS('2014-11-01')),
PARTITION p333 VALUES LESS THAN(TO_DAYS('2014-11-15')),
PARTITION p334 VALUES LESS THAN(TO_DAYS('2014-12-01')),
PARTITION p335 VALUES LESS THAN(TO_DAYS('2014-12-15')),
PARTITION p336 VALUES LESS THAN(TO_DAYS('2015-01-01')),
PARTITION p337 VALUES LESS THAN(TO_DAYS('2015-01-15')),
PARTITION p338 VALUES LESS THAN(TO_DAYS('2015-02-01')),
PARTITION p339 VALUES LESS THAN(TO_DAYS('2015-02-15')),
PARTITION p340 VALUES LESS THAN(TO_DAYS('2015-03-01')),
PARTITION p341 VALUES LESS THAN(TO_DAYS('2015-03-15')),
PARTITION p342 VALUES LESS THAN(TO_DAYS('2015-04-01')),
PARTITION p343 VALUES LESS THAN(TO_DAYS('2015-04-15')),
PARTITION p344 VALUES LESS THAN(TO_DAYS('2015-05-01')),
PARTITION p345 VALUES LESS THAN(TO_DAYS('2015-05-15')),
PARTITION p346 VALUES LESS THAN(TO_DAYS('2015-06-01')),
PARTITION p347 VALUES LESS THAN(TO_DAYS('2015-06-15')),
PARTITION p348 VALUES LESS THAN(TO_DAYS('2015-07-01')),
PARTITION p349 VALUES LESS THAN(TO_DAYS('2015-07-15')),
PARTITION p350 VALUES LESS THAN(TO_DAYS('2015-08-01')),
PARTITION p351 VALUES LESS THAN(TO_DAYS('2015-08-15')),
PARTITION p352 VALUES LESS THAN(TO_DAYS('2015-09-01')),
PARTITION p353 VALUES LESS THAN(TO_DAYS('2015-09-15')),
PARTITION p354 VALUES LESS THAN(TO_DAYS('2015-10-01')),
PARTITION p355 VALUES LESS THAN(TO_DAYS('2015-10-15')),
PARTITION p356 VALUES LESS THAN(TO_DAYS('2015-11-01')),
PARTITION p357 VALUES LESS THAN(TO_DAYS('2015-11-15')),
PARTITION p358 VALUES LESS THAN(TO_DAYS('2015-12-01')),
PARTITION p359 VALUES LESS THAN(TO_DAYS('2015-12-15')),
PARTITION p360 VALUES LESS THAN(TO_DAYS('2016-01-01')),
PARTITION p361 VALUES LESS THAN(TO_DAYS('2016-01-15')),
PARTITION p362 VALUES LESS THAN(TO_DAYS('2016-02-01')),
PARTITION p363 VALUES LESS THAN(TO_DAYS('2016-02-15')),
PARTITION p364 VALUES LESS THAN(TO_DAYS('2016-03-01')),
PARTITION p365 VALUES LESS THAN(TO_DAYS('2016-03-15')),
PARTITION p366 VALUES LESS THAN(TO_DAYS('2016-04-01')),
PARTITION p367 VALUES LESS THAN(TO_DAYS('2016-04-15')),
PARTITION p368 VALUES LESS THAN(TO_DAYS('2016-05-01')),
PARTITION p369 VALUES LESS THAN(TO_DAYS('2016-05-15')),
PARTITION p370 VALUES LESS THAN(TO_DAYS('2016-06-01')),
PARTITION p371 VALUES LESS THAN(TO_DAYS('2016-06-15')),
PARTITION p372 VALUES LESS THAN(TO_DAYS('2016-07-01')),
PARTITION p373 VALUES LESS THAN(TO_DAYS('2016-07-15')),
PARTITION p374 VALUES LESS THAN(TO_DAYS('2016-08-01')),
PARTITION p375 VALUES LESS THAN(TO_DAYS('2016-08-15')),
PARTITION p376 VALUES LESS THAN(TO_DAYS('2016-09-01')),
PARTITION p377 VALUES LESS THAN(TO_DAYS('2016-09-15')),
PARTITION p378 VALUES LESS THAN(TO_DAYS('2016-10-01')),
PARTITION p379 VALUES LESS THAN(TO_DAYS('2016-10-15')),
PARTITION p380 VALUES LESS THAN(TO_DAYS('2016-11-01')),
PARTITION p381 VALUES LESS THAN(TO_DAYS('2016-11-15')),
PARTITION p382 VALUES LESS THAN(TO_DAYS('2016-12-01')),
PARTITION p383 VALUES LESS THAN(TO_DAYS('2016-12-15')),
PARTITION p384 VALUES LESS THAN(TO_DAYS('2017-01-01')),
PARTITION p385 VALUES LESS THAN(TO_DAYS('2017-01-15')),
PARTITION p386 VALUES LESS THAN(TO_DAYS('2017-02-01')),
PARTITION p387 VALUES LESS THAN(TO_DAYS('2017-02-15')),
PARTITION p388 VALUES LESS THAN(TO_DAYS('2017-03-01')),
PARTITION p389 VALUES LESS THAN(TO_DAYS('2017-03-15')),
PARTITION p390 VALUES LESS THAN(TO_DAYS('2017-04-01')),
PARTITION p391 VALUES LESS THAN(TO_DAYS('2017-04-15')),
PARTITION p392 VALUES LESS THAN(TO_DAYS('2017-05-01')),
PARTITION p393 VALUES LESS THAN(TO_DAYS('2017-05-15')),
PARTITION p394 VALUES LESS THAN(TO_DAYS('2017-06-01')),
PARTITION p395 VALUES LESS THAN(TO_DAYS('2017-06-15')),
PARTITION p396 VALUES LESS THAN(TO_DAYS('2017-07-01')),
PARTITION p397 VALUES LESS THAN(TO_DAYS('2017-07-15')),
PARTITION p398 VALUES LESS THAN(TO_DAYS('2017-08-01')),
PARTITION p399 VALUES LESS THAN(TO_DAYS('2017-08-15')),
PARTITION p400 VALUES LESS THAN(TO_DAYS('2017-09-01')),
PARTITION p401 VALUES LESS THAN(TO_DAYS('2017-09-15')),
PARTITION p402 VALUES LESS THAN(TO_DAYS('2017-10-01')),
PARTITION p403 VALUES LESS THAN(TO_DAYS('2017-10-15')),
PARTITION p404 VALUES LESS THAN(TO_DAYS('2017-11-01')),
PARTITION p405 VALUES LESS THAN(TO_DAYS('2017-11-15')),
PARTITION p406 VALUES LESS THAN(TO_DAYS('2017-12-01')),
PARTITION p407 VALUES LESS THAN(TO_DAYS('2017-12-15')),
PARTITION p408 VALUES LESS THAN(TO_DAYS('2018-01-01')),
PARTITION p409 VALUES LESS THAN(TO_DAYS('2018-01-15')),
PARTITION p410 VALUES LESS THAN(TO_DAYS('2018-02-01')),
PARTITION p411 VALUES LESS THAN(TO_DAYS('2018-02-15')),
PARTITION p412 VALUES LESS THAN(TO_DAYS('2018-03-01')),
PARTITION p413 VALUES LESS THAN(TO_DAYS('2018-03-15')),
PARTITION p414 VALUES LESS THAN(TO_DAYS('2018-04-01')),
PARTITION p415 VALUES LESS THAN(TO_DAYS('2018-04-15')),
PARTITION p416 VALUES LESS THAN(TO_DAYS('2018-05-01')),
PARTITION p417 VALUES LESS THAN(TO_DAYS('2018-05-15')),
PARTITION p418 VALUES LESS THAN(TO_DAYS('2018-06-01')),
PARTITION p419 VALUES LESS THAN(TO_DAYS('2018-06-15')),
PARTITION p420 VALUES LESS THAN(TO_DAYS('2018-07-01')),
PARTITION p421 VALUES LESS THAN(TO_DAYS('2018-07-15')),
PARTITION p422 VALUES LESS THAN(TO_DAYS('2018-08-01')),
PARTITION p423 VALUES LESS THAN(TO_DAYS('2018-08-15')),
PARTITION p424 VALUES LESS THAN(TO_DAYS('2018-09-01')),
PARTITION p425 VALUES LESS THAN(TO_DAYS('2018-09-15')),
PARTITION p426 VALUES LESS THAN(TO_DAYS('2018-10-01')),
PARTITION p427 VALUES LESS THAN(TO_DAYS('2018-10-15')),
PARTITION p428 VALUES LESS THAN(TO_DAYS('2018-11-01')),
PARTITION p429 VALUES LESS THAN(TO_DAYS('2018-11-15')),
PARTITION p430 VALUES LESS THAN(TO_DAYS('2018-12-01')),
PARTITION p431 VALUES LESS THAN(TO_DAYS('2018-12-15')),
PARTITION p432 VALUES LESS THAN(TO_DAYS('2019-01-01')),
PARTITION p433 VALUES LESS THAN(TO_DAYS('2019-01-15')),
PARTITION p434 VALUES LESS THAN(TO_DAYS('2019-02-01')),
PARTITION p435 VALUES LESS THAN(TO_DAYS('2019-02-15')),
PARTITION p436 VALUES LESS THAN(TO_DAYS('2019-03-01')),
PARTITION p437 VALUES LESS THAN(TO_DAYS('2019-03-15')),
PARTITION p438 VALUES LESS THAN(TO_DAYS('2019-04-01')),
PARTITION p439 VALUES LESS THAN(TO_DAYS('2019-04-15')),
PARTITION p440 VALUES LESS THAN(TO_DAYS('2019-05-01')),
PARTITION p441 VALUES LESS THAN(TO_DAYS('2019-05-15')),
PARTITION p442 VALUES LESS THAN(TO_DAYS('2019-06-01')),
PARTITION p443 VALUES LESS THAN(TO_DAYS('2019-06-15')),
PARTITION p444 VALUES LESS THAN(TO_DAYS('2019-07-01')),
PARTITION p445 VALUES LESS THAN(TO_DAYS('2019-07-15')),
PARTITION p446 VALUES LESS THAN(TO_DAYS('2019-08-01')),
PARTITION p447 VALUES LESS THAN(TO_DAYS('2019-08-15')),
PARTITION p448 VALUES LESS THAN(TO_DAYS('2019-09-01')),
PARTITION p449 VALUES LESS THAN(TO_DAYS('2019-09-15')),
PARTITION p450 VALUES LESS THAN(TO_DAYS('2019-10-01')),
PARTITION p451 VALUES LESS THAN(TO_DAYS('2019-10-15')),
PARTITION p452 VALUES LESS THAN(TO_DAYS('2019-11-01')),
PARTITION p453 VALUES LESS THAN(TO_DAYS('2019-11-15')),
PARTITION p454 VALUES LESS THAN(TO_DAYS('2019-12-01')),
PARTITION p455 VALUES LESS THAN(TO_DAYS('2019-12-15')),
PARTITION p456 VALUES LESS THAN(TO_DAYS('2020-01-01')),
PARTITION p457 VALUES LESS THAN(TO_DAYS('2020-01-15')),
PARTITION p458 VALUES LESS THAN(TO_DAYS('2020-02-01')),
PARTITION p459 VALUES LESS THAN(TO_DAYS('2020-02-15')),
PARTITION p460 VALUES LESS THAN(TO_DAYS('2020-03-01')),
PARTITION p461 VALUES LESS THAN(TO_DAYS('2020-03-15')),
PARTITION p462 VALUES LESS THAN(TO_DAYS('2020-04-01')),
PARTITION p463 VALUES LESS THAN(TO_DAYS('2020-04-15')),
PARTITION p464 VALUES LESS THAN(TO_DAYS('2020-05-01')),
PARTITION p465 VALUES LESS THAN(TO_DAYS('2020-05-15')),
PARTITION p466 VALUES LESS THAN(TO_DAYS('2020-06-01')),
PARTITION p467 VALUES LESS THAN(TO_DAYS('2020-06-15')),
PARTITION p468 VALUES LESS THAN(TO_DAYS('2020-07-01')),
PARTITION p469 VALUES LESS THAN(TO_DAYS('2020-07-15')),
PARTITION p470 VALUES LESS THAN(TO_DAYS('2020-08-01')),
PARTITION p471 VALUES LESS THAN(TO_DAYS('2020-08-15')),
PARTITION p472 VALUES LESS THAN(TO_DAYS('2020-09-01')),
PARTITION p473 VALUES LESS THAN(TO_DAYS('2020-09-15')),
PARTITION p474 VALUES LESS THAN(TO_DAYS('2020-10-01')),
PARTITION p475 VALUES LESS THAN(TO_DAYS('2020-10-15')),
PARTITION p476 VALUES LESS THAN(TO_DAYS('2020-11-01')),
PARTITION p477 VALUES LESS THAN(TO_DAYS('2020-11-15')),
PARTITION p478 VALUES LESS THAN(TO_DAYS('2020-12-01')),
PARTITION p479 VALUES LESS THAN(TO_DAYS('2020-12-15')),
PARTITION p480 VALUES LESS THAN(TO_DAYS('2021-01-01')),
PARTITION p481 VALUES LESS THAN(TO_DAYS('2021-01-15')),
PARTITION p482 VALUES LESS THAN(TO_DAYS('2021-02-01')),
PARTITION p483 VALUES LESS THAN(TO_DAYS('2021-02-15')),
PARTITION p484 VALUES LESS THAN(TO_DAYS('2021-03-01')),
PARTITION p485 VALUES LESS THAN(TO_DAYS('2021-03-15')),
PARTITION p486 VALUES LESS THAN(TO_DAYS('2021-04-01')),
PARTITION p487 VALUES LESS THAN(TO_DAYS('2021-04-15')),
PARTITION p488 VALUES LESS THAN(TO_DAYS('2021-05-01')),
PARTITION p489 VALUES LESS THAN(TO_DAYS('2021-05-15')),
PARTITION p490 VALUES LESS THAN(TO_DAYS('2021-06-01')),
PARTITION p491 VALUES LESS THAN(TO_DAYS('2021-06-15')),
PARTITION p492 VALUES LESS THAN(TO_DAYS('2021-07-01')),
PARTITION p493 VALUES LESS THAN(TO_DAYS('2021-07-15')),
PARTITION p494 VALUES LESS THAN(TO_DAYS('2021-08-01')),
PARTITION p495 VALUES LESS THAN(TO_DAYS('2021-08-15')),
PARTITION p496 VALUES LESS THAN(TO_DAYS('2021-09-01')),
PARTITION p497 VALUES LESS THAN(TO_DAYS('2021-09-15')),
PARTITION p498 VALUES LESS THAN(TO_DAYS('2021-10-01')),
PARTITION p499 VALUES LESS THAN(TO_DAYS('2021-10-15')),
PARTITION p500 VALUES LESS THAN(TO_DAYS('2021-11-01')),
PARTITION p501 VALUES LESS THAN(TO_DAYS('2021-11-15')),
PARTITION p502 VALUES LESS THAN(TO_DAYS('2021-12-01')),
PARTITION p503 VALUES LESS THAN(TO_DAYS('2021-12-15')),
PARTITION p504 VALUES LESS THAN(TO_DAYS('2022-01-01')),
PARTITION p505 VALUES LESS THAN(TO_DAYS('2022-01-15')),
PARTITION p506 VALUES LESS THAN(TO_DAYS('2022-02-01')),
PARTITION p507 VALUES LESS THAN(TO_DAYS('2022-02-15')),
PARTITION p508 VALUES LESS THAN(TO_DAYS('2022-03-01')),
PARTITION p509 VALUES LESS THAN(TO_DAYS('2022-03-15')),
PARTITION p510 VALUES LESS THAN(TO_DAYS('2022-04-01')),
PARTITION p511 VALUES LESS THAN(TO_DAYS('2022-04-15')),
PARTITION p512 VALUES LESS THAN(TO_DAYS('2022-05-01')),
PARTITION p513 VALUES LESS THAN(TO_DAYS('2022-05-15')),
PARTITION p514 VALUES LESS THAN(TO_DAYS('2022-06-01')),
PARTITION p515 VALUES LESS THAN(TO_DAYS('2022-06-15')),
PARTITION p516 VALUES LESS THAN(TO_DAYS('2022-07-01')),
PARTITION p517 VALUES LESS THAN(TO_DAYS('2022-07-15')),
PARTITION p518 VALUES LESS THAN(TO_DAYS('2022-08-01')),
PARTITION p519 VALUES LESS THAN(TO_DAYS('2022-08-15')),
PARTITION p520 VALUES LESS THAN(TO_DAYS('2022-09-01')),
PARTITION p521 VALUES LESS THAN(TO_DAYS('2022-09-15')),
PARTITION p522 VALUES LESS THAN(TO_DAYS('2022-10-01')),
PARTITION p523 VALUES LESS THAN(TO_DAYS('2022-10-15')),
PARTITION p524 VALUES LESS THAN(TO_DAYS('2022-11-01')),
PARTITION p525 VALUES LESS THAN(TO_DAYS('2022-11-15')),
PARTITION p526 VALUES LESS THAN(TO_DAYS('2022-12-01')),
PARTITION p527 VALUES LESS THAN(TO_DAYS('2022-12-15')),
PARTITION p528 VALUES LESS THAN(TO_DAYS('2023-01-01')),
PARTITION p529 VALUES LESS THAN(TO_DAYS('2023-01-15')),
PARTITION p530 VALUES LESS THAN(TO_DAYS('2023-02-01')),
PARTITION p531 VALUES LESS THAN(TO_DAYS('2023-02-15')),
PARTITION p532 VALUES LESS THAN(TO_DAYS('2023-03-01')),
PARTITION p533 VALUES LESS THAN(TO_DAYS('2023-03-15')),
PARTITION p534 VALUES LESS THAN(TO_DAYS('2023-04-01')),
PARTITION p535 VALUES LESS THAN(TO_DAYS('2023-04-15')),
PARTITION p536 VALUES LESS THAN(TO_DAYS('2023-05-01')),
PARTITION p537 VALUES LESS THAN(TO_DAYS('2023-05-15')),
PARTITION p538 VALUES LESS THAN(TO_DAYS('2023-06-01')),
PARTITION p539 VALUES LESS THAN(TO_DAYS('2023-06-15')),
PARTITION p540 VALUES LESS THAN(TO_DAYS('2023-07-01')),
PARTITION p541 VALUES LESS THAN(TO_DAYS('2023-07-15')),
PARTITION p542 VALUES LESS THAN(TO_DAYS('2023-08-01')),
PARTITION p543 VALUES LESS THAN(TO_DAYS('2023-08-15')),
PARTITION p544 VALUES LESS THAN(TO_DAYS('2023-09-01')),
PARTITION p545 VALUES LESS THAN(TO_DAYS('2023-09-15')),
PARTITION p546 VALUES LESS THAN(TO_DAYS('2023-10-01')),
PARTITION p547 VALUES LESS THAN(TO_DAYS('2023-10-15')),
PARTITION p548 VALUES LESS THAN(TO_DAYS('2023-11-01')),
PARTITION p549 VALUES LESS THAN(TO_DAYS('2023-11-15')),
PARTITION p550 VALUES LESS THAN(TO_DAYS('2023-12-01')),
PARTITION p551 VALUES LESS THAN(TO_DAYS('2023-12-15')),
PARTITION feature VALUES LESS THAN (MAXVALUE)
);
为了为了后续因为数据增加后还要额外增加手动分区，前期多加了一些分区， 自动生成分区的sql代码
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.util.Date;
public class test26 {
public static void main(String[] args) throws ParseException {
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM");
String startDate = "2001-01";//当前日期+1的月份开始
int addMonths = 540;//需要建几个月的索引
for (int i = 0; i < addMonths; i++) {
//Thread.sleep(10000);
Date dt = sdf.parse(startDate);
Calendar rightNow = Calendar.getInstance();
rightNow.setTime(dt);
if (i != 0) {
rightNow.add(Calendar.MONTH, 1);//日期加1个月
}
Date dt1 = rightNow.getTime();
String reStr = sdf.format(dt1);
System.out.println("PARTITION p"+i+" VALUES LESS THAN(TO_DAYS('"+reStr+"-01')),");
i=++i;
System.out.println("PARTITION p"+i+" VALUES LESS THAN(TO_DAYS('"+reStr+"-15')),");
startDate = reStr;
}
}
}
衍生扩展： 如果想分区拆分语法
##增加分区的方案（如果不删除指定分区的话，对已有分区进行拆分）：
ALTER TABLE yx_test_patition2 reorganize partition feature into (
partition pt7 values less than ('2023-01-01'),
partition pt8 values less than maxvalue
)
最后分区详情查询
SELECT PARTITION_NAME,TABLE_ROWS
FROM INFORMATION_SCHEMA.PARTITIONS
WHERE TABLE_NAME = 'yx_test';
另外补充下，因为实际业务查询的复杂性，有时候某个查询并一定只会用到指定分区的那个时间字段，甚至没用到这个时间字段，还是需要再额外加一个索引，来确保性能的提升，如果实在找不到一个固定通用的时间字段来提升查询性能的话，那真的要考虑抛弃mysql，使用clickHouse这种 高性能查询数据存储工具了。
