delete from SCECityTerritory;
delete from PGETerritoryZip;
delete from UtilityCounty;
delete from Utility;

delete from City;
delete from ZipCounty;
delete from ZipCode;
delete from County;
delete from USState;

delete from WBANClimate;
delete from NRELRedbook;
delete from WBAN;

load data local infile '/usr/home/jhook/public_html/ROI/bulkload/WBAN.txt' into table WBAN fields terminated by '|';
load data local infile '/usr/home/jhook/public_html/ROI/bulkload/NRELRedbook.txt' into table NRELRedbook fields terminated by '|';
load data local infile '/usr/home/jhook/public_html/ROI/bulkload/WBANClimate.txt' into table WBANClimate fields terminated by '|';

load data local infile '/usr/home/jhook/public_html/ROI/bulkload/USState.out' into table USState fields terminated by '|';
load data local infile '/usr/home/jhook/public_html/ROI/bulkload/CACounty.out' into table County fields terminated by '|';
load data local infile '/usr/home/jhook/public_html/ROI/bulkload/ZipCode.out' into table ZipCode fields terminated by '|';
load data local infile '/usr/home/jhook/public_html/ROI/bulkload/ZipCounty.out' into table ZipCounty fields terminated by '|';
load data local infile '/usr/home/jhook/public_html/ROI/bulkload/City.out' into table City fields terminated by '|';

load data local infile '/usr/home/jhook/public_html/ROI/bulkload/Utility.out' into table Utility fields terminated by '|';
load data local infile '/usr/home/jhook/public_html/ROI/bulkload/UtilityCounty.out' into table UtilityCounty fields terminated by '|';
load data local infile '/usr/home/jhook/public_html/ROI/bulkload/PGERESZIPS.out' into table PGETerritoryZip fields terminated by '|';
load data local infile '/usr/home/jhook/public_html/ROI/bulkload/SCECityTerritory.out' into table SCECityTerritory fields terminated by '|';