Sql dump of all the European Countries.

mysql-eu-countries

/**
 * Countries MySQL Tables 
 * Compiled by Atanas Bozhinov, 2015
 */

CREATE TABLE `eucountries` (
  `country_id` int(11) NOT NULL AUTO_INCREMENT,
  `code` char(2) NOT NULL COMMENT 'Two-letter country code (ISO 3166-1 alpha-2)',
  `name` varchar(64) NOT NULL COMMENT 'English country name',
  `full_name` varchar(128) NOT NULL COMMENT 'Full English country name',
  `iso3` char(3) NOT NULL COMMENT 'Three-letter country code (ISO 3166-1 alpha-3)',
  PRIMARY KEY (`country_id`),
  UNIQUE KEY `name` (`code`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of countries
-- ----------------------------
INSERT INTO `eucountries` VALUES ('1', 'AL', 'Albania', 'Republic of Albania', 'ALB');
INSERT INTO `eucountries` VALUES ('2', 'AN', 'Netherlands Antilles', 'Netherlands Antilles', 'ANT');
INSERT INTO `eucountries` VALUES ('3', 'AT', 'Austria', 'Republic of Austria', 'AUT');
INSERT INTO `eucountries` VALUES ('4', 'BA', 'Bosnia and Herzegovina', 'Bosnia and Herzegovina', 'BIH');
INSERT INTO `eucountries` VALUES ('5', 'BE', 'Belgium', 'Kingdom of Belgium', 'BEL');
INSERT INTO `eucountries` VALUES ('6', 'BG', 'Bulgaria', 'Republic of Bulgaria', 'BGR');
INSERT INTO `eucountries` VALUES ('7', 'CH', 'Switzerland', 'Swiss Confederation', 'CHE');
INSERT INTO `eucountries` VALUES ('8', 'CZ', 'Czech Republic', 'Czech Republic', 'CZE');
INSERT INTO `eucountries` VALUES ('9', 'DE', 'Germany', 'Federal Republic of Germany', 'DEU');
INSERT INTO `eucountries` VALUES ('10', 'DK', 'Denmark', 'Kingdom of Denmark', 'DNK');
INSERT INTO `eucountries` VALUES ('11', 'EE', 'Estonia', 'Republic of Estonia', 'EST');
INSERT INTO `eucountries` VALUES ('12', 'ES', 'Spain', 'Kingdom of Spain', 'ESP');
INSERT INTO `eucountries` VALUES ('13', 'FI', 'Finland', 'Republic of Finland', 'FIN');
INSERT INTO `eucountries` VALUES ('14', 'FR', 'France', 'French Republic', 'FRA');
INSERT INTO `eucountries` VALUES ('15', 'GB', 'United Kingdom', 'United Kingdom of Great Britain & Northern Ireland', 'GBR');
INSERT INTO `eucountries` VALUES ('16', 'GE', 'Georgia', 'Georgia', 'GEO');
INSERT INTO `eucountries` VALUES ('17', 'GL', 'Greenland', 'Greenland', 'GRL');
INSERT INTO `eucountries` VALUES ('18', 'GR', 'Greece', 'Hellenic Republic Greece', 'GRC');
INSERT INTO `eucountries` VALUES ('19', 'HR', 'Croatia', 'Republic of Croatia', 'HRV');
INSERT INTO `eucountries` VALUES ('20', 'HU', 'Hungary', 'Republic of Hungary', 'HUN');
INSERT INTO `eucountries` VALUES ('21', 'IE', 'Ireland', 'Ireland', 'IRL');
INSERT INTO `eucountries` VALUES ('22', 'IT', 'Italy', 'Italian Republic', 'ITA');
INSERT INTO `eucountries` VALUES ('23', 'LT', 'Lithuania', 'Republic of Lithuania', 'LTU');
INSERT INTO `eucountries` VALUES ('24', 'LU', 'Luxembourg', 'Grand Duchy of Luxembourg', 'LUX');
INSERT INTO `eucountries` VALUES ('25', 'LV', 'Latvia', 'Republic of Latvia', 'LVA');
INSERT INTO `eucountries` VALUES ('26', 'MA', 'Morocco', 'Kingdom of Morocco', 'MAR');
INSERT INTO `eucountries` VALUES ('27', 'MC', 'Monaco', 'Principality of Monaco', 'MCO');
INSERT INTO `eucountries` VALUES ('28', 'MD', 'Moldova', 'Republic of Moldova', 'MDA');
INSERT INTO `eucountries` VALUES ('29', 'ME', 'Montenegro', 'Republic of Montenegro', 'MNE');
INSERT INTO `eucountries` VALUES ('30', 'MK', 'Macedonia', 'Republic of Macedonia', 'MKD');
INSERT INTO `eucountries` VALUES ('31', 'MT', 'Malta', 'Republic of Malta', 'MLT');
INSERT INTO `eucountries` VALUES ('32', 'NL', 'Netherlands', 'Kingdom of the Netherlands', 'NLD');
INSERT INTO `eucountries` VALUES ('33', 'NO', 'Norway', 'Kingdom of Norway', 'NOR');
INSERT INTO `eucountries` VALUES ('34', 'PL', 'Poland', 'Republic of Poland', 'POL');
INSERT INTO `eucountries` VALUES ('35', 'PT', 'Portugal', 'Portuguese Republic', 'PRT');
INSERT INTO `eucountries` VALUES ('36', 'RO', 'Romania', 'Romania', 'ROU');
INSERT INTO `eucountries` VALUES ('37', 'RS', 'Serbia', 'Republic of Serbia', 'SRB');
INSERT INTO `eucountries` VALUES ('38', 'RU', 'Russian Federation', 'Russian Federation', 'RUS');
INSERT INTO `eucountries` VALUES ('39', 'SE', 'Sweden', 'Kingdom of Sweden', 'SWE');
INSERT INTO `eucountries` VALUES ('40', 'SI', 'Slovenia', 'Republic of Slovenia', 'SVN');
INSERT INTO `eucountries` VALUES ('41', 'SK', 'Slovakia', 'Slovakia (Slovak Republic)', 'SVK');
INSERT INTO `eucountries` VALUES ('42', 'SM', 'San Marino', 'Republic of San Marino', 'SMR');
INSERT INTO `eucountries` VALUES ('43', 'TR', 'Turkey', 'Republic of Turkey', 'TUR');
INSERT INTO `eucountries` VALUES ('44', 'UA', 'Ukraine', 'Ukraine', 'UKR');
INSERT INTO `eucountries` VALUES ('45', 'VA', 'Vatican City', 'Holy See (Vatican City State)', 'VAT');