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. 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. Below documents will explain the steps required to Exchange partition. , software developed using this specification may claim compliance.