where can I find list of countries and states for mysql

Question

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.

Answer 1

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.

EDIT: Now that first link requires payment, I would perhaps check the current ISO-3166 Wikipedia page.