I will admit I am a newbie but I am trying to write some simple scripts

Situation:

I have a list of IP Addresses that I want to once or 2 times a day store the average ping response time in a database (mysql) I am part way there but not all the way there

I have the following

cat ./slow | while read line
do
for i in $line
do
ping -c1 -q $i | grep "mdev" | gawk -F"/" '{print $5}'
done
done

Which parses the average response time out properly I really would like to have something like the following

But my Question is Why can I not get $i to show up? in the print statment


cat ./slow | while read line
do
for i in $line
do
ping -c1 -q $i | grep "mdev" | gawk -F"/" '{print "update table set field1 ="$5" where field2="$i""}'
done
done

Results
update table set field1 =138.668 where field2=rtt min/avg/max/mdev = 138.668/138.668/138.668/0.000 ms
update table set field1 =209.089 where field2=rtt min/avg/max/mdev = 209.089/209.089/209.089/0.000 ms