drop partition required OPTIMIZE TABLE mysql code example

Example: add partition mysql

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