By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE test (
id INT NOT NULL,
sid INT NOT NULL
)
PARTITION BY RANGE (sid) (
PARTITION p0 VALUES LESS THAN (6),
PARTITION p1 VALUES LESS THAN (11),
PARTITION p2 VALUES LESS THAN (16),
PARTITION p3 VALUES LESS THAN (21),
PARTITION px VALUES LESS THAN (MAXVALUE)
);
insert into test
with recursive cte as (
select 1 num union all select num+1 from cte where num < 30 )
select num*num, num from cte;
Records: 30 Duplicates: 0 Warnings: 0
SELECT COUNT(*) FROM test;
| COUNT(*) |
|---|
| 30 |
alter table test REMOVE PARTITIONING;
Records: 30 Duplicates: 0 Warnings: 0
show create table test;
| Table | Create Table |
|---|---|
| test | CREATE TABLE `test` ( `id` int NOT NULL, `sid` int NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci |
SELECT COUNT(*) FROM test;
| COUNT(*) |
|---|
| 30 |