sh脚本调用存储过程

最新推荐文章于 2023-12-30 13:11:23 发布

我是天博

最新推荐文章于 2023-12-30 13:11:23 发布

阅读量514

点赞数

文章标签： java 数据库服务器

本文链接：https://blog.csdn.net/weixin_46870648/article/details/128190429

版权

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