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. When creating a partitioned table or index, you include a partitioning clause in the CREATE TABLE statement. This chapter describes various aspects of creating and maintaining partitioned tables and indexes, and contains the following topics.