分区查看、添加、删除
show range partitions XXX.XXX_t
ALTER TABLE XXX.XXX_t ADD RANGE PARTITION 20191001000000 <= VALUES < 20191101000000;
alter TABLE XXX.XXX_t drop range PARTITION 20180601000000 <= VALUES < 20180701000000;
分区查看、添加、删除
show range partitions XXX.XXX_t
ALTER TABLE XXX.XXX_t ADD RANGE PARTITION 20191001000000 <= VALUES < 20191101000000;
alter TABLE XXX.XXX_t drop range PARTITION 20180601000000 <= VALUES < 20180701000000;