MySQL分区表EXCHANGE PARTITION

--分区表的分区交换到普通非分区表，不搬数据，只修改数据字典元数据，瞬间完成
ALTER TABLE android_device_data EXCHANGE PARTITION p20211223 WITH TABLE android_device_data_np;

--普通非分区表交换到分区表的分区
mysql> ALTER TABLE android_device_data EXCHANGE PARTITION p20211223 WITH TABLE android_device_data_np WITH VALIDATION;
Query OK, 0 rows affected (1 min 44.03 sec)

mysql> ALTER TABLE android_device_data EXCHANGE PARTITION p20211223 WITH TABLE android_device_data_np WITHOUT VALIDATION;
Query OK, 0 rows affected (0.01 sec)

mysql>

MySQL分区表与普通表交换分区，和oracle一样，只是修改数据字典，不搬数据，所以基本不耗时