Skip to content

Instantly share code, notes, and snippets.

@sebastiandg7
Created October 25, 2017 19:20
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save sebastiandg7/d4370063b330eae4e65e199183723455 to your computer and use it in GitHub Desktop.
Save sebastiandg7/d4370063b330eae4e65e199183723455 to your computer and use it in GitHub Desktop.
Insert all countries to databse (name and code).
USE `database`;
CREATE TABLE `country` (
`id` INT NOT NULL AUTO_INCREMENT,
`name` VARCHAR(45) NOT NULL,
`code` VARCHAR(45) NOT NULL,
PRIMARY KEY (`id`)
)
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Afghanistan','AF');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Aland Islands','AX');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Albania','AL');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Algeria','DZ');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'American Samoa','AS');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Andorra','AD');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Angola','AO');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Anguilla','AI');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Antarctica','AQ');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Antigua and Barbuda','AG');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Argentina','AR');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Armenia','AM');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Aruba','AW');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Australia','AU');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Austria','AT');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Azerbaijan','AZ');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Bahamas','BS');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Bahrain','BH');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Bangladesh','BD');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Barbados','BB');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Belarus','BY');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Belgium','BE');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Belize','BZ');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Benin','BJ');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Bermuda','BM');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Bhutan','BT');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Bolivia','BO');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Bosnia and Herzegovina','BA');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Botswana','BW');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Bouvet Island','BV');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Brazil','BR');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'British Virgin Islands','VG');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'British Indian Ocean Territory','IO');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Brunei Darussalam','BN');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Bulgaria','BG');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Burkina Faso','BF');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Burundi','BI');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Cambodia','KH');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Cameroon','CM');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Canada','CA');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Cape Verde','CV');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Cayman Islands','KY');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Central African Republic','CF');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Chad','TD');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Chile','CL');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'China','CN');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Hong Kong, SAR China','HK');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Macao, SAR China','MO');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Christmas Island','CX');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Cocos (Keeling) Islands','CC');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Colombia','CO');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Comoros','KM');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Congo (Brazzaville)','CG');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Congo, (Kinshasa)','CD');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Cook Islands','CK');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Costa Rica','CR');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Côte d´Ivoire','CI');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Croatia','HR');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Cuba','CU');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Cyprus','CY');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Czech Republic','CZ');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Denmark','DK');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Djibouti','DJ');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Dominica','DM');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Dominican Republic','DO');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Ecuador','EC');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Egypt','EG');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'El Salvador','SV');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Equatorial Guinea','GQ');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Eritrea','ER');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Estonia','EE');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Ethiopia','ET');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Falkland Islands (Malvinas)','FK');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Faroe Islands','FO');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Fiji','FJ');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Finland','FI');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'France','FR');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'French Guiana','GF');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'French Polynesia','PF');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'French Southern Territories','TF');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Gabon','GA');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Gambia','GM');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Georgia','GE');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Germany','DE');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Ghana','GH');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Gibraltar','GI');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Greece','GR');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Greenland','GL');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Grenada','GD');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Guadeloupe','GP');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Guam','GU');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Guatemala','GT');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Guernsey','GG');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Guinea','GN');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Guinea-Bissau','GW');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Guyana','GY');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Haiti','HT');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Heard and Mcdonald Islands','HM');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Holy See (Vatican City State)','VA');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Honduras','HN');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Hungary','HU');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Iceland','IS');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'India','IN');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Indonesia','ID');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Iran, Islamic Republic of','IR');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Iraq','IQ');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Ireland','IE');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Isle of Man','IM');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Israel','IL');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Italy','IT');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Jamaica','JM');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Japan','JP');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Jersey','JE');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Jordan','JO');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Kazakhstan','KZ');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Kenya','KE');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Kiribati','KI');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Korea (North)','KP');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Korea (South)','KR');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Kuwait','KW');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Kyrgyzstan','KG');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Lao PDR','LA');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Latvia','LV');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Lebanon','LB');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Lesotho','LS');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Liberia','LR');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Libya','LY');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Liechtenstein','LI');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Lithuania','LT');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Luxembourg','LU');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Macedonia, Republic of','MK');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Madagascar','MG');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Malawi','MW');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Malaysia','MY');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Maldives','MV');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Mali','ML');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Malta','MT');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Marshall Islands','MH');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Martinique','MQ');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Mauritania','MR');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Mauritius','MU');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Mayotte','YT');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Mexico','MX');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Micronesia, Federated States of','FM');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Moldova','MD');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Monaco','MC');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Mongolia','MN');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Montenegro','ME');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Montserrat','MS');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Morocco','MA');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Mozambique','MZ');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Myanmar','MM');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Namibia','NA');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Nauru','NR');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Nepal','NP');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Netherlands','NL');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Netherlands Antilles','AN');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'New Caledonia','NC');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'New Zealand','NZ');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Nicaragua','NI');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Niger','NE');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Nigeria','NG');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Niue','NU');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Norfolk Island','NF');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Northern Mariana Islands','MP');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Norway','NO');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Oman','OM');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Pakistan','PK');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Palau','PW');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Palestinian Territory','PS');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Panama','PA');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Papua New Guinea','PG');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Paraguay','PY');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Peru','PE');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Philippines','PH');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Pitcairn','PN');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Poland','PL');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Portugal','PT');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Puerto Rico','PR');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Qatar','QA');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Réunion','RE');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Romania','RO');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Russian Federation','RU');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Rwanda','RW');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Saint-Barthélemy','BL');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Saint Helena','SH');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Saint Kitts and Nevis','KN');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Saint Lucia','LC');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Saint-Martin (French part)','MF');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Saint Pierre and Miquelon','PM');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Saint Vincent and Grenadines','VC');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Samoa','WS');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'San Marino','SM');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Sao Tome and Principe','ST');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Saudi Arabia','SA');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Senegal','SN');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Serbia','RS');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Seychelles','SC');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Sierra Leone','SL');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Singapore','SG');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Slovakia','SK');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Slovenia','SI');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Solomon Islands','SB');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Somalia','SO');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'South Africa','ZA');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'South Georgia and the South Sandwich Islands','GS');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'South Sudan','SS');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Spain','ES');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Sri Lanka','LK');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Sudan','SD');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Suriname','SR');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Svalbard and Jan Mayen Islands','SJ');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Swaziland','SZ');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Sweden','SE');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Switzerland','CH');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Syrian Arab Republic (Syria)','SY');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Taiwan, Republic of China','TW');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Tajikistan','TJ');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Tanzania, United Republic of','TZ');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Thailand','TH');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Timor-Leste','TL');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Togo','TG');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Tokelau','TK');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Tonga','TO');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Trinidad and Tobago','TT');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Tunisia','TN');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Turkey','TR');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Turkmenistan','TM');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Turks and Caicos Islands','TC');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Tuvalu','TV');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Uganda','UG');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Ukraine','UA');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'United Arab Emirates','AE');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'United Kingdom','GB');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'United States of America','US');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'US Minor Outlying Islands','UM');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Uruguay','UY');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Uzbekistan','UZ');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Vanuatu','VU');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Venezuela (Bolivarian Republic)','VE');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Viet Nam','VN');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Virgin Islands, US','VI');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Wallis and Futuna Islands','WF');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Western Sahara','EH');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Yemen','YE');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Zambia','ZM');
INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Zimbabwe','ZW');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment