Shell读取mysql数据

今天有个需求需要写个shell读取mysql记录,操作一些文件,搜索了一下踩了些坑记录一下
shell2.0写法
注释：注意"done< <(“的写法，第一个”<“要和"done"之间没空格，两个”<“之间有一个空格，”<" 和"("之间没空格

COMMAND1="mysql -h${HOSTNAME}  -P${PORT}  -u${USERNAME} -p${PASSWORD} ${DBNAME}
e.g.

while read -a row
do
    echo "..${row[0]}..${row[1]}.."
done< <(echo "select  id ,name  from  student;" | ${COMMAND1})

while read a b
do
    echo "..${a}..${b}.."
done< <(echo "select  id ,name  from  student;" | ${COMMAND1})

shell3.0写法

while read row
do 
echo "..${row}.."
 
done <<< `echo "select  id ,name  from  student" | ${cmd}`

查看shell的命令是

bash -version

下面是引用的帖子

• https://blog.youkuaiyun.com/banana1006034246/article/details/90038406
• https://www.cnblogs.com/fire909090/p/7202420.html