Blum,Richard,123 Main St.,Chicago,IL,60601 
Blum,Barbara,123 Main St.,Chicago,IL,60601 
Bresnahan,Christine,456 Oak Ave.,Columbus,OH,43201 
Bresnahan,Timothy,456 Oak Ave.,Columbus,OH,43201

#!/bin/bash 
# read file and create INSERT statement for MYSQL 
 
outfile="mem.sql" 
IFS="," 
while read lname fname address city state zip 
do 
  cat >> $outfile << EOF 
  INSERT INTO members (lname, fname, address, city, state, zip) VALUES 
  ('$lname', '$filename', '$address', '$city', '$state', '$zip'); 
EOF 
done < ${1}

INSERT INTO members (lname, fname, address, city, state, zip) VALUES 
  ('Blum', '', '123 Main St.', 'Chicago', 'IL', '60601'); 
  INSERT INTO members (lname, fname, address, city, state, zip) VALUES 
  ('Blum', '', '123 Main St.', 'Chicago', 'IL', '60601'); 
  INSERT INTO members (lname, fname, address, city, state, zip) VALUES 
  ('Bresnahan', '', '456 Oak Ave.', 'Columbus', 'OH', '43201'); 
  INSERT INTO members (lname, fname, address, city, state, zip) VALUES 
  ('Bresnahan', '', '456 Oak Ave.', 'Columbus', 'OH', '43201');