I am a php developer, I was searching for countries and states list of world in a mysql data format. Can one help me, where can I find and download it.
+6
A:
It's not in SQL format, but check out the ISO country code list.
Interestingly enough, you can get these as databases (ISO claim these are databases, but they look like spreadsheets to me!). Not free, however.
Brian Agnew
2009-10-02 16:00:24
You can download them from the ISO website in XML or delimited-text formats, which should be a piece-of-cake to import into MySQL: http://www.iso.org/iso/country_codes/iso_3166_code_lists.htm
LukeH
2009-10-02 16:41:59
+1
A:
You can get this information from here, the data is a free download. I have used this data and just created scripts to get it in the format I wanted, and then inserted it into a mysql database. There is an excellent blog post here that discusses using this data in Symfony(a php framework)
broschb
2009-10-02 16:03:21
A:
Geonames.org (http://www.geonames.org/) has great, free, web services and also downloads of sql dumps for their entire schema. You should check it out.
Kyle J. Dye
2009-10-02 16:16:25