#!/bin/bash
MYSQL=mysql
USER='xxxxy'
PASSWORD='xxxx'
DB='dpp'
HOST='110.192.555.80'
COMMAND=" SELECT run_step,run_result_code FROM uapi_asyn WHERE fetch_id='422' "
declare count=`$MYSQL -h${HOST} -u${USER} -p${PASSWORD} -D ${DB} -e "${COMMAND}" --skip-column-name`
for list in $count
do
echo " the item is $list"
done