vi del_last_3_month_log.sh
#!/bin/sh
##LAST_MONTH_DAY=`date -d last-month +%Y-%m-%d`
LAST_3_MONTH_DAY=`date --date='3 month ago' '+%y%m%d'`
#select count(*) from SystemEvents where date_format(ReceivedAt,'%Y-%m-%d')>='2013-07-01';
#mysql -utspadmin -p1PrOSUc+ Syslog -e "delete from SystemEvents where date_format(ReceivedAt,'%Y-%m-%d')<='$LAST_3_MONTH_DAY';"
mysql -ursyslog -predhat -e "use Syslog;drop table log$LAST_3_MONTH_DAY;delete from logcon_sources where id="$LAST_3_MONTH_DAY""