Write a shell script to generate sql

#/bin/sh -x
export ip=3
while [ $ip -le 48 ] ; do
     export port=10000
     while [ $port -le 10007 ] ; do
         echo "insert into compute_node (ip_address, cpu_ghz,\
              memory_gbyte, disk_gbyte, status) values ('12.200.83.$ip:$port', \
              null, null, null, 'idle');"
         ((port ++))
     done
     ((ip++))
done

Reference: Frank