脚本如下
#!/bin/sh
#域名,调用该脚本时传入的参数
domain=$1
#sql语句
#https://blog.csdn.net/weixin_42592326/article/details/122540910
SQL="select * FROM test.aa where aa='${domain}';"
# echo ${SQL}
#连接数据,查询sql
MYSQL=`mysql -h 127.0.0.1 -P3306 -u root -proot -e "${SQL}"`
#awk '{print $2}': 这是一个AWK命令,用于处理输入并打印输入的第二个字段(列)
webDir=`echo ${MYSQL} | awk '{print $2}'`
#判断一下数据
if [ ! -d "${webDir}" ]; then
echo 'whith no data'
exit 1
else
echo ${webDir}
fi
语法通过 但是centos下编译过不去
[hxlwh@localhost shell]$ dos2unix checkdatabasewithdata.sh
dos2unix: converting file checkdatabasewithdata.sh to Unix format ...
带参数执行
[hxlwh@localhost shell]$ sh checkdatabasewithdata.sh a1
select aa FROM test.aa where aa='a1';
mysql: [Warning] Using a password on the command line interface can be insecure.
testpoint1
aa a1
webDir: a1
whith no data