快上网专注成都网站设计 成都网站制作 成都网站建设
成都网站建设公司服务热线：028-86922220

网站建设知识

十年网站开发经验 + 多家企业客户 + 靠谱的建站团队

量身定制 + 运营维护+专业推广+无忧售后，网站问题一站解决

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

#!/bin/bash

创新互联主要从事成都网站制作、做网站、网页设计、企业做网站、公司建网站等业务。立足成都服务满城,10多年网站建设经验,价格优惠、服务专业,欢迎来电咨询建站服务:028-86922220

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元起，快前往官网查看详情吧


网站名称：sh脚本调用存储过程-创新互联
转载来源：http://6mz.cn/article/pdjic.html

其他资讯