shell脚本调用mysql存储过程

页面导航:首页 > 数据库 > Mysql > shell脚本调用mysql存储过程

shell脚本调用mysql存储过程

来源: 作者: 时间:2016-02-02 08:56 【

! 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 w
#!/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  -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


Tags:

文章评论

最 近 更 新
热 点 排 行
Js与CSS工具
代码转换工具

<