ALTER TABLE t_theory_lineloss_data PARTITION by range columns(f_collection_time)(
partition p20220707 values less than('2022-07-07'),
partition p20220708 values less than('2022-07-08'),
partition p20220709 values less than('2022-07-09'),
partition p20231228 values less than('2023-12-28'),
partition p20231229 values less than('2023-12-29'),
partition p20231230 values less than('2023-12-30'),
partition other values less than maxvalue
);
//查询分区信息
SELECT
PARTITION_NAME,
PARTITION_METHOD,
PARTITION_EXPRESSION,
PARTITION_DESCRIPTION,
TABLE_ROWS,
SUBPARTITION_NAME,
SUBPARTITION_METHOD,
SUBPARTITION_EXPRESSION
FROM
information_schema.PARTITIONS
WHERE
TABLE_SCHEMA = SCHEMA ()
AND TABLE_NAME = 't_theory_lineloss_data';