我有一个sql查询SELECT * FROM articles where `id` =1 AND `datatime` > ='datetime1';SELECT* FROM articles where `id` =2 AND `datatime` > ='datetime2';SELECT * FROM articles where`id` =3 AND `datatime` > ='datetime3
它有一个复合唯一的键Field_A +元素+ DataTime。`), KEY `ELEID` (`ELEID`),) ENGINEDataTime between [time] and [time].为了更好地管理家务,我尝试每6小时一次,根据DataTime对表进行分区。(当地时间00,06,12,18)
PARTITION BY RANGE