select * from information_schema.PARTITIONS where TABLE_SCHEMA not in ('performance_schema','mysql') and SUBPARTITION_EXPRESSION is not null group by table_name
查询分区表的语句
最新推荐文章于 2024-01-05 20:16:39 发布
select * from information_schema.PARTITIONS where TABLE_SCHEMA not in ('performance_schema','mysql') and SUBPARTITION_EXPRESSION is not null group by table_name