一、在shell中执行mysql命令并向mysql命令中传递参数时，可以如下写：
点击(此处)折叠或打开
-
#!/bin/bash
-
[ -z $1 ]&&echo -e "Usage error!\nUsage:Command DiviceID"&&exit 1
-
echo --------------------Bundled record-------------------
-
mysql -uroot -pipvs@com -e \
- "select * from ipvs_db.DevRelatedUser where DevOrGrpId like \"%$1%\"" 2>/dev/null