Need all known countries's state abbreviation

Question

I am working on a project, where i have to show countries & states both in drop down. I have all countries short name, get form

But I don't have state` abbreviation of each country. I found some of country from wiki :

Is that any repository or api so that i can update my table with state`s short name.

Nope. Because each country has its on names for states,countrs,citys. If you have an api that will deliver this information in all languages.... this api will be paid i thing. You have to crawl the web until you have all collected taht you need. — JustOnUnderMillions, Mar 10 '17 at 13:47
http://stackoverflow.com/questions/11318203/get-2-letter-state-province-abbreviation && https://www.iso.org/iso-3166-country-codes.html — JustOnUnderMillions, Mar 10 '17 at 13:49

score 0 · Answer 1 · answered Mar 10 '17 at 13:49

0

if you have mysql installed with default schemas. you will find what you need under the world schema.

answered Mar 10 '17 at 13:49

Peter R

looks more like a comment than an answer – RST Mar 10 '17 at 14:18
I checked at mysql official website ,https://dev.mysql.com/doc/world-setup/en/ . Are you talking about this . – Hitesh Jangid Mar 10 '17 at 14:18
@ RST, actually it's a comment. reputation level does not allow me to comment before placing an answer – Peter R Mar 10 '17 at 14:23

score 0 · Accepted Answer · answered Mar 11 '17 at 06:08

0

You can access to free state code list from https://www.ip2location.com/free/iso3166-2

answered Mar 11 '17 at 06:08

Michael C.

It seems most of the state are there what i was looking for. Thank you. – Hitesh Jangid Mar 15 '17 at 08:02

2 Answers2