shell语句查询mysql数据库的常用方法

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"}');