Thomas Sampson

SQL Table of countries

Leave a comment

INSERT INTO tbl_countries(country_name) values(‘Afghanistan ‘);
INSERT INTO tbl_countries(country_name) values(‘Aland (Aland) Islands ‘);
INSERT INTO tbl_countries(country_name) values(‘Albania ‘);
INSERT INTO tbl_countries(country_name) values(‘Algeria ‘);
INSERT INTO tbl_countries(country_name) values(‘American Samoa ‘);
INSERT INTO tbl_countries(country_name) values(‘Andorra ‘);
INSERT INTO tbl_countries(country_name) values(‘Angola ‘);
INSERT INTO tbl_countries(country_name) values(‘Anguilla ‘);
INSERT INTO tbl_countries(country_name) values(‘Antigua and Barbuda ‘);
INSERT INTO tbl_countries(country_name) values(‘Argentina ‘);
INSERT INTO tbl_countries(country_name) values(‘Armenia ‘);
INSERT INTO tbl_countries(country_name) values(‘Aruba ‘);
INSERT INTO tbl_countries(country_name) values(‘Australia ‘);
INSERT INTO tbl_countries(country_name) values(‘Austria ‘);
INSERT INTO tbl_countries(country_name) values(‘Azerbaijan ‘);
INSERT INTO tbl_countries(country_name) values(‘Bahamas ‘);
INSERT INTO tbl_countries(country_name) values(‘Bahrain ‘);
INSERT INTO tbl_countries(country_name) values(‘Bangladesh ‘);
INSERT INTO tbl_countries(country_name) values(‘Barbados ‘);
INSERT INTO tbl_countries(country_name) values(‘Belarus ‘);
INSERT INTO tbl_countries(country_name) values(‘Belgium ‘);
INSERT INTO tbl_countries(country_name) values(‘Belize ‘);
INSERT INTO tbl_countries(country_name) values(‘Benin ‘);
INSERT INTO tbl_countries(country_name) values(‘Bermuda ‘);
INSERT INTO tbl_countries(country_name) values(‘Bhutan ‘);
INSERT INTO tbl_countries(country_name) values(‘Bolivia ‘);
INSERT INTO tbl_countries(country_name) values(‘Bosnia and Herzegovina  ‘);
INSERT INTO tbl_countries(country_name) values(‘Botswana ‘);
INSERT INTO tbl_countries(country_name) values(‘Bouvet Island ‘);
INSERT INTO tbl_countries(country_name) values(‘Brazil ‘);
INSERT INTO tbl_countries(country_name) values(‘British Indian Ocean Territory ‘);
INSERT INTO tbl_countries(country_name) values(‘Brunei Darussalam ‘);
INSERT INTO tbl_countries(country_name) values(‘Bulgaria ‘);
INSERT INTO tbl_countries(country_name) values(‘Burkina Faso ‘);
INSERT INTO tbl_countries(country_name) values(‘Burundi ‘);
INSERT INTO tbl_countries(country_name) values(‘Cambodia ‘);
INSERT INTO tbl_countries(country_name) values(‘Cameroon  ‘);
INSERT INTO tbl_countries(country_name) values(‘Canada ‘);
INSERT INTO tbl_countries(country_name) values(‘Cape Verde ‘);
INSERT INTO tbl_countries(country_name) values(‘Cayman Islands ‘);
INSERT INTO tbl_countries(country_name) values(‘Central African Republic ‘);
INSERT INTO tbl_countries(country_name) values(‘Chad ‘);
INSERT INTO tbl_countries(country_name) values(‘Chile ‘);
INSERT INTO tbl_countries(country_name) values(‘China ‘);
INSERT INTO tbl_countries(country_name) values(‘Cocos (Keeling) Islands ‘);
INSERT INTO tbl_countries(country_name) values(‘Colombia ‘);
INSERT INTO tbl_countries(country_name) values(‘Comoros ‘);
INSERT INTO tbl_countries(country_name) values(‘Congo ‘);
INSERT INTO tbl_countries(country_name) values(‘Congo, The Democratic Republic of the (Zaire) ‘);
INSERT INTO tbl_countries(country_name) values(‘Cook Islands ‘);
INSERT INTO tbl_countries(country_name) values(‘Costa Rica ‘);
INSERT INTO tbl_countries(country_name) values(‘Cote d`Ivoire (Ivory Coast) ‘);
INSERT INTO tbl_countries(country_name) values(‘Croatia ‘);
INSERT INTO tbl_countries(country_name) values(‘Cuba ‘);
INSERT INTO tbl_countries(country_name) values(‘Cyprus ‘);
INSERT INTO tbl_countries(country_name) values(‘Czech Republic ‘);
INSERT INTO tbl_countries(country_name) values(‘Denmark ‘);
INSERT INTO tbl_countries(country_name) values(‘Djibouti ‘);
INSERT INTO tbl_countries(country_name) values(‘Dominica ‘);
INSERT INTO tbl_countries(country_name) values(‘Dominican Republic ‘);
INSERT INTO tbl_countries(country_name) values(‘Ecuador ‘);
INSERT INTO tbl_countries(country_name) values(‘Egypt ‘);
INSERT INTO tbl_countries(country_name) values(‘El Salvador ‘);
INSERT INTO tbl_countries(country_name) values(‘Equatorial Guinea ‘);
INSERT INTO tbl_countries(country_name) values(‘Eritrea ‘);
INSERT INTO tbl_countries(country_name) values(‘Estonia ‘);
INSERT INTO tbl_countries(country_name) values(‘Ethiopia ‘);
INSERT INTO tbl_countries(country_name) values(‘Falkland Islands (Malvinas) ‘);
INSERT INTO tbl_countries(country_name) values(‘Faroe Islands ‘);
INSERT INTO tbl_countries(country_name) values(‘Fiji ‘);
INSERT INTO tbl_countries(country_name) values(‘Finland ‘);
INSERT INTO tbl_countries(country_name) values(‘France ‘);
INSERT INTO tbl_countries(country_name) values(‘French Guiana ‘);
INSERT INTO tbl_countries(country_name) values(‘French Polynesia (Polynésie Française) ‘);
INSERT INTO tbl_countries(country_name) values(‘French Southern Territories (TAFF) ‘);
INSERT INTO tbl_countries(country_name) values(‘Gabon ‘);
INSERT INTO tbl_countries(country_name) values(‘Gambia ‘);
INSERT INTO tbl_countries(country_name) values(‘Georgia ‘);
INSERT INTO tbl_countries(country_name) values(‘Germany ‘);
INSERT INTO tbl_countries(country_name) values(‘Ghana ‘);
INSERT INTO tbl_countries(country_name) values(‘Gibraltar ‘);
INSERT INTO tbl_countries(country_name) values(‘Greece ‘);
INSERT INTO tbl_countries(country_name) values(‘Greenlan ‘);
INSERT INTO tbl_countries(country_name) values(‘Grenada ‘);
INSERT INTO tbl_countries(country_name) values(‘Guadeloupe ‘);
INSERT INTO tbl_countries(country_name) values(‘Guam ‘);
INSERT INTO tbl_countries(country_name) values(‘Guatemala ‘);
INSERT INTO tbl_countries(country_name) values(‘Guinea ‘);
INSERT INTO tbl_countries(country_name) values(‘Guinea-Bissau ‘);
INSERT INTO tbl_countries(country_name) values(‘Guyana (Guyane) ‘);
INSERT INTO tbl_countries(country_name) values(‘Haiti ‘);
INSERT INTO tbl_countries(country_name) values(‘Heard and McDonald Islands ‘);
INSERT INTO tbl_countries(country_name) values(‘Holy See (Vatican City State) ‘);
INSERT INTO tbl_countries(country_name) values(‘Honduras ‘);
INSERT INTO tbl_countries(country_name) values(‘Hong Kong ‘);
INSERT INTO tbl_countries(country_name) values(‘Hungary ‘);
INSERT INTO tbl_countries(country_name) values(‘Iceland ‘);
INSERT INTO tbl_countries(country_name) values(‘India ‘);
INSERT INTO tbl_countries(country_name) values(‘Indonesia ‘);
INSERT INTO tbl_countries(country_name) values(‘Iran, Islamic Republic of ‘);
INSERT INTO tbl_countries(country_name) values(‘Iraq ‘);
INSERT INTO tbl_countries(country_name) values(‘Ireland ‘);
INSERT INTO tbl_countries(country_name) values(‘Israel ‘);
INSERT INTO tbl_countries(country_name) values(‘Italy ‘);
INSERT INTO tbl_countries(country_name) values(‘Jamaica ‘);
INSERT INTO tbl_countries(country_name) values(‘Japan ‘);
INSERT INTO tbl_countries(country_name) values(‘Jordan ‘);
INSERT INTO tbl_countries(country_name) values(‘Kazakhstan ‘);
INSERT INTO tbl_countries(country_name) values(‘Kenya ‘);
INSERT INTO tbl_countries(country_name) values(‘Kiribati,Korea, Democratic People\”s Republic of ‘);
INSERT INTO tbl_countries(country_name) values(‘Korea, Republic of ‘);
INSERT INTO tbl_countries(country_name) values(‘Kuwait ‘);
INSERT INTO tbl_countries(country_name) values(‘Kyrgyzstan ‘);
INSERT INTO tbl_countries(country_name) values(‘Lao People`s Democratic Republic ‘);
INSERT INTO tbl_countries(country_name) values(‘Latvia ‘);
INSERT INTO tbl_countries(country_name) values(‘Lebanon ‘);
INSERT INTO tbl_countries(country_name) values(‘Lesotho ‘);
INSERT INTO tbl_countries(country_name) values(‘Liberia ‘);
INSERT INTO tbl_countries(country_name) values(‘Libyan Arab Jamahiriya ‘);
INSERT INTO tbl_countries(country_name) values(‘Liechtenstein ‘);
INSERT INTO tbl_countries(country_name) values(‘Lithuania ‘);
INSERT INTO tbl_countries(country_name) values(‘Luxembourg ‘);
INSERT INTO tbl_countries(country_name) values(‘Macao (Macau) ‘);
INSERT INTO tbl_countries(country_name) values(‘Macedonia ‘);
INSERT INTO tbl_countries(country_name) values(‘Madagascar ‘);
INSERT INTO tbl_countries(country_name) values(‘Malawi ‘);
INSERT INTO tbl_countries(country_name) values(‘Malaysia ‘);
INSERT INTO tbl_countries(country_name) values(‘Maldives ‘);
INSERT INTO tbl_countries(country_name) values(‘Mali ‘);
INSERT INTO tbl_countries(country_name) values(‘Malta ‘);
INSERT INTO tbl_countries(country_name) values(‘Marshall Islands ‘);
INSERT INTO tbl_countries(country_name) values(‘Martinique ‘);
INSERT INTO tbl_countries(country_name) values(‘Mauritania ‘);
INSERT INTO tbl_countries(country_name) values(‘Mauritius ‘);
INSERT INTO tbl_countries(country_name) values(‘Mayotte ‘);
INSERT INTO tbl_countries(country_name) values(‘Mexico ‘);
INSERT INTO tbl_countries(country_name) values(‘Micronesia, Federated States of (FSM) ‘);
INSERT INTO tbl_countries(country_name) values(‘Moldova, Republic of ‘);
INSERT INTO tbl_countries(country_name) values(‘Monaco ‘);
INSERT INTO tbl_countries(country_name) values(‘Mongolia ‘);
INSERT INTO tbl_countries(country_name) values(‘Montserrat ‘);
INSERT INTO tbl_countries(country_name) values(‘Morocco ‘);
INSERT INTO tbl_countries(country_name) values(‘Mozambique ‘);
INSERT INTO tbl_countries(country_name) values(‘Myanmar (Burma) ‘);
INSERT INTO tbl_countries(country_name) values(‘Namibia ‘);
INSERT INTO tbl_countries(country_name) values(‘Nauru ‘);
INSERT INTO tbl_countries(country_name) values(‘Nepal ‘);
INSERT INTO tbl_countries(country_name) values(‘Netherlands ‘);
INSERT INTO tbl_countries(country_name) values(‘Netherlands Antilles ‘);
INSERT INTO tbl_countries(country_name) values(‘New Caledonia (Nouvelle Calédonie) ‘);
INSERT INTO tbl_countries(country_name) values(‘New Zealand ‘);
INSERT INTO tbl_countries(country_name) values(‘Nicaragua ‘);
INSERT INTO tbl_countries(country_name) values(‘Niger ‘);
INSERT INTO tbl_countries(country_name) values(‘Nigeria ‘);
INSERT INTO tbl_countries(country_name) values(‘Niue ‘);
INSERT INTO tbl_countries(country_name) values(‘Northern Mariana Islands ‘);
INSERT INTO tbl_countries(country_name) values(‘Norway ‘);
INSERT INTO tbl_countries(country_name) values(‘Oman ‘);
INSERT INTO tbl_countries(country_name) values(‘Pakistan ‘);
INSERT INTO tbl_countries(country_name) values(‘Palau ‘);
INSERT INTO tbl_countries(country_name) values(‘Palestinian Territory, Occupied ‘);
INSERT INTO tbl_countries(country_name) values(‘Panama ‘);
INSERT INTO tbl_countries(country_name) values(‘Papua New Guinea ‘);
INSERT INTO tbl_countries(country_name) values(‘Paraguay ‘);
INSERT INTO tbl_countries(country_name) values(‘Peru ‘);
INSERT INTO tbl_countries(country_name) values(‘Philippines ‘);
INSERT INTO tbl_countries(country_name) values(‘Pitcairn ‘);
INSERT INTO tbl_countries(country_name) values(‘Poland ‘);
INSERT INTO tbl_countries(country_name) values(‘Portugal ‘);
INSERT INTO tbl_countries(country_name) values(‘Puerto Rico ‘);
INSERT INTO tbl_countries(country_name) values(‘Qatar ‘);
INSERT INTO tbl_countries(country_name) values(‘Reunion (Réunion) ‘);
INSERT INTO tbl_countries(country_name) values(‘Romania ‘);
INSERT INTO tbl_countries(country_name) values(‘Russian Federation ‘);
INSERT INTO tbl_countries(country_name) values(‘Rwanda ‘);
INSERT INTO tbl_countries(country_name) values(‘Saint Helena ‘);
INSERT INTO tbl_countries(country_name) values(‘Saint Kitts and Nevis ‘);
INSERT INTO tbl_countries(country_name) values(‘Saint Lucia ‘);
INSERT INTO tbl_countries(country_name) values(‘Saint Pierre and Miquelon ‘);
INSERT INTO tbl_countries(country_name) values(‘Saint Vincent and the Grenadines ‘);
INSERT INTO tbl_countries(country_name) values(‘Samoa ‘);
INSERT INTO tbl_countries(country_name) values(‘San Marino ‘);
INSERT INTO tbl_countries(country_name) values(‘Sao Tome and Principe ‘);
INSERT INTO tbl_countries(country_name) values(‘Saudi Arabia ‘);
INSERT INTO tbl_countries(country_name) values(‘Senegal ‘);
INSERT INTO tbl_countries(country_name) values(‘Serbia and Montenegro ‘);
INSERT INTO tbl_countries(country_name) values(‘Seychelles ‘);
INSERT INTO tbl_countries(country_name) values(‘Sierra Leone ‘);
INSERT INTO tbl_countries(country_name) values(‘Singapore ‘);
INSERT INTO tbl_countries(country_name) values(‘Slovakia ‘);
INSERT INTO tbl_countries(country_name) values(‘Slovenia ‘);
INSERT INTO tbl_countries(country_name) values(‘Solomon Islands ‘);
INSERT INTO tbl_countries(country_name) values(‘Somalia ‘);
INSERT INTO tbl_countries(country_name) values(‘South Africa ‘);
INSERT INTO tbl_countries(country_name) values(‘South Georgia and the South Sandwich Islands ‘);
INSERT INTO tbl_countries(country_name) values(‘Spain ‘);
INSERT INTO tbl_countries(country_name) values(‘Sri Lanka ‘);
INSERT INTO tbl_countries(country_name) values(‘Sudan ‘);
INSERT INTO tbl_countries(country_name) values(‘Suriname ‘);
INSERT INTO tbl_countries(country_name) values(‘Svalbard and Jan Mayen ‘);
INSERT INTO tbl_countries(country_name) values(‘Swaziland ‘);
INSERT INTO tbl_countries(country_name) values(‘Sweden ‘);
INSERT INTO tbl_countries(country_name) values(‘Switzerland ‘);
INSERT INTO tbl_countries(country_name) values(‘Syrian Arab Republic ‘);
INSERT INTO tbl_countries(country_name) values(‘Taiwan ‘);
INSERT INTO tbl_countries(country_name) values(‘Tajikistan ‘);
INSERT INTO tbl_countries(country_name) values(‘Tanzania, United Republic of ‘);
INSERT INTO tbl_countries(country_name) values(‘Thailand ‘);
INSERT INTO tbl_countries(country_name) values(‘Timor-Leste (East Timor) ‘);
INSERT INTO tbl_countries(country_name) values(‘Togo ‘);
INSERT INTO tbl_countries(country_name) values(‘Tokelau ‘);
INSERT INTO tbl_countries(country_name) values(‘Tonga ‘);
INSERT INTO tbl_countries(country_name) values(‘Trinidad and Tobago ‘);
INSERT INTO tbl_countries(country_name) values(‘Tunisia’);
INSERT INTO tbl_countries(country_name) values(‘Turkey ‘);
INSERT INTO tbl_countries(country_name) values(‘Turkmenistan ‘);
INSERT INTO tbl_countries(country_name) values(‘Turks and Caicos Islands ‘);
INSERT INTO tbl_countries(country_name) values(‘Tuvalu ‘);
INSERT INTO tbl_countries(country_name) values(‘Uganda ‘);
INSERT INTO tbl_countries(country_name) values(‘Ukraine ‘);
INSERT INTO tbl_countries(country_name) values(‘United Arab Emirates ‘);
INSERT INTO tbl_countries(country_name) values(‘United Kingdom (UK) ‘);
INSERT INTO tbl_countries(country_name) values(‘United States (USA) ‘);
INSERT INTO tbl_countries(country_name) values(‘United States Minor Outlying Islands ‘);
INSERT INTO tbl_countries(country_name) values(‘Uruguay ‘);
INSERT INTO tbl_countries(country_name) values(‘Uzbekistan ‘);
INSERT INTO tbl_countries(country_name) values(‘Vanuatu ‘);
INSERT INTO tbl_countries(country_name) values(‘Venezuela ‘);
INSERT INTO tbl_countries(country_name) values(‘Viet Nam (Vietnam) ‘);
INSERT INTO tbl_countries(country_name) values(‘Virgin Islands, British ‘);
INSERT INTO tbl_countries(country_name) values(‘Virgin Islands, USA ‘);
INSERT INTO tbl_countries(country_name) values(‘Wallis and Futuna ‘);
INSERT INTO tbl_countries(country_name) values(‘Western Sahara ‘);
INSERT INTO tbl_countries(country_name) values(‘Yemen ‘);
INSERT INTO tbl_countries(country_name) values(‘Zambia’);
INSERT INTO tbl_countries(country_name) values(‘Zimbabwe’);

Advertisements

Author: tomtech999

I have recently graduated with a 1st class degree in MComp Games Software Development at Sheffield Hallam University, focusing primarily on application development in C++, with experience in graphics programming, scripting languages, DVCS/VCS and web technology. In my spare time I enjoy Drumming, Reading and Snowboarding!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s