mysql 查看分区

#mysql查看所有分区select partition_name part, partition_expression expr, partition_description descr, table_rows fromINFORMATION_SCHEMA.partitionswhere TABLE_SCHEMA="库名" AND TABLE_NAME="表名";PARTITION BY RAN

滔滔不决

6489人浏览 · 2021-04-21 10:13:30

滔滔不决 · 2021-04-21 10:13:30 发布

#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