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. You can specify up to a total of 1024K-1 partitions for a single-level partitioned tables, or subpartitions for a composite partitioned table. NOTICE TO READERS: The Board of County Commissioners' meeting packets are prepared several days prior to the meeting. This page documents production updates to BigQuery. We recommend that BigQuery developers periodically check this list for any new announcements.