drop partition required OPTIMIZE TABLE code example

Example: add partition mysql

ALTER TABLE t1 ADD PARTITION (PARTITION p3 VALUES LESS THAN (2002));