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
http://www.geognos.com/api/en/countries/info/all.json.
But I don't have state` abbreviation of each country. I found some of country from wiki :
https://en.wikipedia.org/wiki/ISO_3166-2:US
Is that any repository or api so that i can update my table with state`s short name.
You can access to free state code list from https://www.ip2location.com/free/iso3166-2
if you have mysql installed with default schemas. you will find what you need under the world schema.