shell 脚本调用mysql存储过程

#!/bin/sh

##  The function of the script is used to balance statistics,we get
##  data from the table accseqs,after the analysis and calculation data,
##  the results will be inserted into the table acc_balances.

##  the script is executed at 1 o'clock by every day.

DIR="/var/www/apps/sql"
DATE=$(date +%Y%m%d --date '1 days ago')
HOST=192.168.20.95
USER=admin
PASSWD=000000
DATABASE=zhxt
FILE=result.txt

cd ${DIR}

echo "the date:"${DATE}

SQL="exec mysql -h${HOST} -u${USER} -p${PASSWD} -D ${DATABASE} --default-character-set=utf8 -e \"call query_balance(${DATE})\""
echo ${SQL}>>${FILE}

if   mysql -h${HOST} \
           -u${USER} \
           -p${PASSWD} \
           -D ${DATABASE} \
           --default-character-set=utf8 \
           -e "call query_balance(${DATE})"; then
    echo "ok">>${FILE}
else
    echo "fail">>${FILE}
fi

exit