#!bin/bash del_table()
{
#月初的第一天
month_first_day=`date +%Y%m01` #要删除的日期
last_7day_ago=`date -d "-8day" +%Y%m%d` #drop table
table='t_focus_goods_coral_month_'$last_7day_ago if [[ $month_first_day == $last_7day_ago ]];then
exit
else
#mysql -h 1270.0.01 -uxx -pxx -P -A focus -e "drop table ${table}"
echo "${table}"
fi
} del_table