shell获取mysql数据

#!/bin/bash
#-*- coding:utf-8 -*-

HOSTNAME="数据库实例IP"
PORT="端口"
USERNAME="用户名"
PASSWORD="密码"
DBNAME="库名"
select_sql="select 1 这里是查询语句"
*#执行查询*
result=`mysql -h${HOSTNAME}  -P${PORT}  -u${USERNAME} -p${PASSWORD} ${DBNAME} -Bse "${select_sql}"`

number=`echo ${result} | awk '{print $1}'` #获取到的第一个值
number1=`echo ${result} | awk '{print $2}'` #获取到的第二个值
number2=`echo ${result} | awk '{print $n}'` #获取到的第N个值

echo $number
echo $number1
echo $number2