Results 1 to 4 of 4
Thread: MySql INSERTS for U.S. States
Sep 29, 2002, 11:18 #1
MySql INSERTS for U.S. States
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.
Last edited by marcel; Sep 30, 2002 at 08:26.
Sep 30, 2002, 06:33 #2
- Join Date
- Jun 2002
- 0 Post(s)
- 0 Thread(s)
Re: MySql INSERTS for U.S. States
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?----Adopt-a-Sig----
Your message here!
Sep 30, 2002, 08:48 #3
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.
Sep 30, 2002, 09:36 #4
- Join Date
- Jul 2002
- Toronto, Canada
- 59 Post(s)
- 3 Thread(s)