CREATE TABLE capecod (
myid int(20) NOT NULL AUTO_INCREMENT  PRIMARY KEY,
name varchar(40),
zipcode varchar(7)
);


insert into capecod (name,zipcode) values ('Barnstable','02630');
insert into capecod (name,zipcode) values ('Bass River','02664');
insert into capecod (name,zipcode) values ('Bourne','02532');
insert into capecod (name,zipcode) values ('Brewster','02631');
insert into capecod (name,zipcode) values ('Centerville','02632');
insert into capecod (name,zipcode) values ('Chatham','02633');
insert into capecod (name,zipcode) values ('Cotuit','02635');
insert into capecod (name,zipcode) values ('Dennis','02638');
insert into capecod (name,zipcode) values ('Dennis Port','02639');
insert into capecod (name,zipcode) values ('East Sandwich','02537');
insert into capecod (name,zipcode) values ('Eastham','02642');
insert into capecod (name,zipcode) values ('Falmouth','02536');
insert into capecod (name,zipcode) values ('Harwich','02645');
insert into capecod (name,zipcode) values ('Hyannis','02601');
insert into capecod (name,zipcode) values ('Hyannis Port','02647');
insert into capecod (name,zipcode) values ('Mashpee','02649');
insert into capecod (name,zipcode) values ('New Seabury','02649');
insert into capecod (name,zipcode) values ('North Eastham','02651');
insert into capecod (name,zipcode) values ('North Falmouth','02556');
insert into capecod (name,zipcode) values ('North Truro','02652');
insert into capecod (name,zipcode) values ('Onset','02558');
insert into capecod (name,zipcode) values ('Orleans','02653');
insert into capecod (name,zipcode) values ('Osterville','02655');
insert into capecod (name,zipcode) values ('Pocasset','02559');
insert into capecod (name,zipcode) values ('Provincetown','02657');
insert into capecod (name,zipcode) values ('Sagamore Beach','02562');
insert into capecod (name,zipcode) values ('Sandwich','02562');
insert into capecod (name,zipcode) values ('South Chatham','02659');
insert into capecod (name,zipcode) values ('South Orleans','02662');
insert into capecod (name,zipcode) values ('South Yarmouth','02664');
insert into capecod (name,zipcode) values ('Truro','02666');
insert into capecod (name,zipcode) values ('Wareham','02571');
insert into capecod (name,zipcode) values ('Wellfleet','02667');
insert into capecod (name,zipcode) values ('West Dennis','02670');
insert into capecod (name,zipcode) values ('West Falmouth','02574');
insert into capecod (name,zipcode) values ('West Hyannisport','02672');
insert into capecod (name,zipcode) values ('West Yarmouth','02673');
insert into capecod (name,zipcode) values ('Woods Hole','02543');
insert into capecod (name,zipcode) values ('Yarmouth','02675');
insert into capecod (name,zipcode) values ('Yarmouth Port','02675');