1、编写sql语句查询
sql="select * from CHANNELIDCHANGELOG where OLDID=$a order by TIME desc;";
ret=$(mysql -u $DB_USER -h ${DB_IP} -p${DB_PASSWD} $DB_NAME -e "$sql"');
echo $ret
2、去掉标题字段,增加awk ‘NR>1’
ret=$(mysql -u $DB_USER -h ${DB_IP} -p${DB_PASSWD} $DB_NAME -e "$sql"|awk 'NR>1');
3、增加行尾换行符,增加|awk ‘{print $0”\n”}’
ret=$(mysql -u $DB_USER -h ${DB_IP} -p${DB_PASSWD} $DB_NAME -e "$sql"|awk 'NR>1'|awk '{print $0"\n"}');