按行讀取sql結果:
while read -a row
do
echo "..${row[0]}..${row[1]}..${row[2]}.."
done < <(echo "SELECT A, B, C FROM table_a"
mysql database -u $user -p $password)
將sql執行結果讀取到shell變量中:
while read a b c
do
echo "..${a}..${b}..${c}.."
done < <(echo "SELECT A, B, C FROM table_a"
mysql database -u $user -p $password)