MYSQL Country & Nationality List Imports

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.

Visit the project

Project Information

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

Usage

Use PHPmyAdmin to import the SQL file into your database.

New Additions

Time Zone SQL Import
Country Flags

Improvements

If you find this useful or find any issue, open an Issue on GitHub.