Archive for the ‘MySQL’ Category

U.S. States CSV / SQL

Thursday, October 11th, 2007

I needed a mySQL table containing the common names of the U.S. States and their two letter abbreviations. I quickly Googled and couldn’t find anything. Maybe I didn’t search long enough. All I found was a Wikipedia article that listed them.

I grabbed the contents, formatted them with BBEdit to a CSV and imported them into mySQL. Just so no one else has to do that, here you go: state.csv, state.sql

Hope this helps someone.