MySQL 8.0

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