mysql 查看分区

水兽，

已于 2022-06-20 09:26:20 修改

阅读量6.7k

点赞数 4

CC 4.0 BY-SA版权

文章标签： mysql

于 2021-04-21 10:13:30 首次发布

本文链接：https://blog.youkuaiyun.com/taoCSD/article/details/115936908

#mysql查看所有分区
select partition_name part, partition_expression expr, partition_description descr, table_rows from  INFORMATION_SCHEMA.partitions  where TABLE_SCHEMA="库名" AND TABLE_NAME="表名";
PARTITION BY RANGE COLUMNS(stsdate) (PARTITION p0 VALUES LESS THAN ('2016-06-01')

#添加分区
alter table apdailysts_p add partition (partition p1 values less than ('2020-06-01'));
删除分区
alter table 表  drop partition p20220319