Isso funciona:
#!/bin/bash
results=($(mysql --user root -pwelcome ts -Bse "SELECT type, network_id, subnet_msk FROM remote_subnet;"))
cnt=${#results[@]}
for (( i=0 ; i<cnt ; i++ ))
do
echo "Record No. $i: ${results[$i]}"
fieldA=${results[0]};
fieldB=${results[1]};
fieldC=${results[2]};
done