shell: mysql删除183天前的table(保留半年的log数据)

1.将下面shell脚本放入计划任务中执行：

#!/bin/bash
dt=SystemEvents_`date -d '183 days ago' +%Y_%m_%d`
echo "info:  Today is `date +%F`"
echo "info:  the table of 183 days ago is $dt"
echo "info:  start drop table $dt"
mysql -uroot -p123456 -e "use Syslog;drop table $dt;"&&echo "info:  drop table $dt success !"||echo "info:  drop table $dt faild !!!"
echo ""
echo ""