删除数据脚本
#!/bin/bash
#end_time=$(date +"%Y-%m" -d"1 month ago")
#file_time=$(date +"%Y%m" -d"2 month ago")
end_time=$(date +"%Y-%m")
file_time=$(date +"%Y%m" -d"1 month ago")
echo $end_time, $file_time
date
echo 'start'
mysql -hm3314.mysql.wanhui.cn -P3314 -usms -psms sms -e "delete from montnetsid where create_time < '2015-01' and create_time > '2014-12-12 11:00'"
date
echo '3'
mysql -hm3314.mysql.wanhui.cn -P3314 -usms -psms sms -e "delete from montnetsid where create_time < '2015-01' and create_time > '2014-12-12 10:50'"
date
echo '2'
mysql -hm3314.mysql.wanhui.cn -P3314 -usms -psms sms -e "delete from montnetsid where create_time < '2015-01' and create_time > '2014-12-12 10:40'"
date
echo '1'
mysql -hm3314.mysql.wanhui.cn -P3314 -usms -psms sms -e "delete from montnetsid where create_time < '2015-01' and create_time > '2014-12-12 10:30'"
date
echo '0'
mysql -hm3314.mysql.wanhui.cn -P3314 -usms -psms sms -e "delete from montnetsid where create_time < '2015-01' and create_time > '2014-12-12 10:20'"
date
echo '5'
mysql -hm3314.mysql.wanhui.cn -P3314 -usms -psms sms -e "delete from montnetsid where create_time < '2015-01' and create_time > '2014-12-12 10:10'"
date
echo '4'
mysql -hm3314.mysql.wanhui.cn -P3314 -usms -psms sms -e "delete from montnetsid where create_time < '2015-01' and create_time > '2014-12-12 10:00'"
date
echo '3'
mysql -hm3314.mysql.wanhui.cn -P3314 -usms -psms sms -e "delete from montnetsid where create_time < '2015-01' and create_time > '2014-12-12 9:50'"
date
echo '2'
mysql -hm3314.mysql.wanhui.cn -P3314 -usms -psms sms -e "delete from montnetsid where create_time < '2015-01' and create_time > '2014-12-12 9:40'"
date
echo '1'