Skip to content

Instantly share code, notes, and snippets.

@pkbarbiedoll
pkbarbiedoll / MySQL-countries-continents-ISO-3166-codes
Last active June 18, 2018 15:20 — forked from ricardodsanchez/countries-continents-ISO-3166-codes
MySQL tables with country names, continent names and ISO-3166 codes.
/**
* Country names, continent names and ISO-3166 codes.
*/
CREATE TABLE lookup_continents (
code_continent ENUM('AF','AN','AS','EU','NA','OC','SA') NOT NULL, /* Continent code */
name_continent VARCHAR(255),
PRIMARY KEY (code_continent)
) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;