Shell-获取Mysql查询返回值

Shell-获取Mysql查询返回值

获取单个值

export MYSQL_PWD=123abc!!!
aa=$(mysql -h192.168.8.240 -uroot -Ddatacut -e "select apppath from sys_d_code" --skip-column-names)
echo $aa

user=root
pass=yfgzSap123
port=9901
db=datacut
table=sys_d_code
set `mysql -u$user -p$pass -D$db -P $port -e "select outpath from $table"`
echo $2

获取多个值

mysql -uroot -pmysqlroot -Dmmmtest -e "select 'aa',count(1) from aa" --skip-column-names|while read a b
do
echo $a
echo $b
done