shell传递参数给mysql

一、在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