查询表分区信息:
SELECT
partition_name as part,
partition_expression as expr,
partition_description as descr,
table_rows
FROM
INFORMATION_SCHEMA.partitions
WHERE
TABLE_SCHEMA = schema()
AND TABLE_NAME='table_name';
分区:
alter table table_name partition by range(to_days(create_date))
(
partition p201906 values less than (to_days('2019-06-31')),
partition p201907 values less than (to_days('2019-07-31'))
);