Need a way to convert .csv files into .sql insert statements? Look no furthur!
Today we had a need to convert the City and State returned from the MaxMind GEOIP1 database into a ZipCode. Which, as they mention on their site is not entirely accurate using their own database and recommend to go with the iBegin Free ZIPCode database[2] to compare the GEOIP results with to find our zipcode. Fancy. Since we had to import the ZipCode’s into a MySQL database from a CSV file we had to figure out how to do this, and we’re archiving it here for you and for our own purposes....