create partition in mysql on existing table code example Example: add partition mysql ALTER TABLE t1 ADD PARTITION (PARTITION p3 VALUES LESS THAN (2002));