#!/bin/bash

rm t.sql 2>/dev/null

for id in `seq 1101 10000`; do
	echo "insert into Electorate (id,PollNumber, FirstName, LastName, Salutation, StreetNumber, StreetNumberSuffix, Street, Unit, City, Province, PostalCode, PhoneNumber) values ($id,1212,'Kevin','O''Donnell','Mr.','166','Cresent','Westhaven','','Ottawa','ON','K1Z 7G3','');" >> t.sql


done

cat t.sql | mysql -u greenware -p greenware