注:在用字段时,需将字段设置为索引,且每个分区必须有取值
先向表中插入数据,然后执行如下语句:
select
partition_name part,
partition_expression expr,
partition_description descr,
table_rows
from information_schema.partitions where
table_schema = schema()
and table_name='表名字';