By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| Table | Create Table |
|---|---|
| test | CREATE TABLE `test` ( `id` int NOT NULL, `created_at` date NOT NULL DEFAULT '1970-01-01', `partitioning_value` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci /*!50100 PARTITION BY HASH (`partitioning_value`) PARTITIONS 4 */ |
| TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | PARTITION_NAME | SUBPARTITION_NAME | PARTITION_ORDINAL_POSITION | SUBPARTITION_ORDINAL_POSITION | PARTITION_METHOD | SUBPARTITION_METHOD | PARTITION_EXPRESSION | SUBPARTITION_EXPRESSION | PARTITION_DESCRIPTION | TABLE_ROWS | AVG_ROW_LENGTH | DATA_LENGTH | MAX_DATA_LENGTH | INDEX_LENGTH | DATA_FREE | CREATE_TIME | UPDATE_TIME | CHECK_TIME | CHECKSUM | PARTITION_COMMENT | NODEGROUP | TABLESPACE_NAME |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| def | fiddle | test | p0 | null | 1 | null | HASH | null | `partitioning_value` | null | null | 0 | 0 | 16384 | 0 | 0 | 0 | 2023-03-27 07:37:48 | null | null | null | default | null | |
| def | fiddle | test | p1 | null | 2 | null | HASH | null | `partitioning_value` | null | null | 0 | 0 | 16384 | 0 | 0 | 0 | 2023-03-27 07:37:48 | null | null | null | default | null | |
| def | fiddle | test | p2 | null | 3 | null | HASH | null | `partitioning_value` | null | null | 0 | 0 | 16384 | 0 | 0 | 0 | 2023-03-27 07:37:48 | null | null | null | default | null | |
| def | fiddle | test | p3 | null | 4 | null | HASH | null | `partitioning_value` | null | null | 0 | 0 | 16384 | 0 | 0 | 0 | 2023-03-27 07:37:48 | null | null | null | default | null |
Records: 10 Duplicates: 0 Warnings: 0
| id | created_at | partitioning_value | partition_name |
|---|---|---|---|
| -4 | 1970-01-01 | -4 | p0 |
| -3 | 1970-01-01 | -3 | p3 |
| -2 | 1970-01-01 | -2 | p2 |
| -1 | 1970-01-01 | -1 | p1 |
| 0 | 1970-01-01 | 0 | p0 |
| 1 | 1970-01-01 | 1 | p1 |
| 2 | 1970-01-01 | 2 | p2 |
| 3 | 1970-01-01 | 3 | p3 |
| 4 | 1970-01-01 | 4 | p0 |
| 5 | 1970-01-01 | 5 | p1 |