按行讀取sql結(jié)果:
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執(zhí)行結(jié)果讀取到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)