LIST分区
日分区
ALTER TABLE ZYC.STUDENT ADD PARTITION (PARTITION P20220808 VALUES IN (20220808));
删除分区数据
ALTER TABLE ZYC.STUDENT TRUNCATE PARTITION P20220808;
月分区
ALTER TABLE ZYC.STUDENT ADD PARTITION (PARTITION P202208 VALUES IN (202208));
删除分区数据
ALTER TABLE ZYC.STUDENT TRUNCATE PARTITION P202208;
RANGE分区
日分区
ALTER TABLE ZYC.STUDENT ADD PARTITION (PARTITION P20220705 VALUES LESS THAN (20220706));
删除分区数据
ALTER TABLE ZYC.STUDENT TRUNCATE PARTITION P20220705;
月分区
ALTER TABLE ZYC.STUDENT ADD PARTITION (PARTITION P202207 VALUES LESS THAN (202208));
删除分区数据
ALTER TABLE ZYC.STUDENT TRUNCATE PARTITION P202207 ;