Country List (in SQL)

More then once I need to have to populate a country list into database for later retrieve to populate an online form or combo box. Instead of doing it all over again, I’ve made the following SQL script, it should work with My SQL, MS SQL, etc…

I’m not sure if this the full list of every country in the world, so if you know a country that is not in the list, let me know.

And please pre-create a table tCountry to hold the data.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
INSERT INTO tCountry (CountryName) VALUES ('Afghanistan');
INSERT INTO tCountry (CountryName) VALUES ('Albania');
INSERT INTO tCountry (CountryName) VALUES ('Algeria');
INSERT INTO tCountry (CountryName) VALUES ('American Samoa');
INSERT INTO tCountry (CountryName) VALUES ('Andorra');
INSERT INTO tCountry (CountryName) VALUES ('Angola');
INSERT INTO tCountry (CountryName) VALUES ('Anguilla');
INSERT INTO tCountry (CountryName) VALUES ('Antarctica');
INSERT INTO tCountry (CountryName) VALUES ('Antigua and Barbuda');
INSERT INTO tCountry (CountryName) VALUES ('Argentina');
INSERT INTO tCountry (CountryName) VALUES ('Armenia');
INSERT INTO tCountry (CountryName) VALUES ('Arctic Ocean');
INSERT INTO tCountry (CountryName) VALUES ('Aruba');
INSERT INTO tCountry (CountryName) VALUES ('Ashmore and Cartier Islands');
INSERT INTO tCountry (CountryName) VALUES ('Atlantic Ocean');
INSERT INTO tCountry (CountryName) VALUES ('Australia');
INSERT INTO tCountry (CountryName) VALUES ('Austria');
INSERT INTO tCountry (CountryName) VALUES ('Azerbaijan');
INSERT INTO tCountry (CountryName) VALUES ('Bahamas');
INSERT INTO tCountry (CountryName) VALUES ('Bahrain');
INSERT INTO tCountry (CountryName) VALUES ('Baker Island');
INSERT INTO tCountry (CountryName) VALUES ('Bangladesh');
INSERT INTO tCountry (CountryName) VALUES ('Barbados');
INSERT INTO tCountry (CountryName) VALUES ('Bassas da India');
INSERT INTO tCountry (CountryName) VALUES ('Belarus');
INSERT INTO tCountry (CountryName) VALUES ('Belgium');
INSERT INTO tCountry (CountryName) VALUES ('Belize');
INSERT INTO tCountry (CountryName) VALUES ('Benin');
INSERT INTO tCountry (CountryName) VALUES ('Bermuda');
INSERT INTO tCountry (CountryName) VALUES ('Bhutan');
INSERT INTO tCountry (CountryName) VALUES ('Bolivia');
INSERT INTO tCountry (CountryName) VALUES ('Bosnia and Herzegovina');
INSERT INTO tCountry (CountryName) VALUES ('Botswana');
INSERT INTO tCountry (CountryName) VALUES ('Bouvet Island');
INSERT INTO tCountry (CountryName) VALUES ('Brazil');
INSERT INTO tCountry (CountryName) VALUES ('British Virgin Islands');
INSERT INTO tCountry (CountryName) VALUES ('Brunei');
INSERT INTO tCountry (CountryName) VALUES ('Bulgaria');
INSERT INTO tCountry (CountryName) VALUES ('Burkina Faso');
INSERT INTO tCountry (CountryName) VALUES ('Burundi');
INSERT INTO tCountry (CountryName) VALUES ('Cambodia');
INSERT INTO tCountry (CountryName) VALUES ('Cameroon');
INSERT INTO tCountry (CountryName) VALUES ('Canada');
INSERT INTO tCountry (CountryName) VALUES ('Cape Verde');
INSERT INTO tCountry (CountryName) VALUES ('Cayman Islands');
INSERT INTO tCountry (CountryName) VALUES ('Central African Republic');
INSERT INTO tCountry (CountryName) VALUES ('Chad');
INSERT INTO tCountry (CountryName) VALUES ('Chile');
INSERT INTO tCountry (CountryName) VALUES ('China');
INSERT INTO tCountry (CountryName) VALUES ('Christmas Island');
INSERT INTO tCountry (CountryName) VALUES ('Clipperton Island');
INSERT INTO tCountry (CountryName) VALUES ('Cocos Islands');
INSERT INTO tCountry (CountryName) VALUES ('Colombia');
INSERT INTO tCountry (CountryName) VALUES ('Comoros');
INSERT INTO tCountry (CountryName) VALUES ('Cook Islands');
INSERT INTO tCountry (CountryName) VALUES ('Coral Sea Islands');
INSERT INTO tCountry (CountryName) VALUES ('Costa Rica');
INSERT INTO tCountry (CountryName) VALUES ('Cote d"Ivoire');
INSERT INTO tCountry (CountryName) VALUES ('Croatia');
INSERT INTO tCountry (CountryName) VALUES ('Cuba');
INSERT INTO tCountry (CountryName) VALUES ('Cyprus');
INSERT INTO tCountry (CountryName) VALUES ('Czech Republic');
INSERT INTO tCountry (CountryName) VALUES ('Denmark');
INSERT INTO tCountry (CountryName) VALUES ('Democratic Republic of the Congo');
INSERT INTO tCountry (CountryName) VALUES ('Djibouti');
INSERT INTO tCountry (CountryName) VALUES ('Dominica');
INSERT INTO tCountry (CountryName) VALUES ('Dominican Republic');
INSERT INTO tCountry (CountryName) VALUES ('East Timor');
INSERT INTO tCountry (CountryName) VALUES ('Ecuador');
INSERT INTO tCountry (CountryName) VALUES ('Egypt');
INSERT INTO tCountry (CountryName) VALUES ('El Salvador');
INSERT INTO tCountry (CountryName) VALUES ('Equatorial Guinea');
INSERT INTO tCountry (CountryName) VALUES ('Eritrea');
INSERT INTO tCountry (CountryName) VALUES ('Estonia');
INSERT INTO tCountry (CountryName) VALUES ('Ethiopia');
INSERT INTO tCountry (CountryName) VALUES ('Europa Island');
INSERT INTO tCountry (CountryName) VALUES ('Falkland Islands (Islas Malvinas)');
INSERT INTO tCountry (CountryName) VALUES ('Faroe Islands');
INSERT INTO tCountry (CountryName) VALUES ('Fiji');
INSERT INTO tCountry (CountryName) VALUES ('Finland');
INSERT INTO tCountry (CountryName) VALUES ('France');
INSERT INTO tCountry (CountryName) VALUES ('French Guiana');
INSERT INTO tCountry (CountryName) VALUES ('French Polynesia');
INSERT INTO tCountry (CountryName) VALUES ('French Southern and Antarctic Lands');
INSERT INTO tCountry (CountryName) VALUES ('Gabon');
INSERT INTO tCountry (CountryName) VALUES ('Gambia');
INSERT INTO tCountry (CountryName) VALUES ('Gaza Strip');
INSERT INTO tCountry (CountryName) VALUES ('Georgia');
INSERT INTO tCountry (CountryName) VALUES ('Germany');
INSERT INTO tCountry (CountryName) VALUES ('Ghana');
INSERT INTO tCountry (CountryName) VALUES ('Gibraltar');
INSERT INTO tCountry (CountryName) VALUES ('Glorioso Islands');
INSERT INTO tCountry (CountryName) VALUES ('Greece');
INSERT INTO tCountry (CountryName) VALUES ('Greenland');
INSERT INTO tCountry (CountryName) VALUES ('Grenada');
INSERT INTO tCountry (CountryName) VALUES ('Guadeloupe');
INSERT INTO tCountry (CountryName) VALUES ('Guam');
INSERT INTO tCountry (CountryName) VALUES ('Guatemala');
INSERT INTO tCountry (CountryName) VALUES ('Guernsey');
INSERT INTO tCountry (CountryName) VALUES ('Guinea');
INSERT INTO tCountry (CountryName) VALUES ('Guinea-Bissau');
INSERT INTO tCountry (CountryName) VALUES ('Guyana');
INSERT INTO tCountry (CountryName) VALUES ('Haiti');
INSERT INTO tCountry (CountryName) VALUES ('Honduras');
INSERT INTO tCountry (CountryName) VALUES ('Hong Kong');
INSERT INTO tCountry (CountryName) VALUES ('Howland Island');
INSERT INTO tCountry (CountryName) VALUES ('Hungary');
INSERT INTO tCountry (CountryName) VALUES ('Iceland');
INSERT INTO tCountry (CountryName) VALUES ('India');
INSERT INTO tCountry (CountryName) VALUES ('Indian Ocean');
INSERT INTO tCountry (CountryName) VALUES ('Indonesia');
INSERT INTO tCountry (CountryName) VALUES ('Iran');
INSERT INTO tCountry (CountryName) VALUES ('Iraq');
INSERT INTO tCountry (CountryName) VALUES ('Ireland');
INSERT INTO tCountry (CountryName) VALUES ('Isle of Man');
INSERT INTO tCountry (CountryName) VALUES ('Israel');
INSERT INTO tCountry (CountryName) VALUES ('Italy');
INSERT INTO tCountry (CountryName) VALUES ('Jamaica');
INSERT INTO tCountry (CountryName) VALUES ('Jan Mayen');
INSERT INTO tCountry (CountryName) VALUES ('Japan');
INSERT INTO tCountry (CountryName) VALUES ('Jarvis Island');
INSERT INTO tCountry (CountryName) VALUES ('Jersey');
INSERT INTO tCountry (CountryName) VALUES ('Johnston Atoll');
INSERT INTO tCountry (CountryName) VALUES ('Jordan');
INSERT INTO tCountry (CountryName) VALUES ('Juan de Nova Island');
INSERT INTO tCountry (CountryName) VALUES ('Kazakhstan');
INSERT INTO tCountry (CountryName) VALUES ('Kenya');
INSERT INTO tCountry (CountryName) VALUES ('Kingman Reef');
INSERT INTO tCountry (CountryName) VALUES ('Kiribati');
INSERT INTO tCountry (CountryName) VALUES ('Kerguelen Archipelago');
INSERT INTO tCountry (CountryName) VALUES ('Kuwait');
INSERT INTO tCountry (CountryName) VALUES ('Kyrgyzstan');
INSERT INTO tCountry (CountryName) VALUES ('Laos');
INSERT INTO tCountry (CountryName) VALUES ('Latvia');
INSERT INTO tCountry (CountryName) VALUES ('Lebanon');
INSERT INTO tCountry (CountryName) VALUES ('Lesotho');
INSERT INTO tCountry (CountryName) VALUES ('Liberia');
INSERT INTO tCountry (CountryName) VALUES ('Libya');
INSERT INTO tCountry (CountryName) VALUES ('Liechtenstein');
INSERT INTO tCountry (CountryName) VALUES ('Lithuania');
INSERT INTO tCountry (CountryName) VALUES ('Luxembourg');
INSERT INTO tCountry (CountryName) VALUES ('Macau');
INSERT INTO tCountry (CountryName) VALUES ('Macedonia');
INSERT INTO tCountry (CountryName) VALUES ('Madagascar');
INSERT INTO tCountry (CountryName) VALUES ('Malawi');
INSERT INTO tCountry (CountryName) VALUES ('Malaysia');
INSERT INTO tCountry (CountryName) VALUES ('Maldives');
INSERT INTO tCountry (CountryName) VALUES ('Mali');
INSERT INTO tCountry (CountryName) VALUES ('Malta');
INSERT INTO tCountry (CountryName) VALUES ('Marshall Islands');
INSERT INTO tCountry (CountryName) VALUES ('Martinique');
INSERT INTO tCountry (CountryName) VALUES ('Mauritania');
INSERT INTO tCountry (CountryName) VALUES ('Mauritius');
INSERT INTO tCountry (CountryName) VALUES ('Mayotte');
INSERT INTO tCountry (CountryName) VALUES ('Mexico');
INSERT INTO tCountry (CountryName) VALUES ('Micronesia');
INSERT INTO tCountry (CountryName) VALUES ('Midway Islands');
INSERT INTO tCountry (CountryName) VALUES ('Moldova');
INSERT INTO tCountry (CountryName) VALUES ('Monaco');
INSERT INTO tCountry (CountryName) VALUES ('Mongolia');
INSERT INTO tCountry (CountryName) VALUES ('Montenegro');
INSERT INTO tCountry (CountryName) VALUES ('Montserrat');
INSERT INTO tCountry (CountryName) VALUES ('Morocco');
INSERT INTO tCountry (CountryName) VALUES ('Mozambique');
INSERT INTO tCountry (CountryName) VALUES ('Myanmar');
INSERT INTO tCountry (CountryName) VALUES ('Namibia');
INSERT INTO tCountry (CountryName) VALUES ('Nauru');
INSERT INTO tCountry (CountryName) VALUES ('Navassa Island');
INSERT INTO tCountry (CountryName) VALUES ('Nepal');
INSERT INTO tCountry (CountryName) VALUES ('Netherlands');
INSERT INTO tCountry (CountryName) VALUES ('Netherlands Antilles');
INSERT INTO tCountry (CountryName) VALUES ('New Caledonia');
INSERT INTO tCountry (CountryName) VALUES ('New Zealand');
INSERT INTO tCountry (CountryName) VALUES ('Nicaragua');
INSERT INTO tCountry (CountryName) VALUES ('Niger');
INSERT INTO tCountry (CountryName) VALUES ('Nigeria');
INSERT INTO tCountry (CountryName) VALUES ('Niue');
INSERT INTO tCountry (CountryName) VALUES ('Norfolk Island');
INSERT INTO tCountry (CountryName) VALUES ('North Korea');
INSERT INTO tCountry (CountryName) VALUES ('Northern Mariana Islands');
INSERT INTO tCountry (CountryName) VALUES ('Norway');
INSERT INTO tCountry (CountryName) VALUES ('Oman');
INSERT INTO tCountry (CountryName) VALUES ('Pacific Ocean');
INSERT INTO tCountry (CountryName) VALUES ('Pakistan');
INSERT INTO tCountry (CountryName) VALUES ('Palau');
INSERT INTO tCountry (CountryName) VALUES ('Palmyra Atoll');
INSERT INTO tCountry (CountryName) VALUES ('Panama');
INSERT INTO tCountry (CountryName) VALUES ('Papua New Guinea');
INSERT INTO tCountry (CountryName) VALUES ('Paracel Islands');
INSERT INTO tCountry (CountryName) VALUES ('Paraguay');
INSERT INTO tCountry (CountryName) VALUES ('Peru');
INSERT INTO tCountry (CountryName) VALUES ('Philippines');
INSERT INTO tCountry (CountryName) VALUES ('Pitcairn Islands');
INSERT INTO tCountry (CountryName) VALUES ('Poland');
INSERT INTO tCountry (CountryName) VALUES ('Portugal');
INSERT INTO tCountry (CountryName) VALUES ('Puerto Rico');
INSERT INTO tCountry (CountryName) VALUES ('Qatar');
INSERT INTO tCountry (CountryName) VALUES ('Reunion');
INSERT INTO tCountry (CountryName) VALUES ('Republic of the Congo');
INSERT INTO tCountry (CountryName) VALUES ('Romania');
INSERT INTO tCountry (CountryName) VALUES ('Russia');
INSERT INTO tCountry (CountryName) VALUES ('Rwanda');
INSERT INTO tCountry (CountryName) VALUES ('Saint Helena');
INSERT INTO tCountry (CountryName) VALUES ('Saint Kitts and Nevis');
INSERT INTO tCountry (CountryName) VALUES ('Saint Lucia');
INSERT INTO tCountry (CountryName) VALUES ('Saint Pierre and Miquelon');
INSERT INTO tCountry (CountryName) VALUES ('Saint Vincent and the Grenadin');
INSERT INTO tCountry (CountryName) VALUES ('Samoa');
INSERT INTO tCountry (CountryName) VALUES ('San Marino');
INSERT INTO tCountry (CountryName) VALUES ('Sao Tome and Principe');
INSERT INTO tCountry (CountryName) VALUES ('Saudi Arabia');
INSERT INTO tCountry (CountryName) VALUES ('Senegal');
INSERT INTO tCountry (CountryName) VALUES ('Serbia');
INSERT INTO tCountry (CountryName) VALUES ('Seychelles');
INSERT INTO tCountry (CountryName) VALUES ('Sierra Leone');
INSERT INTO tCountry (CountryName) VALUES ('Singapore');
INSERT INTO tCountry (CountryName) VALUES ('Slovakia');
INSERT INTO tCountry (CountryName) VALUES ('Slovenia');
INSERT INTO tCountry (CountryName) VALUES ('Solomon Islands');
INSERT INTO tCountry (CountryName) VALUES ('Somalia');
INSERT INTO tCountry (CountryName) VALUES ('South Africa');
INSERT INTO tCountry (CountryName) VALUES ('South Georgia and the South Sandwich Islands');
INSERT INTO tCountry (CountryName) VALUES ('South Korea');
INSERT INTO tCountry (CountryName) VALUES ('Spain');
INSERT INTO tCountry (CountryName) VALUES ('Spratly Islands');
INSERT INTO tCountry (CountryName) VALUES ('Sri Lanka');
INSERT INTO tCountry (CountryName) VALUES ('Sudan');
INSERT INTO tCountry (CountryName) VALUES ('Suriname');
INSERT INTO tCountry (CountryName) VALUES ('Svalbard');
INSERT INTO tCountry (CountryName) VALUES ('Swaziland');
INSERT INTO tCountry (CountryName) VALUES ('Sweden');
INSERT INTO tCountry (CountryName) VALUES ('Switzerland');
INSERT INTO tCountry (CountryName) VALUES ('Syria');
INSERT INTO tCountry (CountryName) VALUES ('Taiwan');
INSERT INTO tCountry (CountryName) VALUES ('Tajikistan');
INSERT INTO tCountry (CountryName) VALUES ('Tanzania');
INSERT INTO tCountry (CountryName) VALUES ('Thailand');
INSERT INTO tCountry (CountryName) VALUES ('Togo');
INSERT INTO tCountry (CountryName) VALUES ('Tokelau');
INSERT INTO tCountry (CountryName) VALUES ('Tonga');
INSERT INTO tCountry (CountryName) VALUES ('Trinidad and Tobago');
INSERT INTO tCountry (CountryName) VALUES ('Tromelin Island');
INSERT INTO tCountry (CountryName) VALUES ('Tunisia');
INSERT INTO tCountry (CountryName) VALUES ('Turkey');
INSERT INTO tCountry (CountryName) VALUES ('Turkmenistan');
INSERT INTO tCountry (CountryName) VALUES ('Turks and Caicos Islands');
INSERT INTO tCountry (CountryName) VALUES ('Tuvalu');
INSERT INTO tCountry (CountryName) VALUES ('Uganda');
INSERT INTO tCountry (CountryName) VALUES ('Ukraine');
INSERT INTO tCountry (CountryName) VALUES ('United Arab Emirates');
INSERT INTO tCountry (CountryName) VALUES ('United Kingdom');
INSERT INTO tCountry (CountryName) VALUES ('USA');
INSERT INTO tCountry (CountryName) VALUES ('Uruguay');
INSERT INTO tCountry (CountryName) VALUES ('Uzbekistan');
INSERT INTO tCountry (CountryName) VALUES ('Vanuatu');
INSERT INTO tCountry (CountryName) VALUES ('Venezuela');
INSERT INTO tCountry (CountryName) VALUES ('Vietnam');
INSERT INTO tCountry (CountryName) VALUES ('Virgin Islands');
INSERT INTO tCountry (CountryName) VALUES ('Wake Island');
INSERT INTO tCountry (CountryName) VALUES ('Wallis and Futuna');
INSERT INTO tCountry (CountryName) VALUES ('West Bank');
INSERT INTO tCountry (CountryName) VALUES ('Western Sahara');
INSERT INTO tCountry (CountryName) VALUES ('Yemen');
INSERT INTO tCountry (CountryName) VALUES ('Yugoslavia');
INSERT INTO tCountry (CountryName) VALUES ('Zambia');
INSERT INTO tCountry (CountryName) VALUES ('Zimbabwe');

Submit a Comment