!/bin/bash
dt=date -d "1 minute ago" "+%F %H:%M"
num=/usr/local/mysql/bin/mysql xmetc-sms -N -e "select count(*) from msg_smsmessage where rescode=-1 and DATE_FORMAT(sendtime,'%Y-%m-%d %H:%i')='$dt'"
if [ dt'"
fi
dt=date -d "1 minute ago" "+%F %H:%M"
num=/usr/local/mysql/bin/mysql xmetc-sms -N -e "select count(*) from msg_smsmessage where rescode=-1 and DATE_FORMAT(sendtime,'%Y-%m-%d %H:%i')='$dt'"
if [ dt'"
fi