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.You can specify up to a total of 1024K-1 partitions for a single-level partitioned tables, or subpartitions for a composite partitioned table. This article presents a simple method for partitioning an existing table using the EXCHANGE PARTITION syntax. This publication is an announcement of the current programs and course offerings of International Technological University. It is intended for information.