#!/bin/bash
set -e
if [[ $1 = "myuu" ]];
then
HOST=10.***.40.**
USER=root
PASS=***
PORT=3306
DBNAME=myuu
elif [[ $1 = "foctool_sunriver" ]];
then
HOST=10.***.19.*
USER=root
PASS=****
PORT=3306
DBNAME=foctool_sunriver
else
echo "没有匹配的数据库信息,请联系管理员添加!"
echo "参数1为dbname,参数2为sql(带引号)"
exit
fi
cmd=$2
cnt=$(mysql -h${HOST} -u${USER} -p${PASS} ${DBNAME} -s -e "${cmd}")
echo "${cnt}"
exit
保存文件名称为 mysql_sql
调用 mysql_sql foctool_sunriver "call rpt_statictics_data('1',CONCAT(year(date_sub(curdate(),interval 1 day)),'-01-01'),null);"