MYSQL : Countries list for mysql

Countries list for mysql

SQL format:


CREATE TABLE IF NOT EXISTS `world_countries` (
  `country_id` int(5) NOT NULL AUTO_INCREMENT,
  `iso2` char(2) DEFAULT NULL,
  `short_name` varchar(80) NOT NULL DEFAULT '',
  `long_name` varchar(80) NOT NULL DEFAULT '',
  `iso3` char(3) DEFAULT NULL,
  `numcode` smallint(6) DEFAULT NULL,
  `un_member` varchar(12) DEFAULT NULL,
  `calling_code` varchar(8) DEFAULT NULL,
  `continent_code` char(2) NOT NULL,
  PRIMARY KEY (`country_id`),
  KEY `iso2` (`iso2`),
  KEY `iso3` (`iso3`),
  KEY `short_name` (`short_name`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=242 ;
--
-- Dumping data for table `world_countries`
--
INSERT INTO `world_countries` (`country_id`, `iso2`, `short_name`, `long_name`, `iso3`, `numcode`, `un_member`, `calling_code`, `continent_code`) VALUES
(6, 'AD', 'Andorra', 'Principality of Andorra', 'AND', 20, 'yes', '376', 'EU'),
(11, 'AR', 'Argentina', 'Argentine Republic', 'ARG', 32, 'yes', '54', 'SA'),
(12, 'AM', 'Armenia', 'Republic of Armenia', 'ARM', 51, 'yes', '374', 'AS'),
(14, 'AU', 'Australia', 'Commonwealth of Australia', 'AUS', 36, 'yes', '61', 'OC'),
(15, 'AT', 'Austria', 'Republic of Austria', 'AUT', 40, 'yes', '43', 'EU'),
(16, 'AZ', 'Azerbaijan', 'Republic of Azerbaijan', 'AZE', 31, 'yes', '994', 'AS'),
(18, 'BH', 'Bahrain', 'Kingdom of Bahrain', 'BHR', 48, 'yes', '973', 'AS'),
(20, 'BB', 'Barbados', 'Barbados', 'BRB', 52, 'yes', '1+246', 'NA'),
(21, 'BY', 'Belarus', 'Republic of Belarus', 'BLR', 112, 'yes', '375', 'EU'),
(22, 'BE', 'Belgium', 'Kingdom of Belgium', 'BEL', 56, 'yes', '32', 'EU'),
(28, 'BA', 'Bosnia and Herzegovina', 'Bosnia and Herzegovina', 'BIH', 70, 'yes', '387', 'EU'),
(31, 'BR', 'Brazil', 'Federative Republic of Brazil', 'BRA', 76, 'yes', '55', 'SA'),
(34, 'BG', 'Bulgaria', 'Republic of Bulgaria', 'BGR', 100, 'yes', '359', 'EU'),
(37, 'KH', 'Cambodia', 'Kingdom of Cambodia', 'KHM', 116, 'yes', '855', 'AS'),
(39, 'CA', 'Canada', 'Canada', 'CAN', 124, 'yes', '1', 'NA'),
(44, 'CL', 'Chile', 'Republic of Chile', 'CHL', 152, 'yes', '56', 'SA'),
(45, 'CN', 'China', 'People''s Republic of China', 'CHN', 156, 'yes', '86', 'AS'),
(48, 'CO', 'Colombia', 'Republic of Colombia', 'COL', 170, 'yes', '57', 'SA'),
(52, 'CR', 'Costa Rica', 'Republic of Costa Rica', 'CRI', 188, 'yes', '506', 'NA'),
(54, 'HR', 'Croatia', 'Republic of Croatia', 'HRV', 191, 'yes', '385', 'EU'),
(56, 'CY', 'Cyprus', 'Republic of Cyprus', 'CYP', 196, 'yes', '357', 'AS'),
(57, 'CZ', 'Czech Republic', 'Czech Republic', 'CZE', 203, 'yes', '420', 'EU'),
(59, 'DK', 'Denmark', 'Kingdom of Denmark', 'DNK', 208, 'yes', '45', 'EU'),
(63, 'EC', 'Ecuador', 'Republic of Ecuador', 'ECU', 218, 'yes', '593', 'SA'),
(64, 'EG', 'Egypt', 'Arab Republic of Egypt', 'EGY', 818, 'yes', '20', 'AF'),
(65, 'SV', 'El Salvador', 'Republic of El Salvador', 'SLV', 222, 'yes', '503', 'NA'),
(68, 'EE', 'Estonia', 'Republic of Estonia', 'EST', 233, 'yes', '372', 'EU'),
(70, 'FK', 'Falkland Islands (Malvinas)', 'The Falkland Islands (Malvinas)', 'FLK', 238, 'no', '500', 'SA'),
(73, 'FI', 'Finland', 'Republic of Finland', 'FIN', 246, 'yes', '358', 'EU'),
(74, 'FR', 'France', 'French Republic', 'FRA', 250, 'yes', '33', 'EU'),
(80, 'GE', 'Georgia', 'Georgia', 'GEO', 268, 'yes', '995', 'AS'),
(81, 'DE', 'Germany', 'Federal Republic of Germany', 'DEU', 276, 'yes', '49', 'EU'),
(83, 'GI', 'Gibraltar', 'Gibraltar', 'GIB', 292, 'no', '350', 'EU'),
(84, 'GR', 'Greece', 'Hellenic Republic', 'GRC', 300, 'yes', '30', 'EU'),
(85, 'GL', 'Greenland', 'Greenland', 'GRL', 304, 'no', '299', 'NA'),
(86, 'GD', 'Grenada', 'Grenada', 'GRD', 308, 'yes', '1473', 'NA'),
(95, 'HN', 'Honduras', 'Republic of Honduras', 'HND', 340, 'yes', '504', 'NA'),
(96, 'HK', 'Hong Kong', 'Hong Kong', 'HKG', 344, 'no', '852', 'AS'),
(97, 'HU', 'Hungary', 'Republic of Hungary', 'HUN', 348, 'yes', '36', 'EU'),
(98, 'IS', 'Iceland', 'Republic of Iceland', 'ISL', 352, 'yes', '354', 'EU'),
(99, 'IN', 'India', 'Republic of India', 'IND', 356, 'yes', '91', 'AS'),
(100, 'ID', 'Indonesia', 'Republic of Indonesia', 'IDN', 360, 'yes', '62', 'AS'),
(103, 'IE', 'Ireland', 'Ireland', 'IRL', 372, 'yes', '353', 'EU'),
(105, 'IL', 'Israel', 'State of Israel', 'ISR', 376, 'yes', '972', 'AS'),
(106, 'IT', 'Italy', 'Italian Republic', 'ITA', 380, 'yes', '39', 'EU'),
(108, 'JP', 'Japan', 'Japan', 'JPN', 392, 'yes', '81', 'AS'),
(110, 'JO', 'Jordan', 'Hashemite Kingdom of Jordan', 'JOR', 400, 'yes', '962', 'AS'),
(111, 'KZ', 'Kazakhstan', 'Republic of Kazakhstan', 'KAZ', 398, 'yes', '7', 'AS'),
(114, 'KW', 'Kuwait', 'State of Kuwait', 'KWT', 414, 'yes', '965', 'AS'),
(115, 'KG', 'Kyrgyzstan', 'Kyrgyz Republic', 'KGZ', 417, 'yes', '996', 'AS'),
(117, 'LV', 'Latvia', 'Republic of Latvia', 'LVA', 428, 'yes', '371', 'EU'),
(122, 'LI', 'Liechtenstein', 'Principality of Liechtenstein', 'LIE', 438, 'yes', '423', 'EU'),
(123, 'LT', 'Lithuania', 'Republic of Lithuania', 'LTU', 440, 'yes', '370', 'EU'),
(124, 'LU', 'Luxembourg', 'Grand Duchy of Luxembourg', 'LUX', 442, 'yes', '352', 'EU'),
(125, 'MO', 'Macao', 'The Macao Special Administrative Region', 'MAC', 446, 'no', '853', 'AS'),
(126, 'MK', 'Macedonia', 'The Former Yugoslav Republic of Macedonia', 'MKD', 807, 'yes', '389', 'EU'),
(129, 'MY', 'Malaysia', 'Malaysia', 'MYS', 458, 'yes', '60', 'AS'),
(132, 'MT', 'Malta', 'Republic of Malta', 'MLT', 470, 'yes', '356', 'EU'),
(138, 'MX', 'Mexico', 'United Mexican States', 'MEX', 484, 'yes', '52', 'NA'),
(139, 'MR', 'Mauritania', 'Islamic Republic of Mauritania', 'MRT', 478, 'yes', '222', 'AF'),
(140, 'MD', 'Moldava', 'Republic of Moldova', 'MDA', 498, 'yes', '373', 'EU'),
(141, 'MC', 'Monaco', 'Principality of Monaco', 'MCO', 492, 'yes', '377', 'EU'),
(143, 'ME', 'Montenegro', 'Montenegro', 'MNE', 499, 'yes', '382', 'EU'),
(145, 'MA', 'Morocco', 'Kingdom of Morocco', 'MAR', 504, 'yes', '212', 'AF'),
(151, 'MM', 'Myanmar', 'Republic of the Union of Myanmar', 'MMR', 104, 'yes', '95', 'AS'),
(152, 'NL', 'Netherlands', 'Kingdom of the Netherlands', 'NLD', 528, 'yes', '31', 'EU'),
(154, 'NZ', 'New Zealand', 'New Zealand', 'NZL', 554, 'yes', '64', 'OC'),
(162, 'NO', 'Norway', 'Kingdom of Norway', 'NOR', 578, 'yes', '47', 'EU'),
(163, 'OM', 'Oman', 'Sultanate of Oman', 'OMN', 512, 'yes', '968', 'AS'),
(167, 'PA', 'Panama', 'Republic of Panama', 'PAN', 591, 'yes', '507', 'NA'),
(171, 'PH', 'Phillipines', 'Republic of the Philippines', 'PHL', 608, 'yes', '63', 'AS'),
(172, 'PE', 'Peru', 'Republic of Peru', 'PER', 604, 'yes', '51', 'SA'),
(173, 'PL', 'Poland', 'Republic of Poland', 'POL', 616, 'yes', '48', 'EU'),
(174, 'PT', 'Portugal', 'Portuguese Republic', 'PRT', 620, 'yes', '351', 'EU'),
(176, 'QA', 'Qatar', 'State of Qatar', 'QAT', 634, 'yes', '974', 'AS'),
(178, 'RO', 'Romania', 'Romania', 'ROU', 642, 'yes', '40', 'EU'),
(179, 'RU', 'Russia', 'Russian Federation', 'RUS', 643, 'yes', '7', 'EU'),
(191, 'SA', 'Saudi Arabia', 'Kingdom of Saudi Arabia', 'SAU', 682, 'yes', '966', 'AS'),
(193, 'RS', 'Serbia', 'Republic of Serbia', 'SRB', 688, 'yes', '381', 'EU'),
(196, 'SG', 'Singapore', 'Republic of Singapore', 'SGP', 702, 'yes', '65', 'AS'),
(197, 'SK', 'Slovakia', 'Slovak Republic', 'SVK', 703, 'yes', '421', 'EU'),
(198, 'SI', 'Slovenia', 'Republic of Slovenia', 'SVN', 705, 'yes', '386', 'EU'),
(201, 'ZA', 'South Africa', 'Republic of South Africa', 'ZAF', 710, 'yes', '27', 'AF'),
(203, 'KR', 'South Korea', 'Republic of Korea', 'KOR', 410, 'yes', '82', 'AS'),
(204, 'ES', 'Spain', 'Kingdom of Spain', 'ESP', 724, 'yes', '34', 'EU'),
(209, 'SZ', 'Swaziland', 'Kingdom of Swaziland', 'SWZ', 748, 'yes', '268', 'AF'),
(210, 'SE', 'Sweden', 'Kingdom of Sweden', 'SWE', 752, 'yes', '46', 'EU'),
(211, 'CH', 'Switzerland', 'Swiss Confederation', 'CHE', 756, 'yes', '41', 'EU'),
(213, 'TW', 'Taiwan', 'Taiwan, Province of China', 'TWN', 158, 'no', '886', 'AS'),
(214, 'TJ', 'Tajikistan', 'Republic of Tajikistan', 'TJK', 762, 'yes', '992', 'AS'),
(216, 'TH', 'Thailand', 'Kingdom of Thailand', 'THA', 764, 'yes', '66', 'AS'),
(222, 'TN', 'Tunisia', 'Republic of Tunisia', 'TUN', 788, 'yes', '216', 'AF'),
(223, 'TR', 'Turkey', 'Republic of Turkey', 'TUR', 792, 'yes', '90', 'AS'),
(224, 'TM', 'Turkmenistan', 'Turkmenistan', 'TKM', 795, 'yes', '993', 'AS'),
(228, 'UA', 'Ukraine', 'Ukraine', 'UKR', 804, 'yes', '380', 'EU'),
(229, 'AE', 'United Arab Emirates', 'United Arab Emirates', 'ARE', 784, 'yes', '971', 'AS'),
(230, 'GB', 'United Kingdom', 'United Kingdom of Great Britain and Nothern Ireland', 'GBR', 826, 'yes', '44', 'EU'),
(232, 'US', 'United States', 'United States of America', 'USA', 840, 'yes', '1', 'NA'),
(233, 'UY', 'Uruguay', 'Eastern Republic of Uruguay', 'URY', 858, 'yes', '598', 'SA'),
(234, 'UZ', 'Uzbekistan', 'Republic of Uzbekistan', 'UZB', 860, 'yes', '998', 'AS'),
(237, 'VE', 'Venezuela', 'Bolivarian Republic of Venezuela', 'VEN', 862, 'yes', '58', 'SA'),
(238, 'VN', 'Vietnam', 'Socialist Republic of Vietnam', 'VNM', 704, 'yes', '84', 'AS'),
(241, 'NG', 'Nigeria', 'Nigeria', 'NGA', NULL, 'yes', '234 ', 'AF');