shell 按行处理sql结果 并发送邮件

#!/bin/bash

echo "输入开始时间： "  
read start

echo "输入结束时间： "  
read end

TEMP=$(/mysql -uroot -p123456 -h127.0.0.1 -P16120 --database test -s -e "select count(1) from user;");

echo $TEMP;

array

while read -a row

do

echo "..${row[0]}..${row[1]}..${row[2]}..${row[3]}.."

array+="${row[2]}登录人员为(${row[1]});"
echo $array;

done< <(echo "select id,name,age from user;" | //mysql -uroot -p123456 -h127.0.0.1 -P16120 test -s)

desc

desc="从$start到$end之间,共有$TEMP个机构登录，分别为$array"

echo $desc

curl  -H "Content-Type:application/json;charset=UTF-8" -XPOST http://127.0.0.1:8080/sendEmail -d '{"content": "'"$desc"'","number":123 }'