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.One exchange operation. Exchange (clear) out of target bottom-up. The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. Range Partitioning Maps data to partitions based on ranges of partition key values that you establish for each partition. 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.