alter table drop partition mysql code example Example: add partition mysql ALTER TABLE t1 ADD PARTITION (PARTITION p3 VALUES LESS THAN (2002));