-- Thanks to http://peric.github.io/GetCountries/

CREATE TABLE IF NOT EXISTS `countries` (
    `idCountry` int(5) NOT NULL AUTO_INCREMENT,
    `countryCode` char(2) NOT NULL DEFAULT '',
    `countryName` varchar(45) NOT NULL DEFAULT '',
    `population` varchar(20) DEFAULT NULL,
    `capital` varchar(30) DEFAULT NULL,
    `continentName` varchar(15) DEFAULT NULL,
    PRIMARY KEY (`idCountry`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=0;

INSERT INTO `countries` (`countryCode`, `countryName`, `population`, `capital`, `continentName`) VALUES
('AD', 'Andorra', '84000', 'Andorra la Vella', 'Europe'),
('AE', 'United Arab Emirates', '4975593', 'Abu Dhabi', 'Asia'),
('AF', 'Afghanistan', '29121286', 'Kabul', 'Asia'),
('AG', 'Antigua and Barbuda', '86754', 'St. John\'s', 'North America'),
('AI', 'Anguilla', '13254', 'The Valley', 'North America'),
('AL', 'Albania', '2986952', 'Tirana', 'Europe'),
('AM', 'Armenia', '2968000', 'Yerevan', 'Asia'),
('AO', 'Angola', '13068161', 'Luanda', 'Africa'),
('AR', 'Argentina', '41343201', 'Buenos Aires', 'South America'),
('AS', 'American Samoa', '57881', 'Pago Pago', 'Oceania'),
('AT', 'Austria', '8205000', 'Vienna', 'Europe'),
('AU', 'Australia', '21515754', 'Canberra', 'Oceania'),
('AW', 'Aruba', '71566', 'Oranjestad', 'North America'),
('AX', 'Åland', '26711', 'Mariehamn', 'Europe'),
('AZ', 'Azerbaijan', '8303512', 'Baku', 'Asia'),
('BA', 'Bosnia and Herzegovina', '4590000', 'Sarajevo', 'Europe'),
('BB', 'Barbados', '285653', 'Bridgetown', 'North America'),
('BD', 'Bangladesh', '156118464', 'Dhaka', 'Asia'),
('BE', 'Belgium', '10403000', 'Brussels', 'Europe'),
('BF', 'Burkina Faso', '16241811', 'Ouagadougou', 'Africa'),
('BG', 'Bulgaria', '7148785', 'Sofia', 'Europe'),
('BH', 'Bahrain', '738004', 'Manama', 'Asia'),
('BI', 'Burundi', '9863117', 'Bujumbura', 'Africa'),
('BJ', 'Benin', '9056010', 'Porto-Novo', 'Africa'),
('BM', 'Bermuda', '65365', 'Hamilton', 'North America'),
('BN', 'Brunei', '395027', 'Bandar Seri Begawan', 'Asia'),
('BO', 'Bolivia', '9947418', 'Sucre', 'South America'),
('BR', 'Brazil', '201103330', 'Brasília', 'South America'),
('BS', 'Bahamas', '301790', 'Nassau', 'North America'),
('BT', 'Bhutan', '699847', 'Thimphu', 'Asia'),
('BV', 'Bouvet Island', '0', '', 'Antarctica'),
('BW', 'Botswana', '2029307', 'Gaborone', 'Africa'),
('BY', 'Belarus', '9685000', 'Minsk', 'Europe'),
('BZ', 'Belize', '314522', 'Belmopan', 'North America'),
('CA', 'Canada', '33679000', 'Ottawa', 'North America'),
('CC', 'Cocos [Keeling] Islands', '628', 'West Island', 'Asia'),
('CD', 'Democratic Republic of the Congo', '70916439', 'Kinshasa', 'Africa'),
('CF', 'Central African Republic', '4844927', 'Bangui', 'Africa'),
('CG', 'Republic of the Congo', '3039126', 'Brazzaville', 'Africa'),
('CH', 'Switzerland', '7581000', 'Berne', 'Europe'),
('CI', 'Ivory Coast', '21058798', 'Yamoussoukro', 'Africa'),
('CK', 'Cook Islands', '21388', 'Avarua', 'Oceania'),
('CL', 'Chile', '16746491', 'Santiago', 'South America'),
('CM', 'Cameroon', '19294149', 'Yaoundé', 'Africa'),
('CN', 'China', '1330044000', 'Beijing', 'Asia'),
('CO', 'Colombia', '44205293', 'Bogotá', 'South America'),
('CR', 'Costa Rica', '4516220', 'San José', 'North America'),
('CU', 'Cuba', '11423000', 'Havana', 'North America'),
('CV', 'Cape Verde', '508659', 'Praia', 'Africa'),
('CX', 'Christmas Island', '1500', 'The Settlement', 'Asia'),
('CY', 'Cyprus', '1102677', 'Nicosia', 'Europe'),
('CZ', 'Czechia', '10476000', 'Prague', 'Europe'),
('DE', 'Germany', '81802257', 'Berlin', 'Europe'),
('DJ', 'Djibouti', '740528', 'Djibouti', 'Africa'),
('DK', 'Denmark', '5484000', 'Copenhagen', 'Europe'),
('DM', 'Dominica', '72813', 'Roseau', 'North America'),
('DO', 'Dominican Republic', '9823821', 'Santo Domingo', 'North America'),
('DZ', 'Algeria', '34586184', 'Algiers', 'Africa'),
('EC', 'Ecuador', '14790608', 'Quito', 'South America'),
('EE', 'Estonia', '1291170', 'Tallinn', 'Europe'),
('EG', 'Egypt', '80471869', 'Cairo', 'Africa'),
('EH', 'Western Sahara', '273008', 'El Aaiún', 'Africa'),
('ER', 'Eritrea', '5792984', 'Asmara', 'Africa'),
('ES', 'Spain', '46505963', 'Madrid', 'Europe'),
('ET', 'Ethiopia', '88013491', 'Addis Ababa', 'Africa'),
('FI', 'Finland', '5244000', 'Helsinki', 'Europe'),
('FJ', 'Fiji', '875983', 'Suva', 'Oceania'),
('FK', 'Falkland Islands', '2638', 'Stanley', 'South America'),
('FM', 'Micronesia', '107708', 'Palikir', 'Oceania'),
('FO', 'Faroe Islands', '48228', 'Tórshavn', 'Europe'),
('FR', 'France', '64768389', 'Paris', 'Europe'),
('GA', 'Gabon', '1545255', 'Libreville', 'Africa'),
('GB', 'United Kingdom', '62348447', 'London', 'Europe'),
('GD', 'Grenada', '107818', 'St. George\'s', 'North America'),
('GE', 'Georgia', '4630000', 'Tbilisi', 'Asia'),
('GF', 'French Guiana', '195506', 'Cayenne', 'South America'),
('GH', 'Ghana', '24339838', 'Accra', 'Africa'),
('GI', 'Gibraltar', '27884', 'Gibraltar', 'Europe'),
('GL', 'Greenland', '56375', 'Nuuk', 'North America'),
('GM', 'Gambia', '1593256', 'Banjul', 'Africa'),
('GN', 'Guinea', '10324025', 'Conakry', 'Africa'),
('GP', 'Guadeloupe', '443000', 'Basse-Terre', 'North America'),
('GQ', 'Equatorial Guinea', '1014999', 'Malabo', 'Africa'),
('GR', 'Greece', '11000000', 'Athens', 'Europe'),
('GS', 'South Georgia and the South Sandwich Islands', '30', 'Grytviken', 'Antarctica'),
('GT', 'Guatemala', '13550440', 'Guatemala City', 'North America'),
('GU', 'Guam', '159358', 'Hagåtña', 'Oceania'),
('GW', 'Guinea-Bissau', '1565126', 'Bissau', 'Africa'),
('GY', 'Guyana', '748486', 'Georgetown', 'South America'),
('HK', 'Hong Kong', '6898686', 'Hong Kong', 'Asia'),
('HM', 'Heard Island and McDonald Islands', '0', '', 'Antarctica'),
('HN', 'Honduras', '7989415', 'Tegucigalpa', 'North America'),
('HR', 'Croatia', '4491000', 'Zagreb', 'Europe'),
('HT', 'Haiti', '9648924', 'Port-au-Prince', 'North America'),
('HU', 'Hungary', '9982000', 'Budapest', 'Europe'),
('ID', 'Indonesia', '242968342', 'Jakarta', 'Asia'),
('IE', 'Ireland', '4622917', 'Dublin', 'Europe'),
('IL', 'Israel', '7353985', '', 'Asia'),
('IN', 'India', '1173108018', 'New Delhi', 'Asia'),
('IO', 'British Indian Ocean Territory', '4000', '', 'Asia'),
('IQ', 'Iraq', '29671605', 'Baghdad', 'Asia'),
('IR', 'Iran', '76923300', 'Tehran', 'Asia'),
('IS', 'Iceland', '308910', 'Reykjavik', 'Europe'),
('IT', 'Italy', '60340328', 'Rome', 'Europe'),
('JM', 'Jamaica', '2847232', 'Kingston', 'North America'),
('JO', 'Jordan', '6407085', 'Amman', 'Asia'),
('JP', 'Japan', '127288000', 'Tokyo', 'Asia'),
('KE', 'Kenya', '40046566', 'Nairobi', 'Africa'),
('KG', 'Kyrgyzstan', '5508626', 'Bishkek', 'Asia'),
('KH', 'Cambodia', '14453680', 'Phnom Penh', 'Asia'),
('KI', 'Kiribati', '92533', 'Tarawa', 'Oceania'),
('KM', 'Comoros', '773407', 'Moroni', 'Africa'),
('KN', 'Saint Kitts and Nevis', '51134', 'Basseterre', 'North America'),
('KP', 'North Korea', '22912177', 'Pyongyang', 'Asia'),
('KR', 'South Korea', '48422644', 'Seoul', 'Asia'),
('KW', 'Kuwait', '2789132', 'Kuwait City', 'Asia'),
('KY', 'Cayman Islands', '44270', 'George Town', 'North America'),
('KZ', 'Kazakhstan', '15340000', 'Astana', 'Asia'),
('LA', 'Laos', '6368162', 'Vientiane', 'Asia'),
('LB', 'Lebanon', '4125247', 'Beirut', 'Asia'),
('LC', 'Saint Lucia', '160922', 'Castries', 'North America'),
('LI', 'Liechtenstein', '35000', 'Vaduz', 'Europe'),
('LK', 'Sri Lanka', '21513990', 'Colombo', 'Asia'),
('LR', 'Liberia', '3685076', 'Monrovia', 'Africa'),
('LS', 'Lesotho', '1919552', 'Maseru', 'Africa'),
('LT', 'Lithuania', '3565000', 'Vilnius', 'Europe'),
('LU', 'Luxembourg', '497538', 'Luxembourg', 'Europe'),
('LV', 'Latvia', '2217969', 'Riga', 'Europe'),
('LY', 'Libya', '6461454', 'Tripoli', 'Africa'),
('MA', 'Morocco', '31627428', 'Rabat', 'Africa'),
('MC', 'Monaco', '32965', 'Monaco', 'Europe'),
('MD', 'Moldova', '4324000', 'Chişinău', 'Europe'),
('ME', 'Montenegro', '666730', 'Podgorica', 'Europe'),
('MG', 'Madagascar', '21281844', 'Antananarivo', 'Africa'),
('MH', 'Marshall Islands', '65859', 'Majuro', 'Oceania'),
('MK', 'Macedonia', '2062294', 'Skopje', 'Europe'),
('ML', 'Mali', '13796354', 'Bamako', 'Africa'),
('MM', 'Myanmar [Burma]', '53414374', 'Nay Pyi Taw', 'Asia'),
('MN', 'Mongolia', '3086918', 'Ulan Bator', 'Asia'),
('MO', 'Macao', '449198', 'Macao', 'Asia'),
('MP', 'Northern Mariana Islands', '53883', 'Saipan', 'Oceania'),
('MQ', 'Martinique', '432900', 'Fort-de-France', 'North America'),
('MR', 'Mauritania', '3205060', 'Nouakchott', 'Africa'),
('MS', 'Montserrat', '9341', 'Plymouth', 'North America'),
('MT', 'Malta', '403000', 'Valletta', 'Europe'),
('MU', 'Mauritius', '1294104', 'Port Louis', 'Africa'),
('MV', 'Maldives', '395650', 'Malé', 'Asia'),
('MW', 'Malawi', '15447500', 'Lilongwe', 'Africa'),
('MX', 'Mexico', '112468855', 'Mexico City', 'North America'),
('MY', 'Malaysia', '28274729', 'Kuala Lumpur', 'Asia'),
('MZ', 'Mozambique', '22061451', 'Maputo', 'Africa'),
('NA', 'Namibia', '2128471', 'Windhoek', 'Africa'),
('NC', 'New Caledonia', '216494', 'Noumea', 'Oceania'),
('NE', 'Niger', '15878271', 'Niamey', 'Africa'),
('NF', 'Norfolk Island', '1828', 'Kingston', 'Oceania'),
('NG', 'Nigeria', '154000000', 'Abuja', 'Africa'),
('NI', 'Nicaragua', '5995928', 'Managua', 'North America'),
('NL', 'Netherlands', '16645000', 'Amsterdam', 'Europe'),
('NO', 'Norway', '5009150', 'Oslo', 'Europe'),
('NP', 'Nepal', '28951852', 'Kathmandu', 'Asia'),
('NR', 'Nauru', '10065', '', 'Oceania'),
('NU', 'Niue', '2166', 'Alofi', 'Oceania'),
('NZ', 'New Zealand', '4252277', 'Wellington', 'Oceania'),
('OM', 'Oman', '2967717', 'Muscat', 'Asia'),
('PA', 'Panama', '3410676', 'Panama City', 'North America'),
('PE', 'Peru', '29907003', 'Lima', 'South America'),
('PF', 'French Polynesia', '270485', 'Papeete', 'Oceania'),
('PG', 'Papua New Guinea', '6064515', 'Port Moresby', 'Oceania'),
('PH', 'Philippines', '99900177', 'Manila', 'Asia'),
('PK', 'Pakistan', '184404791', 'Islamabad', 'Asia'),
('PL', 'Poland', '38500000', 'Warsaw', 'Europe'),
('PM', 'Saint Pierre and Miquelon', '7012', 'Saint-Pierre', 'North America'),
('PN', 'Pitcairn Islands', '46', 'Adamstown', 'Oceania'),
('PR', 'Puerto Rico', '3916632', 'San Juan', 'North America'),
('PS', 'Palestine', '3800000', '', 'Asia'),
('PT', 'Portugal', '10676000', 'Lisbon', 'Europe'),
('PW', 'Palau', '19907', 'Melekeok - Palau State Capital', 'Oceania'),
('PY', 'Paraguay', '6375830', 'Asunción', 'South America'),
('QA', 'Qatar', '840926', 'Doha', 'Asia'),
('RE', 'Réunion', '776948', 'Saint-Denis', 'Africa'),
('RO', 'Romania', '21959278', 'Bucharest', 'Europe'),
('RS', 'Serbia', '7344847', 'Belgrade', 'Europe'),
('RU', 'Russia', '140702000', 'Moscow', 'Europe'),
('RW', 'Rwanda', '11055976', 'Kigali', 'Africa'),
('SA', 'Saudi Arabia', '25731776', 'Riyadh', 'Asia'),
('SB', 'Solomon Islands', '559198', 'Honiara', 'Oceania'),
('SC', 'Seychelles', '88340', 'Victoria', 'Africa'),
('SD', 'Sudan', '35000000', 'Khartoum', 'Africa'),
('SE', 'Sweden', '9555893', 'Stockholm', 'Europe'),
('SG', 'Singapore', '4701069', 'Singapore', 'Asia'),
('SH', 'Saint Helena', '7460', 'Jamestown', 'Africa'),
('SI', 'Slovenia', '2007000', 'Ljubljana', 'Europe'),
('SJ', 'Svalbard and Jan Mayen', '2550', 'Longyearbyen', 'Europe'),
('SK', 'Slovakia', '5455000', 'Bratislava', 'Europe'),
('SL', 'Sierra Leone', '5245695', 'Freetown', 'Africa'),
('SM', 'San Marino', '31477', 'San Marino', 'Europe'),
('SN', 'Senegal', '12323252', 'Dakar', 'Africa'),
('SO', 'Somalia', '10112453', 'Mogadishu', 'Africa'),
('SR', 'Suriname', '492829', 'Paramaribo', 'South America'),
('ST', 'São Tomé and Príncipe', '175808', 'São Tomé', 'Africa'),
('SV', 'El Salvador', '6052064', 'San Salvador', 'North America'),
('SY', 'Syria', '22198110', 'Damascus', 'Asia'),
('SZ', 'Swaziland', '1354051', 'Mbabane', 'Africa'),
('TC', 'Turks and Caicos Islands', '20556', 'Cockburn Town', 'North America'),
('TD', 'Chad', '10543464', 'N\'Djamena', 'Africa'),
('TF', 'French Southern Territories', '140', 'Port-aux-Français', 'Antarctica'),
('TG', 'Togo', '6587239', 'Lomé', 'Africa'),
('TH', 'Thailand', '67089500', 'Bangkok', 'Asia'),
('TJ', 'Tajikistan', '7487489', 'Dushanbe', 'Asia'),
('TK', 'Tokelau', '1466', '', 'Oceania'),
('TL', 'East Timor', '1154625', 'Dili', 'Oceania'),
('TM', 'Turkmenistan', '4940916', 'Ashgabat', 'Asia'),
('TN', 'Tunisia', '10589025', 'Tunis', 'Africa'),
('TO', 'Tonga', '122580', 'Nuku\'alofa', 'Oceania'),
('TR', 'Turkey', '77804122', 'Ankara', 'Asia'),
('TT', 'Trinidad and Tobago', '1228691', 'Port of Spain', 'North America'),
('TV', 'Tuvalu', '10472', 'Funafuti', 'Oceania'),
('TW', 'Taiwan', '22894384', 'Taipei', 'Asia'),
('TZ', 'Tanzania', '41892895', 'Dodoma', 'Africa'),
('UA', 'Ukraine', '45415596', 'Kyiv', 'Europe'),
('UG', 'Uganda', '33398682', 'Kampala', 'Africa'),
('UM', 'U.S. Minor Outlying Islands', '0', '', 'Oceania'),
('US', 'United States', '310232863', 'Washington', 'North America'),
('UY', 'Uruguay', '3477000', 'Montevideo', 'South America'),
('UZ', 'Uzbekistan', '27865738', 'Tashkent', 'Asia'),
('VA', 'Vatican City', '921', 'Vatican', 'Europe'),
('VC', 'Saint Vincent and the Grenadines', '104217', 'Kingstown', 'North America'),
('VE', 'Venezuela', '27223228', 'Caracas', 'South America'),
('VG', 'British Virgin Islands', '21730', 'Road Town', 'North America'),
('VI', 'U.S. Virgin Islands', '108708', 'Charlotte Amalie', 'North America'),
('VN', 'Vietnam', '89571130', 'Hanoi', 'Asia'),
('VU', 'Vanuatu', '221552', 'Port Vila', 'Oceania'),
('WF', 'Wallis and Futuna', '16025', 'Mata-Utu', 'Oceania'),
('WS', 'Samoa', '192001', 'Apia', 'Oceania'),
('YE', 'Yemen', '23495361', 'Sanaa', 'Asia'),
('YT', 'Mayotte', '159042', 'Mamoutzou', 'Africa'),
('ZA', 'South Africa', '49000000', 'Pretoria', 'Africa'),
('ZM', 'Zambia', '13460305', 'Lusaka', 'Africa'),
('ZW', 'Zimbabwe', '11651858', 'Harare', 'Africa')