One of the long standing GitHub projects we have been working on, is a list of country imports for MySQL. Recently we have added a nationality version for importing.
There are different versions for the import ranging from a simple list to country codes and names.
Use this mysql to import a list of countries and/or Nationalities into your database.
Types of Lists
- Simple country code and name
- Simple country code and name with InnoDB
- Detailed country info
- JSON Array
- PHP Array
The SQL imports contains the following info
- Table name: apps_countries / apps_nationality
- no ID's used on first import
- Country Name, Country Short code
Use PHPmyAdmin to import the SQL file into your database.
- Time Zone SQL Import
- Country Flags
If you find this useful or find any issue, open an Issue on GitHub.