Country Table for MySQL

create_country_table_mysql.sql

CREATE TABLE IF NOT EXISTS `country` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(100) NOT NULL,
    `iso2` char(2) NOT NULL,
    `iso3` char(3) DEFAULT NULL,
    `countrycodenumeric` int(5) NOT NULL,
    `countrycode` nvarchar(5) NOT NULL,
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `country` (`id`, `name`, `iso2`, `iso3`, `countrycodenumeric`, `countrycode`) VALUES
(1, 'Afghanistan', 'AF', 'AFG', 93, '+93'),
(2, 'Aland Islands', 'AX', 'ALA', 358, '+358'),
(3, 'Albania', 'AL', 'ALB', 355, '+355'),
(4, 'Algeria', 'DZ', 'DZA', 213, '+213'),
(5, 'American Samoa', 'AS', 'ASM', 1684, '+1684'),
(6, 'Andorra', 'AD', 'AND', 376, '+376'),
(7, 'Angola', 'AO', 'AGO', 244, '+244'),
(8, 'Anguilla', 'AI', 'AIA', 1264, '+1264'),
(9, 'Antarctica', 'AQ', 'ATA', 672, '+672'),
(10, 'Antigua and Barbuda', 'AG', 'ATG', 1268, '+1268'),
(11, 'Argentina', 'AR', 'ARG', 54, '+54'),
(12, 'Armenia', 'AM', 'ARM', 374, '+374'),
(13, 'Aruba', 'AW', 'ABW', 297, '+297'),
(14, 'Australia', 'AU', 'AUS', 61, '+61'),
(15, 'Austria', 'AT', 'AUT', 43, '+43'),
(16, 'Azerbaijan', 'AZ', 'AZE', 994, '+994'),
(17, 'Bahamas', 'BS', 'BHS', 1242, '+1242'),
(18, 'Bahrain', 'BH', 'BHR', 973, '+973'),
(19, 'Bangladesh', 'BD', 'BGD', 880, '+880'),
(20, 'Barbados', 'BB', 'BRB', 1246, '+1246'),
(21, 'Belarus', 'BY', 'BLR', 375, '+375'),
(22, 'Belgium', 'BE', 'BEL', 32, '+32'),
(23, 'Belize', 'BZ', 'BLZ', 501, '+501'),
(24, 'Benin', 'BJ', 'BEN', 229, '+229'),
(25, 'Bermuda', 'BM', 'BMU', 1441, '+1441'),
(26, 'Bhutan', 'BT', 'BTN', 975, '+975'),
(27, 'Bolivia', 'BO', 'BOL', 591, '+591'),
(28, 'Bonaire, Sint Eustatius and Saba', 'BQ', 'BES', 599, '+599'),
(29, 'Bosnia and Herzegovina', 'BA', 'BIH', 387, '+387'),
(30, 'Botswana', 'BW', 'BWA', 267, '+267'),
(31, 'Bouvet Island', 'BV', 'BVT', 55, '+55'),
(32, 'Brazil', 'BR', 'BRA', 55, '+55'),
(33, 'British Indian Ocean Territory', 'IO', 'IOT', 246, '+246'),
(34, 'Brunei Darussalam', 'BN', 'BRN', 673, '+673'),
(35, 'Bulgaria', 'BG', 'BGR', 359, '+359'),
(36, 'Burkina Faso', 'BF', 'BFA', 226, '+226'),
(37, 'Burundi', 'BI', 'BDI', 257, '+257'),
(38, 'Cambodia', 'KH', 'KHM', 855, '+855'),
(39, 'Cameroon', 'CM', 'CMR', 237, '+237'),
(40, 'Canada', 'CA', 'CAN', 1, '+1'),
(41, 'Cape Verde', 'CV', 'CPV', 238, '+238'),
(42, 'Cayman Islands', 'KY', 'CYM', 1345, '+1345'),
(43, 'Central African Republic', 'CF', 'CAF', 236, '+236'),
(44, 'Chad', 'TD', 'TCD', 235, '+235'),
(45, 'Chile', 'CL', 'CHL', 56, '+56'),
(46, 'China', 'CN', 'CHN', 86, '+86'),
(47, 'Christmas Island', 'CX', 'CXR', 61, '+61'),
(48, 'Cocos (Keeling) Islands', 'CC', 'CCK', 672, '+672'),
(49, 'Colombia', 'CO', 'COL', 57, '+57'),
(50, 'Comoros', 'KM', 'COM', 269, '+269'),
(51, 'Congo', 'CG', 'COG', 242, '+242'),
(52, 'Congo, Democratic Republic of the Congo', 'CD', 'COD', 242, '+242'),
(53, 'Cook Islands', 'CK', 'COK', 682, '+682'),
(54, 'Costa Rica', 'CR', 'CRI', 506, '+506'),
(55, 'Cote D''Ivoire', 'CI', 'CIV', 225, '+225'),
(56, 'Croatia', 'HR', 'HRV', 385, '+385'),
(57, 'Cuba', 'CU', 'CUB', 53, '+53'),
(58, 'Curacao', 'CW', 'CUW', 599, '+599'),
(59, 'Cyprus', 'CY', 'CYP', 357, '+357'),
(60, 'Czech Republic', 'CZ', 'CZE', 420, '+420'),
(61, 'Denmark', 'DK', 'DNK', 45, '+45'),
(62, 'Djibouti', 'DJ', 'DJI', 253, '+253'),
(63, 'Dominica', 'DM', 'DMA', 1767, '+1767'),
(64, 'Dominican Republic', 'DO', 'DOM', 1809, '+1809'),
(65, 'Ecuador', 'EC', 'ECU', 593, '+593'),
(66, 'Egypt', 'EG', 'EGY', 20, '+20'),
(67, 'El Salvador', 'SV', 'SLV', 503, '+503'),
(68, 'Equatorial Guinea', 'GQ', 'GNQ', 240, '+240'),
(69, 'Eritrea', 'ER', 'ERI', 291, '+291'),
(70, 'Estonia', 'EE', 'EST', 372, '+372'),
(71, 'Ethiopia', 'ET', 'ETH', 251, '+251'),
(72, 'Falkland Islands (Malvinas)', 'FK', 'FLK', 500, '+500'),
(73, 'Faroe Islands', 'FO', 'FRO', 298, '+298'),
(74, 'Fiji', 'FJ', 'FJI', 679, '+679'),
(75, 'Finland', 'FI', 'FIN', 358, '+358'),
(76, 'France', 'FR', 'FRA', 33, '+33'),
(77, 'French Guiana', 'GF', 'GUF', 594, '+594'),
(78, 'French Polynesia', 'PF', 'PYF', 689, '+689'),
(79, 'French Southern Territories', 'TF', 'ATF', 262, '+262'),
(80, 'Gabon', 'GA', 'GAB', 241, '+241'),
(81, 'Gambia', 'GM', 'GMB', 220, '+220'),
(82, 'Georgia', 'GE', 'GEO', 995, '+995'),
(83, 'Germany', 'DE', 'DEU', 49, '+49'),
(84, 'Ghana', 'GH', 'GHA', 233, '+233'),
(85, 'Gibraltar', 'GI', 'GIB', 350, '+350'),
(86, 'Greece', 'GR', 'GRC', 30, '+30'),
(87, 'Greenland', 'GL', 'GRL', 299, '+299'),
(88, 'Grenada', 'GD', 'GRD', 1473, '+1473'),
(89, 'Guadeloupe', 'GP', 'GLP', 590, '+590'),
(90, 'Guam', 'GU', 'GUM', 1671, '+1671'),
(91, 'Guatemala', 'GT', 'GTM', 502, '+502'),
(92, 'Guernsey', 'GG', 'GGY', 44, '+44'),
(93, 'Guinea', 'GN', 'GIN', 224, '+224'),
(94, 'Guinea-Bissau', 'GW', 'GNB', 245, '+245'),
(95, 'Guyana', 'GY', 'GUY', 592, '+592'),
(96, 'Haiti', 'HT', 'HTI', 509, '+509'),
(97, 'Heard Island and Mcdonald Islands', 'HM', 'HMD', 0, '+0'),
(98, 'Holy See (Vatican City State)', 'VA', 'VAT', 39, '+39'),
(99, 'Honduras', 'HN', 'HND', 504, '+504'),
(100, 'Hong Kong', 'HK', 'HKG', 852, '+852'),
(101, 'Hungary', 'HU', 'HUN', 36, '+36'),
(102, 'Iceland', 'IS', 'ISL', 354, '+354'),
(103, 'India', 'IN', 'IND', 91, '+91'),
(104, 'Indonesia', 'ID', 'IDN', 62, '+62'),
(105, 'Iran, Islamic Republic of', 'IR', 'IRN', 98, '+98'),
(106, 'Iraq', 'IQ', 'IRQ', 964, '+964'),
(107, 'Ireland', 'IE', 'IRL', 353, '+353'),
(108, 'Isle of Man', 'IM', 'IMN', 44, '+44'),
(109, 'Israel', 'IL', 'ISR', 972, '+972'),
(110, 'Italy', 'IT', 'ITA', 39, '+39'),
(111, 'Jamaica', 'JM', 'JAM', 1876, '+1876'),
(112, 'Japan', 'JP', 'JPN', 81, '+81'),
(113, 'Jersey', 'JE', 'JEY', 44, '+44'),
(114, 'Jordan', 'JO', 'JOR', 962, '+962'),
(115, 'Kazakhstan', 'KZ', 'KAZ', 7, '+7'),
(116, 'Kenya', 'KE', 'KEN', 254, '+254'),
(117, 'Kiribati', 'KI', 'KIR', 686, '+686'),
(118, 'Korea, Democratic People''s Republic of', 'KP', 'PRK', 850, '+850'),
(119, 'Korea, Republic of', 'KR', 'KOR', 82, '+82'),
(120, 'Kosovo', 'XK', 'XKX', 383, '+383'),
(121, 'Kuwait', 'KW', 'KWT', 965, '+965'),
(122, 'Kyrgyzstan', 'KG', 'KGZ', 996, '+996'),
(123, 'Lao People''s Democratic Republic', 'LA', 'LAO', 856, '+856'),
(124, 'Latvia', 'LV', 'LVA', 371, '+371'),
(125, 'Lebanon', 'LB', 'LBN', 961, '+961'),
(126, 'Lesotho', 'LS', 'LSO', 266, '+266'),
(127, 'Liberia', 'LR', 'LBR', 231, '+231'),
(128, 'Libyan Arab Jamahiriya', 'LY', 'LBY', 218, '+218'),
(129, 'Liechtenstein', 'LI', 'LIE', 423, '+423'),
(130, 'Lithuania', 'LT', 'LTU', 370, '+370'),
(131, 'Luxembourg', 'LU', 'LUX', 352, '+352'),
(132, 'Macao', 'MO', 'MAC', 853, '+853'),
(133, 'Macedonia, the Former Yugoslav Republic of', 'MK', 'MKD', 389, '+389'),
(134, 'Madagascar', 'MG', 'MDG', 261, '+261'),
(135, 'Malawi', 'MW', 'MWI', 265, '+265'),
(136, 'Malaysia', 'MY', 'MYS', 60, '+60'),
(137, 'Maldives', 'MV', 'MDV', 960, '+960'),
(138, 'Mali', 'ML', 'MLI', 223, '+223'),
(139, 'Malta', 'MT', 'MLT', 356, '+356'),
(140, 'Marshall Islands', 'MH', 'MHL', 692, '+692'),
(141, 'Martinique', 'MQ', 'MTQ', 596, '+596'),
(142, 'Mauritania', 'MR', 'MRT', 222, '+222'),
(143, 'Mauritius', 'MU', 'MUS', 230, '+230'),
(144, 'Mayotte', 'YT', 'MYT', 262, '+262'),
(145, 'Mexico', 'MX', 'MEX', 52, '+52'),
(146, 'Micronesia, Federated States of', 'FM', 'FSM', 691, '+691'),
(147, 'Moldova, Republic of', 'MD', 'MDA', 373, '+373'),
(148, 'Monaco', 'MC', 'MCO', 377, '+377'),
(149, 'Mongolia', 'MN', 'MNG', 976, '+976'),
(150, 'Montenegro', 'ME', 'MNE', 382, '+382'),
(151, 'Montserrat', 'MS', 'MSR', 1664, '+1664'),
(152, 'Morocco', 'MA', 'MAR', 212, '+212'),
(153, 'Mozambique', 'MZ', 'MOZ', 258, '+258'),
(154, 'Myanmar', 'MM', 'MMR', 95, '+95'),
(155, 'Namibia', 'NA', 'NAM', 264, '+264'),
(156, 'Nauru', 'NR', 'NRU', 674, '+674'),
(157, 'Nepal', 'NP', 'NPL', 977, '+977'),
(158, 'Netherlands', 'NL', 'NLD', 31, '+31'),
(159, 'Netherlands Antilles', 'AN', 'ANT', 599, '+599'),
(160, 'New Caledonia', 'NC', 'NCL', 687, '+687'),
(161, 'New Zealand', 'NZ', 'NZL', 64, '+64'),
(162, 'Nicaragua', 'NI', 'NIC', 505, '+505'),
(163, 'Niger', 'NE', 'NER', 227, '+227'),
(164, 'Nigeria', 'NG', 'NGA', 234, '+234'),
(165, 'Niue', 'NU', 'NIU', 683, '+683'),
(166, 'Norfolk Island', 'NF', 'NFK', 672, '+672'),
(167, 'Northern Mariana Islands', 'MP', 'MNP', 1670, '+1670'),
(168, 'Norway', 'NO', 'NOR', 47, '+47'),
(169, 'Oman', 'OM', 'OMN', 968, '+968'),
(170, 'Pakistan', 'PK', 'PAK', 92, '+92'),
(171, 'Palau', 'PW', 'PLW', 680, '+680'),
(172, 'Palestinian Territory, Occupied', 'PS', 'PSE', 970, '+970'),
(173, 'Panama', 'PA', 'PAN', 507, '+507'),
(174, 'Papua New Guinea', 'PG', 'PNG', 675, '+675'),
(175, 'Paraguay', 'PY', 'PRY', 595, '+595'),
(176, 'Peru', 'PE', 'PER', 51, '+51'),
(177, 'Philippines', 'PH', 'PHL', 63, '+63'),
(178, 'Pitcairn', 'PN', 'PCN', 64, '+64'),
(179, 'Poland', 'PL', 'POL', 48, '+48'),
(180, 'Portugal', 'PT', 'PRT', 351, '+351'),
(181, 'Puerto Rico', 'PR', 'PRI', 1787, '+1787'),
(182, 'Qatar', 'QA', 'QAT', 974, '+974'),
(183, 'Reunion', 'RE', 'REU', 262, '+262'),
(184, 'Romania', 'RO', 'ROM', 40, '+40'),
(185, 'Russian Federation', 'RU', 'RUS', 7, '+7'),
(186, 'Rwanda', 'RW', 'RWA', 250, '+250'),
(187, 'Saint Barthelemy', 'BL', 'BLM', 590, '+590'),
(188, 'Saint Helena', 'SH', 'SHN', 290, '+290'),
(189, 'Saint Kitts and Nevis', 'KN', 'KNA', 1869, '+1869'),
(190, 'Saint Lucia', 'LC', 'LCA', 1758, '+1758'),
(191, 'Saint Martin', 'MF', 'MAF', 590, '+590'),
(192, 'Saint Pierre and Miquelon', 'PM', 'SPM', 508, '+508'),
(193, 'Saint Vincent and the Grenadines', 'VC', 'VCT', 1784, '+1784'),
(194, 'Samoa', 'WS', 'WSM', 684, '+684'),
(195, 'San Marino', 'SM', 'SMR', 378, '+378'),
(196, 'Sao Tome and Principe', 'ST', 'STP', 239, '+239'),
(197, 'Saudi Arabia', 'SA', 'SAU', 966, '+966'),
(198, 'Senegal', 'SN', 'SEN', 221, '+221'),
(199, 'Serbia', 'RS', 'SRB', 381, '+381'),
(200, 'Serbia and Montenegro', 'CS', 'SCG', 381, '+381'),
(201, 'Seychelles', 'SC', 'SYC', 248, '+248'),
(202, 'Sierra Leone', 'SL', 'SLE', 232, '+232'),
(203, 'Singapore', 'SG', 'SGP', 65, '+65'),
(204, 'Sint Maarten', 'SX', 'SXM', 721, '+721'),
(205, 'Slovakia', 'SK', 'SVK', 421, '+421'),
(206, 'Slovenia', 'SI', 'SVN', 386, '+386'),
(207, 'Solomon Islands', 'SB', 'SLB', 677, '+677'),
(208, 'Somalia', 'SO', 'SOM', 252, '+252'),
(209, 'South Africa', 'ZA', 'ZAF', 27, '+27'),
(210, 'South Georgia and the South Sandwich Islands', 'GS', 'SGS', 500, '+500'),
(211, 'South Sudan', 'SS', 'SSD', 211, '+211'),
(212, 'Spain', 'ES', 'ESP', 34, '+34'),
(213, 'Sri Lanka', 'LK', 'LKA', 94, '+94'),
(214, 'Sudan', 'SD', 'SDN', 249, '+249'),
(215, 'Suriname', 'SR', 'SUR', 597, '+597'),
(216, 'Svalbard and Jan Mayen', 'SJ', 'SJM', 47, '+47'),
(217, 'Swaziland', 'SZ', 'SWZ', 268, '+268'),
(218, 'Sweden', 'SE', 'SWE', 46, '+46'),
(219, 'Switzerland', 'CH', 'CHE', 41, '+41'),
(220, 'Syrian Arab Republic', 'SY', 'SYR', 963, '+963'),
(221, 'Taiwan, Province of China', 'TW', 'TWN', 886, '+886'),
(222, 'Tajikistan', 'TJ', 'TJK', 992, '+992'),
(223, 'Tanzania, United Republic of', 'TZ', 'TZA', 255, '+255'),
(224, 'Thailand', 'TH', 'THA', 66, '+66'),
(225, 'Timor-Leste', 'TL', 'TLS', 670, '+670'),
(226, 'Togo', 'TG', 'TGO', 228, '+228'),
(227, 'Tokelau', 'TK', 'TKL', 690, '+690'),
(228, 'Tonga', 'TO', 'TON', 676, '+676'),
(229, 'Trinidad and Tobago', 'TT', 'TTO', 1868, '+1868'),
(230, 'Tunisia', 'TN', 'TUN', 216, '+216'),
(231, 'Turkey', 'TR', 'TUR', 90, '+90'),
(232, 'Turkmenistan', 'TM', 'TKM', 7370, '+7370'),
(233, 'Turks and Caicos Islands', 'TC', 'TCA', 1649, '+1649'),
(234, 'Tuvalu', 'TV', 'TUV', 688, '+688'),
(235, 'Uganda', 'UG', 'UGA', 256, '+256'),
(236, 'Ukraine', 'UA', 'UKR', 380, '+380'),
(237, 'United Arab Emirates', 'AE', 'ARE', 971, '+971'),
(238, 'United Kingdom', 'GB', 'GBR', 44, '+44'),
(239, 'United States', 'US', 'USA', 1, '+1'),
(240, 'United States Minor Outlying Islands', 'UM', 'UMI', 1, '+1'),
(241, 'Uruguay', 'UY', 'URY', 598, '+598'),
(242, 'Uzbekistan', 'UZ', 'UZB', 998, '+998'),
(243, 'Vanuatu', 'VU', 'VUT', 678, '+678'),
(244, 'Venezuela', 'VE', 'VEN', 58, '+58'),
(245, 'Viet Nam', 'VN', 'VNM', 84, '+84'),
(246, 'Virgin Islands, British', 'VG', 'VGB', 1284, '+1284'),
(247, 'Virgin Islands, U.S.', 'VI', 'VIR', 1340, '+1340'),
(248, 'Wallis and Futuna', 'WF', 'WLF', 681, '+681'),
(249, 'Western Sahara', 'EH', 'ESH', 212, '+212'),
(250, 'Yemen', 'YE', 'YEM', 967, '+967'),
(251, 'Zambia', 'ZM', 'ZMB', 260, '+260'),
(252, 'Zimbabwe', 'ZW', 'ZWE', 263, '+263');