SQL="select id,val from test1 order by id desc limit 1"
RESULT=$(mysql -uroot -proot@123 test -e "${SQL}" | awk 'NR > 1' )
rs=`echo ${RESULT} | awk -F ' ' '{print $1}'`
echo ${rs}
RESULT=$(mysql -uroot -proot@123 test -e "${SQL}" | awk 'NR > 1' )
rs=`echo ${RESULT} | awk -F ' ' '{print $1}'`
echo ${rs}