MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE stackoverflow (
    id INT PRIMARY KEY,
    test VARCHAR(30)
);
CREATE TABLE stackoverflow_workinprogess LIKE stackoverflow;
ALTER TABLE stackoverflow  PARTITION BY RANGE (id) (
        PARTITION p VALUES LESS THAN (MAXVALUE)
);

Records: 0  Duplicates: 0  Warnings: 0


DESCRIBE stackoverflow 


Field
Type
Null
Key
Default
Extra


id
696e74
NO
PRI
null


test
7661726368617228333029
YES

null



DESCRIBE stackoverflow_workinprogess 


Field
Type
Null
Key
Default
Extra


id
696e74
NO
PRI
null


test
7661726368617228333029
YES

null



INSERT INTO stackoverflow VALUES
    (1, "Test 1"),
    (2, "Test 2"),
    (3, "Test 3"),
    (4, "Test 4"),
    (5, "Test 5");    

Records: 5  Duplicates: 0  Warnings: 0


select * from stackoverflow;


id
test


1
Test 1

2
Test 2

3
Test 3

4
Test 4

5
Test 5


TRUNCATE TABLE stackoverflow_workinprogess;
INSERT INTO stackoverflow_workinprogess VALUES
    (1, "Test a - new row"),
    (2, "Test b - new row"),
    (3, "Test c - new row"),
    (4, "Test d - new row"),
    (6, "Test e - new row"), -- skipping one on purpose
    (7, "Test f - new row");

Records: 6  Duplicates: 0  Warnings: 0


SELECT partition_name, table_rows, table_name
  FROM information_schema.partitions
 WHERE table_name IN ('stackoverflow','stackoverflow_workinprogess');


PARTITION_NAME
TABLE_ROWS
TABLE_NAME


null
6
stackoverflow_workinprogess

p
5
stackoverflow


ALTER TABLE stackoverflow EXCHANGE PARTITION p WITH TABLE stackoverflow_workinprogess;
select * from stackoverflow;


id
test


1
Test a - new row

2
Test b - new row

3
Test c - new row

4
Test d - new row

6
Test e - new row

7
Test f - new row

id	test
1	Test a - new row
2	Test b - new row
3	Test c - new row
4	Test d - new row
6	Test e - new row
7	Test f - new row