MySql INSERTS for U.S. States

[marcel]

Hi,

I need a hand with this. Does any one have the U.S. State Codes lying around somewhere on a database ?
I want to insert them into my database. My present database has numberical ids - which is not what I want.

Can someone post MySQL insert statements into this thread ?
I want something looking like this

INSERT INTO state VALUES (AL, 'Alabama');
INSERT INTO state VALUES (AZ, 'Arizona');
INSERT INTO state VALUES (CA, 'California');

I know you get the picture. - I'm sure others will benefit too.

Thanks

[randem]

Is it really so hard to go to Google, find a list of states, and do a "search and replace" to replace the HTML around it with SQL syntax?

[marcel]

NO it does not sound that difficult. But not everyone uses state codes, some use the actual state name.

I'm sure someone has those STATE codes in a database somewhere.

Thanks in advance to the kind person who can provide those INSERT statements.

[r937]

marcel, http://www.itl.nist.gov/fipspubs/fip5-2.htm