ALTER TABLE Statement restore on the same instance. Both options take a comma-separated list of one or more partition names. For example: When running  DISCARD PARTITION ... TABLESPACE  and  IMPORT PARTITION ... TABLESPACE  on subpartitioned tables, both partition and subpartition names are allowed. When a partition name is specified, subpartitions of that partition are included. The Transportable Tablespace feature also supports copying or restoring partitioned  InnoDB  tables. For more information, see Section 15.6.1.3, “Importing InnoDB Tables” . Renames of partitioned tables are supported. You can rename individual partitions indirectly using ALTER TABLE ... REORGANIZE PARTITION ; however, this operation copies the partition’s data. To delete rows from selected partitions, use the  TRUNCATE PARTITION  option. This option takes a list of one or more comma-separated partition names. Consider the table  t1  created by this statement: To delete all rows from partition  p0 , use the following statement: The statement just shown has the same effect as the following  DELETE  statement: When truncating multiple partitions, the partitions do not have to be contiguous: This can greatly simplify delete operations on partitioned tables that would otherwise require very complex  WHERE  conditions if done with  DELETE  statements. For example, this statement deletes all rows from partitions  p1  and  p3 : An equivalent  DELETE  statement is shown here: If you use the  ALL  keyword in place of the list of partition names, the statement acts on all table partitions. TRUNCATE PARTITION  merely deletes rows; it does not alter the definition of the table itself, or of any of its partitions. To verify that the rows were dropped, check the  INFORMATION_SCHEMA.PARTITIONS  table, using a query such as this one: 2499 DELETE FROM t1 WHERE (year_col >= 1991 AND year_col < 1995) OR (year_col >= 2003 AND year_col < 2007); ALTER TABLE t1 TRUNCATE PARTITION p1, p3; DELETE FROM t1 WHERE year_col < 1991; ALTER TABLE t1 TRUNCATE PARTITION p0; CREATE TABLE t1 ( id INT, year_col INT ) PARTITION BY RANGE (year_col) ( PARTITION p0 VALUES LESS THAN (1991), PARTITION p1 VALUES LESS THAN (1995), PARTITION p2 VALUES LESS THAN (1999), PARTITION p3 VALUES LESS THAN (2003), PARTITION p4 VALUES LESS THAN (2007) ); ALTER TABLE t1 DISCARD PARTITION p2, p3 TABLESPACE; ALTER TABLE t1 IMPORT PARTITION p2, p3 TABLESPACE;