Load Data to MySQL Database from delimited txt file

Load Data to MySQL Database from delimited txt file

Closed - This job posting has been filled and work has been completed.

Job Description

I need a database .SQL file created for the Database that can be downloaded here:

This should be fairly easy for someone with the SQL LOAD DATA command.

http://geonames.usgs.gov/domestic/download_data.htm

Here is the exact file.

http://geonames.usgs.gov/docs/stategaz/NationalFile_20121204.zip

Other open jobs by this client