Nov 8, 2018

How to drop partition in MySQL

Example usage:

ALTER TABLE t1 DROP PARTITION p0, p1;

DROP PARTITION can be used to drop one or more RANGE or LIST partitions. This statement cannot be used with HASH or KEY partitions; instead, use COALESCE PARTITION. Any data that was stored in the dropped partitions named in the partition_names list is discarded.