删除最早分区组合sql

I am 006!

于 2020-12-15 10:08:52 发布

阅读量91

点赞数

CC 4.0 BY-SA版权

分类专栏：故障定位 Linux

本文链接：https://blog.youkuaiyun.com/wangzhicheng1983/article/details/111192257

Linux 同时被 2 个专栏收录

383 篇文章

订阅专栏

故障定位

111 篇文章

订阅专栏

#查询某表所有分区数
SELECT count(*) FROM INFORMATION_SCHEMA.PARTITIONS WHERE TABLE_SCHEMA = wdd and partition_name is not null and table_name = wdd_flow_osi
#只查一条分区名
SELECT partition_name FROM INFORMATION_SCHEMA.PARTITIONS WHERE TABLE_SCHEMA = wdd and partition_name is not null and table_name = wdd_flow_osi and partition_name != 'p19700101' order by partition_name limit 1
#删除分区
ALERT TABLE wdd_flow_osi DROP partition p20190101