删除最早分区组合sql

#查询某表所有分区数
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