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

CREATE DATABASE zipstandard;

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

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