sh脚本调用存储过程-创新互联

#!/bin/bash

DIR="/damo/application/task/"
DATE=$(date +%Y%m%d --date '1 days ago')
HOST=127.0.0.1
USER=damo_dev
PASSWD=damo@db@123
DATABASE=damo_dev
FILE=result.txt

cd ${DIR}

echo "the date:"${DATE}

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

/usr/local/mysql5.6/bin/mysql -h${HOST} -u${USER} -p${PASSWD} -D ${DATABASE} --default-character-set=utf8 -e "call edit_insert_report_wms_sku_stock_day_info_0001('');"
/usr/local/mysql5.6/bin/mysql -h${HOST} -u${USER} -p${PASSWD} -D ${DATABASE} --default-character-set=utf8 -e "call edit_insert_report_wms_sku_stock_day_info_0002('');"
/usr/local/mysql5.6/bin/mysql -h${HOST} -u${USER} -p${PASSWD} -D ${DATABASE} --default-character-set=utf8 -e "call edit_insert_report_wms_sku_stock_day_info_0003('');"
/usr/local/mysql5.6/bin/mysql -h${HOST} -u${USER} -p${PASSWD} -D ${DATABASE} --default-character-set=utf8 -e "call edit_insert_report_wms_sku_stock_day_info_0004('');"
/usr/local/mysql5.6/bin/mysql -h${HOST} -u${USER} -p${PASSWD} -D ${DATABASE} --default-character-set=utf8 -e "call edit_insert_report_wms_sku_stock_day_info_0005('');"
/usr/local/mysql5.6/bin/mysql -h${HOST} -u${USER} -p${PASSWD} -D ${DATABASE} --default-character-set=utf8 -e "call edit_insert_report_wms_sku_stock_day_info_0006('');"
/usr/local/mysql5.6/bin/mysql -h${HOST} -u${USER} -p${PASSWD} -D ${DATABASE} --default-character-set=utf8 -e "call edit_insert_report_wms_sku_stock_day_info_0007('');"
/usr/local/mysql5.6/bin/mysql -h${HOST} -u${USER} -p${PASSWD} -D ${DATABASE} --default-character-set=utf8 -e "call edit_insert_report_wms_sku_stock_day_info_0008('');"
/usr/local/mysql5.6/bin/mysql -h${HOST} -u${USER} -p${PASSWD} -D ${DATABASE} --default-character-set=utf8 -e "call edit_insert_report_wms_sku_stock_day_info_0009('');"
/usr/local/mysql5.6/bin/mysql -h${HOST} -u${USER} -p${PASSWD} -D ${DATABASE} --default-character-set=utf8 -e "call edit_insert_report_wms_sku_stock_day_info_0010('');"
/usr/local/mysql5.6/bin/mysql -h${HOST} -u${USER} -p${PASSWD} -D ${DATABASE} --default-character-set=utf8 -e "call edit_insert_report_wms_sku_stock_day_info_0011('');"
/usr/local/mysql5.6/bin/mysql -h${HOST} -u${USER} -p${PASSWD} -D ${DATABASE} --default-character-set=utf8 -e "call edit_insert_report_wms_sku_stock_day_info_0013('');"
/usr/local/mysql5.6/bin/mysql -h${HOST} -u${USER} -p${PASSWD} -D ${DATABASE} --default-character-set=utf8 -e "call edit_insert_report_wms_sku_stock_day_info_0014('');"

exit

你是否还在寻找稳定的海外服务器提供商？创新互联www.cdcxhl.cn海外机房具备T级流量清洗系统配攻击溯源，准确流量调度确保服务器高可用性，企业级服务器适合批量采购，新人活动首月15元起，快前往官网查看详情吧