1,首先Linux上需要安装MySQL,需要用到MySQL命令对数据库进行操作(安装步骤详情见第一个博客内容)
2,touch xxx.sh 创建一个脚本,赋予执行权限 chmod +x xxx.sh 或者 chmod 755 xxx.sh
3,两个命令 sh -n xxx.sh 返回脚本语法错误,sh -x xxx.sh执行脚本并返回所有变量的值
4,./xxx.sh 执行脚本
脚本:
#!/bin/sh
MYSQL=/usr/local/mysql/bin/mysql
HOSTNAME=""
PORT=""
USERNAME=""
PASSWORD=""
DBNAME=""
TABLENAME=""
NOW_DATE=`date '+%Y-%m-%d %H:%M:%S'`
clientCode=""
random=`sh /usr/local/script/shellRandom.sh`
#sql="insert into ${TABLENAME}(taking_num) values (-1)"
sql="update ${TABLENAME} set taking_num=$random where client_code='${clientCode}'"
#sql="delete from ${TABLENAME} where client_code='${clientCode}' and taking_num = -1"
${MYSQL} -h${HOSTNAME} -P${PORT} -u${USERNAME} -p${PASSWORD} ${DBNAME} -e "${sql}"
#echo "errormsg" 2>../shellDB.log;
if [ $? = "0" ];then
echo "${NOW_DATE} SUCCESS! $sql"
else
echo "${NOW_DATE} FAILD! $sql"
fi