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