Mysql 5.5+ 分区操作

查询表分区信息：

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'))
);