2024年3月13日发(作者：)

set part_name = concat('p', date_format( DATE_SUB(CURDATE(), INTERVAL 6 day),'%Y%m%d'));

set pstring_drop_part =concat('alter table ifpay__alive_report drop partition ',part_name);

select pstring_drop_part;

Execute Immediate pstring_drop_part;

end;

2、定时器

1）定时器

2）脚本

cat mysql_drop_partition_

#!/bin/bash

##############################

## drop partition

## 2018/12/25

##############################

logdir=/u01/dba_scripts/mysql_drop_partition

exec >> $logdir/drop_part_ 2>&1

startdate=`date +%Y-%m-%d %H:%M:%S`

echo "$startdate,Start mysql_drop_partition"

user=root

password=xxxxxxxxx

host=127.0.0.1

mysql -u"$user" -p"$password" -h"$host" -e "call _drop_partition()"

enddate=`date +%Y-%m-%d %H:%M:%S`

echo "$enddate,End mysql_drop_partition"

echo ""