1、查看表分区
SELECT
partition_name part,
partition_expression expr,
partition_description descr,
FROM_DAYS(partition_description) lessthan_sendtime,
table_rows
FROM
INFORMATION_SCHEMA.partitions
WHERE
TABLE_SCHEMA = SCHEMA()
AND TABLE_NAME='el_user_category_litera'; ---这里是表名
2、添加表分区
ALTER TABLE el_user_category_litera ADD PARTITION (
PARTITION p20150210 VALUES LESS TH