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.
