www.datanetworksource.com

CREATE DATABASE zippremium;

CREATE TABLE zipcodes (
    ZIP char(5) not null,
    CITY varchar(28),
    COUNTY varchar(25),
    STATENAME varchar(28),
    STATE char(2),
    CITYTYPE char(1),
    ZIPTYPE char(1),
    FIPS_STATE char(2),
    FIPS_COUNTY char(3),
    AREACODE varchar(64),
    GMT char(2),
    DST char(1),
    LATITUDE double,
    LONGITUDE double);

CREATE TABLE county (
    FIPS_STATE char(2) not null,
    FIPS_COUNTY char(3) not null,
    COUNTY varchar(25),
    STATE char(2),
    COUNTY_TYPE char(1),
    POPULATION double,
    LA_MILES double,
    WA_MILES double,
    NAME_TYPE char(1));

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