Copyright (C) 2006 Quentin Sager Consulting Inc
All rights reserved.
www.quentinsagerconsulting.com

CREATE DATABASE ziplite;

CREATE TABLE zipcodes (
    ZIP char(5) not null,
    CITY varchar(28),
    STATE char(2),
    ZIPTYPE char(1));

LOAD DATA LOCAL INFILE 'ziplite.csv' INTO TABLE zipcodes FIELDS TERMINATED BY ',' LINES TERMINATED BY '\r\n' IGNORE 1 LINES;