In MySQL 5.7, it is possible to exchange a table partition or subpartition with a table using ALTER TABLE pt EXCHANGE PARTITION p WITH TABLE nt. 1)Exchange sub partitioning ALTER TABLE DEPARTMENT EXCHANGE SUBPARTITION SYS_SUBP7356 WITH TABLE TEMP_DEPARTMENT WITHOUT VALIDATION UPDATE GLOBAL INDEXES;You CAN exchange a subpartition into another table using a "temporary" (staging) table as an intermediary. This article presents a simple method for partitioning an existing table using the EXCHANGE PARTITION syntax. Forms indicated as fillable may be filled out electronically. When creating a partitioned table or index, you include a partitioning clause in the CREATE TABLE statement. At each level in the recursion tree, partitions are divided into 2 sub-partitions until a threshold size is reached. Table-level synopses on a table, exchange the table with a partition, and end up with synopses on the partition. World rights reserved.