-
Star
(270)
You must be signed in to star a gist -
Fork
(83)
You must be signed in to fork a gist
-
-
Save kalinchernev/486393efcca01623b18d to your computer and use it in GitHub Desktop.
| Afghanistan | |
| Albania | |
| Algeria | |
| Andorra | |
| Angola | |
| Antigua & Deps | |
| Argentina | |
| Armenia | |
| Australia | |
| Austria | |
| Azerbaijan | |
| Bahamas | |
| Bahrain | |
| Bangladesh | |
| Barbados | |
| Belarus | |
| Belgium | |
| Belize | |
| Benin | |
| Bhutan | |
| Bolivia | |
| Bosnia Herzegovina | |
| Botswana | |
| Brazil | |
| Brunei | |
| Bulgaria | |
| Burkina | |
| Burundi | |
| Cambodia | |
| Cameroon | |
| Canada | |
| Cape Verde | |
| Central African Rep | |
| Chad | |
| Chile | |
| China | |
| Colombia | |
| Comoros | |
| Congo | |
| Congo {Democratic Rep} | |
| Costa Rica | |
| Croatia | |
| Cuba | |
| Cyprus | |
| Czech Republic | |
| Denmark | |
| Djibouti | |
| Dominica | |
| Dominican Republic | |
| East Timor | |
| Ecuador | |
| Egypt | |
| El Salvador | |
| Equatorial Guinea | |
| Eritrea | |
| Estonia | |
| Ethiopia | |
| Fiji | |
| Finland | |
| France | |
| Gabon | |
| Gambia | |
| Georgia | |
| Germany | |
| Ghana | |
| Greece | |
| Grenada | |
| Guatemala | |
| Guinea | |
| Guinea-Bissau | |
| Guyana | |
| Haiti | |
| Honduras | |
| Hungary | |
| Iceland | |
| India | |
| Indonesia | |
| Iran | |
| Iraq | |
| Ireland {Republic} | |
| Israel | |
| Italy | |
| Ivory Coast | |
| Jamaica | |
| Japan | |
| Jordan | |
| Kazakhstan | |
| Kenya | |
| Kiribati | |
| Korea North | |
| Korea South | |
| Kosovo | |
| Kuwait | |
| Kyrgyzstan | |
| Laos | |
| Latvia | |
| Lebanon | |
| Lesotho | |
| Liberia | |
| Libya | |
| Liechtenstein | |
| Lithuania | |
| Luxembourg | |
| Macedonia | |
| Madagascar | |
| Malawi | |
| Malaysia | |
| Maldives | |
| Mali | |
| Malta | |
| Marshall Islands | |
| Mauritania | |
| Mauritius | |
| Mexico | |
| Micronesia | |
| Moldova | |
| Monaco | |
| Mongolia | |
| Montenegro | |
| Morocco | |
| Mozambique | |
| Myanmar, {Burma} | |
| Namibia | |
| Nauru | |
| Nepal | |
| Netherlands | |
| New Zealand | |
| Nicaragua | |
| Niger | |
| Nigeria | |
| Norway | |
| Oman | |
| Pakistan | |
| Palau | |
| Panama | |
| Papua New Guinea | |
| Paraguay | |
| Peru | |
| Philippines | |
| Poland | |
| Portugal | |
| Qatar | |
| Romania | |
| Russian Federation | |
| Rwanda | |
| St Kitts & Nevis | |
| St Lucia | |
| Saint Vincent & the Grenadines | |
| Samoa | |
| San Marino | |
| Sao Tome & Principe | |
| Saudi Arabia | |
| Senegal | |
| Serbia | |
| Seychelles | |
| Sierra Leone | |
| Singapore | |
| Slovakia | |
| Slovenia | |
| Solomon Islands | |
| Somalia | |
| South Africa | |
| South Sudan | |
| Spain | |
| Sri Lanka | |
| Sudan | |
| Suriname | |
| Swaziland | |
| Sweden | |
| Switzerland | |
| Syria | |
| Taiwan | |
| Tajikistan | |
| Tanzania | |
| Thailand | |
| Togo | |
| Tonga | |
| Trinidad & Tobago | |
| Tunisia | |
| Turkey | |
| Turkmenistan | |
| Tuvalu | |
| Uganda | |
| Ukraine | |
| United Arab Emirates | |
| United Kingdom | |
| United States | |
| Uruguay | |
| Uzbekistan | |
| Vanuatu | |
| Vatican City | |
| Venezuela | |
| Vietnam | |
| Yemen | |
| Zambia | |
| Zimbabwe |
Hernanson
commented
Aug 27, 2024
via email
SQL Insert Statements:
INSERT INTO Country (Name, Code) VALUES ('Afghanistan', 'AF');
INSERT INTO Country (Name, Code) VALUES ('Aland Islands', 'AX');
INSERT INTO Country (Name, Code) VALUES ('Albania', 'AL');
INSERT INTO Country (Name, Code) VALUES ('Algeria', 'DZ');
INSERT INTO Country (Name, Code) VALUES ('American Samoa', 'AS');
INSERT INTO Country (Name, Code) VALUES ('Andorra', 'AD');
INSERT INTO Country (Name, Code) VALUES ('Angola', 'AO');
INSERT INTO Country (Name, Code) VALUES ('Anguilla', 'AI');
INSERT INTO Country (Name, Code) VALUES ('Antarctica', 'AQ');
INSERT INTO Country (Name, Code) VALUES ('Antigua and Barbuda', 'AG');
INSERT INTO Country (Name, Code) VALUES ('Argentina', 'AR');
INSERT INTO Country (Name, Code) VALUES ('Armenia', 'AM');
INSERT INTO Country (Name, Code) VALUES ('Aruba', 'AW');
INSERT INTO Country (Name, Code) VALUES ('Australia', 'AU');
INSERT INTO Country (Name, Code) VALUES ('Austria', 'AT');
INSERT INTO Country (Name, Code) VALUES ('Azerbaijan', 'AZ');
INSERT INTO Country (Name, Code) VALUES ('Bahamas', 'BS');
INSERT INTO Country (Name, Code) VALUES ('Bahrain', 'BH');
INSERT INTO Country (Name, Code) VALUES ('Bangladesh', 'BD');
INSERT INTO Country (Name, Code) VALUES ('Barbados', 'BB');
INSERT INTO Country (Name, Code) VALUES ('Belarus', 'BY');
INSERT INTO Country (Name, Code) VALUES ('Belgium', 'BE');
INSERT INTO Country (Name, Code) VALUES ('Belize', 'BZ');
INSERT INTO Country (Name, Code) VALUES ('Benin', 'BJ');
INSERT INTO Country (Name, Code) VALUES ('Bermuda', 'BM');
INSERT INTO Country (Name, Code) VALUES ('Bhutan', 'BT');
INSERT INTO Country (Name, Code) VALUES ('Bolivia', 'BO');
INSERT INTO Country (Name, Code) VALUES ('Bonaire, Sint Eustatius and Saba', 'BQ');
INSERT INTO Country (Name, Code) VALUES ('Bosnia and Herzegovina', 'BA');
INSERT INTO Country (Name, Code) VALUES ('Botswana', 'BW');
INSERT INTO Country (Name, Code) VALUES ('Bouvet Island', 'BV');
INSERT INTO Country (Name, Code) VALUES ('Brazil', 'BR');
INSERT INTO Country (Name, Code) VALUES ('British Indian Ocean Territory', 'IO');
INSERT INTO Country (Name, Code) VALUES ('Brunei Darussalam', 'BN');
INSERT INTO Country (Name, Code) VALUES ('Bulgaria', 'BG');
INSERT INTO Country (Name, Code) VALUES ('Burkina Faso', 'BF');
INSERT INTO Country (Name, Code) VALUES ('Burundi', 'BI');
INSERT INTO Country (Name, Code) VALUES ('Cambodia', 'KH');
INSERT INTO Country (Name, Code) VALUES ('Cameroon', 'CM');
INSERT INTO Country (Name, Code) VALUES ('Canada', 'CA');
INSERT INTO Country (Name, Code) VALUES ('Cape Verde', 'CV');
INSERT INTO Country (Name, Code) VALUES ('Cayman Islands', 'KY');
INSERT INTO Country (Name, Code) VALUES ('Central African Republic', 'CF');
INSERT INTO Country (Name, Code) VALUES ('Chad', 'TD');
INSERT INTO Country (Name, Code) VALUES ('Chile', 'CL');
INSERT INTO Country (Name, Code) VALUES ('China', 'CN');
INSERT INTO Country (Name, Code) VALUES ('Christmas Island', 'CX');
INSERT INTO Country (Name, Code) VALUES ('Cocos (Keeling) Islands', 'CC');
INSERT INTO Country (Name, Code) VALUES ('Colombia', 'CO');
INSERT INTO Country (Name, Code) VALUES ('Comoros', 'KM');
INSERT INTO Country (Name, Code) VALUES ('Congo', 'CG');
INSERT INTO Country (Name, Code) VALUES ('Congo, Democratic Republic of the Congo', 'CD');
INSERT INTO Country (Name, Code) VALUES ('Cook Islands', 'CK');
INSERT INTO Country (Name, Code) VALUES ('Costa Rica', 'CR');
INSERT INTO Country (Name, Code) VALUES ('Cote D'Ivoire', 'CI');
INSERT INTO Country (Name, Code) VALUES ('Croatia', 'HR');
INSERT INTO Country (Name, Code) VALUES ('Cuba', 'CU');
INSERT INTO Country (Name, Code) VALUES ('Curacao', 'CW');
INSERT INTO Country (Name, Code) VALUES ('Cyprus', 'CY');
INSERT INTO Country (Name, Code) VALUES ('Czech Republic', 'CZ');
INSERT INTO Country (Name, Code) VALUES ('Denmark', 'DK');
INSERT INTO Country (Name, Code) VALUES ('Djibouti', 'DJ');
INSERT INTO Country (Name, Code) VALUES ('Dominica', 'DM');
INSERT INTO Country (Name, Code) VALUES ('Dominican Republic', 'DO');
INSERT INTO Country (Name, Code) VALUES ('Ecuador', 'EC');
INSERT INTO Country (Name, Code) VALUES ('Egypt', 'EG');
INSERT INTO Country (Name, Code) VALUES ('El Salvador', 'SV');
INSERT INTO Country (Name, Code) VALUES ('Equatorial Guinea', 'GQ');
INSERT INTO Country (Name, Code) VALUES ('Eritrea', 'ER');
INSERT INTO Country (Name, Code) VALUES ('Estonia', 'EE');
INSERT INTO Country (Name, Code) VALUES ('Ethiopia', 'ET');
INSERT INTO Country (Name, Code) VALUES ('Falkland Islands (Malvinas)', 'FK');
INSERT INTO Country (Name, Code) VALUES ('Faroe Islands', 'FO');
INSERT INTO Country (Name, Code) VALUES ('Fiji', 'FJ');
INSERT INTO Country (Name, Code) VALUES ('Finland', 'FI');
INSERT INTO Country (Name, Code) VALUES ('France', 'FR');
INSERT INTO Country (Name, Code) VALUES ('French Guiana', 'GF');
INSERT INTO Country (Name, Code) VALUES ('French Polynesia', 'PF');
INSERT INTO Country (Name, Code) VALUES ('French Southern Territories', 'TF');
INSERT INTO Country (Name, Code) VALUES ('Gabon', 'GA');
INSERT INTO Country (Name, Code) VALUES ('Gambia', 'GM');
INSERT INTO Country (Name, Code) VALUES ('Georgia', 'GE');
INSERT INTO Country (Name, Code) VALUES ('Germany', 'DE');
INSERT INTO Country (Name, Code) VALUES ('Ghana', 'GH');
INSERT INTO Country (Name, Code) VALUES ('Gibraltar', 'GI');
INSERT INTO Country (Name, Code) VALUES ('Greece', 'GR');
INSERT INTO Country (Name, Code) VALUES ('Greenland', 'GL');
INSERT INTO Country (Name, Code) VALUES ('Grenada', 'GD');
INSERT INTO Country (Name, Code) VALUES ('Guadeloupe', 'GP');
INSERT INTO Country (Name, Code) VALUES ('Guam', 'GU');
INSERT INTO Country (Name, Code) VALUES ('Guatemala', 'GT');
INSERT INTO Country (Name, Code) VALUES ('Guernsey', 'GG');
INSERT INTO Country (Name, Code) VALUES ('Guinea', 'GN');
INSERT INTO Country (Name, Code) VALUES ('Guinea-Bissau', 'GW');
INSERT INTO Country (Name, Code) VALUES ('Guyana', 'GY');
INSERT INTO Country (Name, Code) VALUES ('Haiti', 'HT');
INSERT INTO Country (Name, Code) VALUES ('Heard Island and Mcdonald Islands', 'HM');
INSERT INTO Country (Name, Code) VALUES ('Holy See (Vatican City State)', 'VA');
INSERT INTO Country (Name, Code) VALUES ('Honduras', 'HN');
INSERT INTO Country (Name, Code) VALUES ('Hong Kong', 'HK');
INSERT INTO Country (Name, Code) VALUES ('Hungary', 'HU');
INSERT INTO Country (Name, Code) VALUES ('Iceland', 'IS');
INSERT INTO Country (Name, Code) VALUES ('India', 'IN');
INSERT INTO Country (Name, Code) VALUES ('Indonesia', 'ID');
INSERT INTO Country (Name, Code) VALUES ('Iran, Islamic Republic of', 'IR');
INSERT INTO Country (Name, Code) VALUES ('Iraq', 'IQ');
INSERT INTO Country (Name, Code) VALUES ('Ireland', 'IE');
INSERT INTO Country (Name, Code) VALUES ('Isle of Man', 'IM');
INSERT INTO Country (Name, Code) VALUES ('Israel', 'IL');
INSERT INTO Country (Name, Code) VALUES ('Italy', 'IT');
INSERT INTO Country (Name, Code) VALUES ('Jamaica', 'JM');
INSERT INTO Country (Name, Code) VALUES ('Japan', 'JP');
INSERT INTO Country (Name, Code) VALUES ('Jersey', 'JE');
INSERT INTO Country (Name, Code) VALUES ('Jordan', 'JO');
INSERT INTO Country (Name, Code) VALUES ('Kazakhstan', 'KZ');
INSERT INTO Country (Name, Code) VALUES ('Kenya', 'KE');
INSERT INTO Country (Name, Code) VALUES ('Kiribati', 'KI');
INSERT INTO Country (Name, Code) VALUES ('Korea, Democratic People's Republic of', 'KP');
INSERT INTO Country (Name, Code) VALUES ('Korea, Republic of', 'KR');
INSERT INTO Country (Name, Code) VALUES ('Kosovo', 'XK');
INSERT INTO Country (Name, Code) VALUES ('Kuwait', 'KW');
INSERT INTO Country (Name, Code) VALUES ('Kyrgyzstan', 'KG');
INSERT INTO Country (Name, Code) VALUES ('Lao People's Democratic Republic', 'LA');
INSERT INTO Country (Name, Code) VALUES ('Latvia', 'LV');
INSERT INTO Country (Name, Code) VALUES ('Lebanon', 'LB');
INSERT INTO Country (Name, Code) VALUES ('Lesotho', 'LS');
INSERT INTO Country (Name, Code) VALUES ('Liberia', 'LR');
INSERT INTO Country (Name, Code) VALUES ('Libyan Arab Jamahiriya', 'LY');
INSERT INTO Country (Name, Code) VALUES ('Liechtenstein', 'LI');
INSERT INTO Country (Name, Code) VALUES ('Lithuania', 'LT');
INSERT INTO Country (Name, Code) VALUES ('Luxembourg', 'LU');
INSERT INTO Country (Name, Code) VALUES ('Macao', 'MO');
INSERT INTO Country (Name, Code) VALUES ('Macedonia, the Former Yugoslav Republic of', 'MK');
INSERT INTO Country (Name, Code) VALUES ('Madagascar', 'MG');
INSERT INTO Country (Name, Code) VALUES ('Malawi', 'MW');
INSERT INTO Country (Name, Code) VALUES ('Malaysia', 'MY');
INSERT INTO Country (Name, Code) VALUES ('Maldives', 'MV');
INSERT INTO Country (Name, Code) VALUES ('Mali', 'ML');
INSERT INTO Country (Name, Code) VALUES ('Malta', 'MT');
INSERT INTO Country (Name, Code) VALUES ('Marshall Islands', 'MH');
INSERT INTO Country (Name, Code) VALUES ('Martinique', 'MQ');
INSERT INTO Country (Name, Code) VALUES ('Mauritania', 'MR');
INSERT INTO Country (Name, Code) VALUES ('Mauritius', 'MU');
INSERT INTO Country (Name, Code) VALUES ('Mayotte', 'YT');
INSERT INTO Country (Name, Code) VALUES ('Mexico', 'MX');
INSERT INTO Country (Name, Code) VALUES ('Micronesia, Federated States of', 'FM');
INSERT INTO Country (Name, Code) VALUES ('Moldova, Republic of', 'MD');
INSERT INTO Country (Name, Code) VALUES ('Monaco', 'MC');
INSERT INTO Country (Name, Code) VALUES ('Mongolia', 'MN');
INSERT INTO Country (Name, Code) VALUES ('Montenegro', 'ME');
INSERT INTO Country (Name, Code) VALUES ('Montserrat', 'MS');
INSERT INTO Country (Name, Code) VALUES ('Morocco', 'MA');
INSERT INTO Country (Name, Code) VALUES ('Mozambique', 'MZ');
INSERT INTO Country (Name, Code) VALUES ('Myanmar', 'MM');
INSERT INTO Country (Name, Code) VALUES ('Namibia', 'NA');
INSERT INTO Country (Name, Code) VALUES ('Nauru', 'NR');
INSERT INTO Country (Name, Code) VALUES ('Nepal', 'NP');
INSERT INTO Country (Name, Code) VALUES ('Netherlands', 'NL');
INSERT INTO Country (Name, Code) VALUES ('Netherlands Antilles', 'AN');
INSERT INTO Country (Name, Code) VALUES ('New Caledonia', 'NC');
INSERT INTO Country (Name, Code) VALUES ('New Zealand', 'NZ');
INSERT INTO Country (Name, Code) VALUES ('Nicaragua', 'NI');
INSERT INTO Country (Name, Code) VALUES ('Niger', 'NE');
INSERT INTO Country (Name, Code) VALUES ('Nigeria', 'NG');
INSERT INTO Country (Name, Code) VALUES ('Niue', 'NU');
INSERT INTO Country (Name, Code) VALUES ('Norfolk Island', 'NF');
INSERT INTO Country (Name, Code) VALUES ('Northern Mariana Islands', 'MP');
INSERT INTO Country (Name, Code) VALUES ('Norway', 'NO');
INSERT INTO Country (Name, Code) VALUES ('Oman', 'OM');
INSERT INTO Country (Name, Code) VALUES ('Pakistan', 'PK');
INSERT INTO Country (Name, Code) VALUES ('Palau', 'PW');
INSERT INTO Country (Name, Code) VALUES ('Palestinian Territory, Occupied', 'PS');
INSERT INTO Country (Name, Code) VALUES ('Panama', 'PA');
INSERT INTO Country (Name, Code) VALUES ('Papua New Guinea', 'PG');
INSERT INTO Country (Name, Code) VALUES ('Paraguay', 'PY');
INSERT INTO Country (Name, Code) VALUES ('Peru', 'PE');
INSERT INTO Country (Name, Code) VALUES ('Philippines', 'PH');
INSERT INTO Country (Name, Code) VALUES ('Pitcairn', 'PN');
INSERT INTO Country (Name, Code) VALUES ('Poland', 'PL');
INSERT INTO Country (Name, Code) VALUES ('Portugal', 'PT');
INSERT INTO Country (Name, Code) VALUES ('Puerto Rico', 'PR');
INSERT INTO Country (Name, Code) VALUES ('Qatar', 'QA');
INSERT INTO Country (Name, Code) VALUES ('Reunion', 'RE');
INSERT INTO Country (Name, Code) VALUES ('Romania', 'RO');
INSERT INTO Country (Name, Code) VALUES ('Russian Federation', 'RU');
INSERT INTO Country (Name, Code) VALUES ('Rwanda', 'RW');
INSERT INTO Country (Name, Code) VALUES ('Saint Barthelemy', 'BL');
INSERT INTO Country (Name, Code) VALUES ('Saint Helena', 'SH');
INSERT INTO Country (Name, Code) VALUES ('Saint Kitts and Nevis', 'KN');
INSERT INTO Country (Name, Code) VALUES ('Saint Lucia', 'LC');
INSERT INTO Country (Name, Code) VALUES ('Saint Martin', 'MF');
INSERT INTO Country (Name, Code) VALUES ('Saint Pierre and Miquelon', 'PM');
INSERT INTO Country (Name, Code) VALUES ('Saint Vincent and the Grenadines', 'VC');
INSERT INTO Country (Name, Code) VALUES ('Samoa', 'WS');
INSERT INTO Country (Name, Code) VALUES ('San Marino', 'SM');
INSERT INTO Country (Name, Code) VALUES ('Sao Tome and Principe', 'ST');
INSERT INTO Country (Name, Code) VALUES ('Saudi Arabia', 'SA');
INSERT INTO Country (Name, Code) VALUES ('Senegal', 'SN');
INSERT INTO Country (Name, Code) VALUES ('Serbia', 'RS');
INSERT INTO Country (Name, Code) VALUES ('Serbia and Montenegro', 'CS');
INSERT INTO Country (Name, Code) VALUES ('Seychelles', 'SC');
INSERT INTO Country (Name, Code) VALUES ('Sierra Leone', 'SL');
INSERT INTO Country (Name, Code) VALUES ('Singapore', 'SG');
INSERT INTO Country (Name, Code) VALUES ('Sint Maarten', 'SX');
INSERT INTO Country (Name, Code) VALUES ('Slovakia', 'SK');
INSERT INTO Country (Name, Code) VALUES ('Slovenia', 'SI');
INSERT INTO Country (Name, Code) VALUES ('Solomon Islands', 'SB');
INSERT INTO Country (Name, Code) VALUES ('Somalia', 'SO');
INSERT INTO Country (Name, Code) VALUES ('South Africa', 'ZA');
INSERT INTO Country (Name, Code) VALUES ('South Georgia and the South Sandwich Islands', 'GS');
INSERT INTO Country (Name, Code) VALUES ('South Sudan', 'SS');
INSERT INTO Country (Name, Code) VALUES ('Spain', 'ES');
INSERT INTO Country (Name, Code) VALUES ('Sri Lanka', 'LK');
INSERT INTO Country (Name, Code) VALUES ('Sudan', 'SD');
INSERT INTO Country (Name, Code) VALUES ('Suriname', 'SR');
INSERT INTO Country (Name, Code) VALUES ('Svalbard and Jan Mayen', 'SJ');
INSERT INTO Country (Name, Code) VALUES ('Swaziland', 'SZ');
INSERT INTO Country (Name, Code) VALUES ('Sweden', 'SE');
INSERT INTO Country (Name, Code) VALUES ('Switzerland', 'CH');
INSERT INTO Country (Name, Code) VALUES ('Syrian Arab Republic', 'SY');
INSERT INTO Country (Name, Code) VALUES ('Taiwan, Province of China', 'TW');
INSERT INTO Country (Name, Code) VALUES ('Tajikistan', 'TJ');
INSERT INTO Country (Name, Code) VALUES ('Tanzania, United Republic of', 'TZ');
INSERT INTO Country (Name, Code) VALUES ('Thailand', 'TH');
INSERT INTO Country (Name, Code) VALUES ('Timor-Leste', 'TL');
INSERT INTO Country (Name, Code) VALUES ('Togo', 'TG');
INSERT INTO Country (Name, Code) VALUES ('Tokelau', 'TK');
INSERT INTO Country (Name, Code) VALUES ('Tonga', 'TO');
INSERT INTO Country (Name, Code) VALUES ('Trinidad and Tobago', 'TT');
INSERT INTO Country (Name, Code) VALUES ('Tunisia', 'TN');
INSERT INTO Country (Name, Code) VALUES ('Turkey', 'TR');
INSERT INTO Country (Name, Code) VALUES ('Turkmenistan', 'TM');
INSERT INTO Country (Name, Code) VALUES ('Turks and Caicos Islands', 'TC');
INSERT INTO Country (Name, Code) VALUES ('Tuvalu', 'TV');
INSERT INTO Country (Name, Code) VALUES ('Uganda', 'UG');
INSERT INTO Country (Name, Code) VALUES ('Ukraine', 'UA');
INSERT INTO Country (Name, Code) VALUES ('United Arab Emirates', 'AE');
INSERT INTO Country (Name, Code) VALUES ('United Kingdom', 'GB');
INSERT INTO Country (Name, Code) VALUES ('United States', 'US');
INSERT INTO Country (Name, Code) VALUES ('United States Minor Outlying Islands', 'UM');
INSERT INTO Country (Name, Code) VALUES ('Uruguay', 'UY');
INSERT INTO Country (Name, Code) VALUES ('Uzbekistan', 'UZ');
INSERT INTO Country (Name, Code) VALUES ('Vanuatu', 'VU');
INSERT INTO Country (Name, Code) VALUES ('Venezuela', 'VE');
INSERT INTO Country (Name, Code) VALUES ('Viet Nam', 'VN');
INSERT INTO Country (Name, Code) VALUES ('Virgin Islands, British', 'VG');
INSERT INTO Country (Name, Code) VALUES ('Virgin Islands, U.s.', 'VI');
INSERT INTO Country (Name, Code) VALUES ('Wallis and Futuna', 'WF');
INSERT INTO Country (Name, Code) VALUES ('Western Sahara', 'EH');
INSERT INTO Country (Name, Code) VALUES ('Yemen', 'YE');
INSERT INTO Country (Name, Code) VALUES ('Zambia', 'ZM');
INSERT INTO Country (Name, Code) VALUES ('Zimbabwe', 'ZW');
Thank for your great jobs
life savers y'all are
Thank you all!
json complete with country codes for phones
[
{
"code": "AF",
"id": "93",
"name": "Afghanistan (+93)"
},
{
"code": "AL",
"id": "355",
"name": "Albania (+355)"
},
{
"code": "DZ",
"id": "213",
"name": "Algeria (+213)"
},
{
"code": "AD",
"id": "376",
"name": "Andorra (+376)"
},
{
"code": "AO",
"id": "244",
"name": "Angola (+244)"
},
{
"code": "AG",
"id": "1268",
"name": "Antigua & Deps (+1268)"
},
{
"code": "AR",
"id": "54",
"name": "Argentina (+54)"
},
{
"code": "AM",
"id": "374",
"name": "Armenia (+374)"
},
{
"code": "AU",
"id": "61",
"name": "Australia (+61)"
},
{
"code": "AT",
"id": "43",
"name": "Austria (+43)"
},
{
"code": "AZ",
"id": "994",
"name": "Azerbaijan (+994)"
},
{
"code": "BS",
"id": "1242",
"name": "Bahamas (+1242)"
},
{
"code": "BH",
"id": "973",
"name": "Bahrain (+973)"
},
{
"code": "BD",
"id": "880",
"name": "Bangladesh (+880)"
},
{
"code": "BB",
"id": "1246",
"name": "Barbados (+1246)"
},
{
"code": "BY",
"id": "375",
"name": "Belarus (+375)"
},
{
"code": "BE",
"id": "32",
"name": "Belgium (+32)"
},
{
"code": "BZ",
"id": "501",
"name": "Belize (+501)"
},
{
"code": "BJ",
"id": "229",
"name": "Benin (+229)"
},
{
"code": "BM",
"id": "1",
"name": "Bermuda (+1-441)"
},
{
"code": "BT",
"id": "975",
"name": "Bhutan (+975)"
},
{
"code": "BO",
"id": "591",
"name": "Bolivia (+591)"
},
{
"code": "BA",
"id": "387",
"name": "Bosnia Herzegovina (+387)"
},
{
"code": "BW",
"id": "267",
"name": "Botswana (+267)"
},
{
"code": "BR",
"id": "55",
"name": "Brazil (+55)"
},
{
"code": "BN",
"id": "673",
"name": "Brunei (+673)"
},
{
"code": "BG",
"id": "359",
"name": "Bulgaria (+359)"
},
{
"code": "BF",
"id": "226",
"name": "Burkina Faso (+226)"
},
{
"code": "BI",
"id": "257",
"name": "Burundi (+257)"
},
{
"code": "KH",
"id": "855",
"name": "Cambodia (+855)"
},
{
"code": "CM",
"id": "237",
"name": "Cameroon (+237)"
},
{
"code": "CA",
"id": "1",
"name": "Canada (+1)"
},
{
"code": "CV",
"id": "238",
"name": "Cape Verde (+238)"
},
{
"code": "CF",
"id": "236",
"name": "Central African Rep (+236)"
},
{
"code": "TD",
"id": "235",
"name": "Chad (+235)"
},
{
"code": "CL",
"id": "56",
"name": "Chile (+56)"
},
{
"code": "CN",
"id": "86",
"name": "China (+86)"
},
{
"code": "CO",
"id": "57",
"name": "Colombia (+57)"
},
{
"code": "KM",
"id": "269",
"name": "Comoros (+269)"
},
{
"code": "CG",
"id": "242",
"name": "Congo (+242)"
},
{
"code": "CD",
"id": "243",
"name": "Congo (Democratic Rep) (+243)"
},
{
"code": "CR",
"id": "506",
"name": "Costa Rica (+506)"
},
{
"code": "HR",
"id": "385",
"name": "Croatia (+385)"
},
{
"code": "CU",
"id": "53",
"name": "Cuba (+53)"
},
{
"code": "CY",
"id": "357",
"name": "Cyprus (+357)"
},
{
"code": "CZ",
"id": "420",
"name": "Czech Republic (+420)"
},
{
"code": "DK",
"id": "45",
"name": "Denmark (+45)"
},
{
"code": "DJ",
"id": "253",
"name": "Djibouti (+253)"
},
{
"code": "DM",
"id": "1767",
"name": "Dominica (+1767)"
},
{
"code": "DO",
"id": "1809",
"name": "Dominican Republic (+1809)"
},
{
"code": "EC",
"id": "593",
"name": "Ecuador (+593)"
},
{
"code": "EG",
"id": "20",
"name": "Egypt (+20)"
},
{
"code": "SV",
"id": "503",
"name": "El Salvador (+503)"
},
{
"code": "GQ",
"id": "240",
"name": "Equatorial Guinea (+240)"
},
{
"code": "ER",
"id": "291",
"name": "Eritrea (+291)"
},
{
"code": "EE",
"id": "372",
"name": "Estonia (+372)"
},
{
"code": "ET",
"id": "251",
"name": "Ethiopia (+251)"
},
{
"code": "FI",
"id": "358",
"name": "Finland (+358)"
},
{
"code": "FR",
"id": "33",
"name": "France (+33)"
},
{
"code": "GA",
"id": "241",
"name": "Gabon (+241)"
},
{
"code": "GM",
"id": "220",
"name": "Gambia (+220)"
},
{
"code": "GE",
"id": "995",
"name": "Georgia (+995)"
},
{
"code": "DE",
"id": "49",
"name": "Germany (+49)"
},
{
"code": "GH",
"id": "233",
"name": "Ghana (+233)"
},
{
"code": "GR",
"id": "30",
"name": "Greece (+30)"
},
{
"code": "GD",
"id": "1-473",
"name": "Grenada (+1-473)"
},
{
"code": "GT",
"id": "502",
"name": "Guatemala (+502)"
},
{
"code": "GN",
"id": "224",
"name": "Guinea (+224)"
},
{
"code": "GW",
"id": "245",
"name": "Guinea-Bissau (+245)"
},
{
"code": "GY",
"id": "592",
"name": "Guyana (+592)"
},
{
"code": "HT",
"id": "509",
"name": "Haiti (+509)"
},
{
"code": "HN",
"id": "504",
"name": "Honduras (+504)"
},
{
"code": "HU",
"id": "36",
"name": "Hungary (+36)"
},
{
"code": "IS",
"id": "354",
"name": "Iceland (+354)"
},
{
"code": "IN",
"id": "91",
"name": "India (+91)"
},
{
"code": "ID",
"id": "62",
"name": "Indonesia (+62)"
},
{
"code": "IR",
"id": "98",
"name": "Iran (+98)"
},
{
"code": "IQ",
"id": "964",
"name": "Iraq (+964)"
},
{
"code": "IE",
"id": "353",
"name": "Ireland (Republic) (+353)"
},
{
"code": "IL",
"id": "972",
"name": "Israel (+972)"
},
{
"code": "IT",
"id": "39",
"name": "Italy (+39)"
},
{
"code": "CI",
"id": "225",
"name": "Ivory Coast (+225)"
},
{
"code": "JM",
"id": "1-876",
"name": "Jamaica (+1-876)"
},
{
"code": "JP",
"id": "81",
"name": "Japan (+81)"
},
{
"code": "JO",
"id": "962",
"name": "Jordan (+962)"
},
{
"code": "KZ",
"id": "7",
"name": "Kazakhstan (+7)"
},
{
"code": "KE",
"id": "254",
"name": "Kenya (+254)"
},
{
"code": "KI",
"id": "686",
"name": "Kiribati (+686)"
},
{
"code": "KP",
"id": "850",
"name": "Korea North (+850)"
},
{
"code": "KR",
"id": "82",
"name": "Korea South (+82)"
},
{
"code": "XK",
"id": "381",
"name": "Kosovo (+381)"
},
{
"code": "KW",
"id": "965",
"name": "Kuwait (+965)"
},
{
"code": "KG",
"id": "996",
"name": "Kyrgyzstan (+996)"
},
{
"code": "LA",
"id": "856",
"name": "Laos (+856)"
},
{
"code": "LV",
"id": "371",
"name": "Latvia (+371)"
},
{
"code": "LB",
"id": "961",
"name": "Lebanon (+961)"
},
{
"code": "LS",
"id": "266",
"name": "Lesotho (+266)"
},
{
"code": "LR",
"id": "231",
"name": "Liberia (+231)"
},
{
"code": "LY",
"id": "218",
"name": "Libya (+218)"
},
{
"code": "LI",
"id": "423",
"name": "Liechtenstein (+423)"
},
{
"code": "LT",
"id": "370",
"name": "Lithuania (+370)"
},
{
"code": "LU",
"id": "352",
"name": "Luxembourg (+352)"
},
{
"code": "MK",
"id": "389",
"name": "Macedonia (+389)"
},
{
"code": "MG",
"id": "261",
"name": "Madagascar (+261)"
},
{
"code": "MW",
"id": "265",
"name": "Malawi (+265)"
},
{
"code": "MY",
"id": "60",
"name": "Malaysia (+60)"
},
{
"code": "MV",
"id": "960",
"name": "Maldives (+960)"
},
{
"code": "ML",
"id": "223",
"name": "Mali (+223)"
},
{
"code": "MT",
"id": "356",
"name": "Malta (+356)"
},
{
"code": "MH",
"id": "692",
"name": "Marshall Islands (+692)"
},
{
"code": "MR",
"id": "222",
"name": "Mauritania (+222)"
},
{
"code": "MU",
"id": "230",
"name": "Mauritius (+230)"
},
{
"code": "MX",
"id": "52",
"name": "Mexico (+52)"
},
{
"code": "FM",
"id": "691",
"name": "Micronesia (+691)"
},
{
"code": "MD",
"id": "373",
"name": "Moldova (+373)"
},
{
"code": "MC",
"id": "377",
"name": "Monaco (+377)"
},
{
"code": "MN",
"id": "976",
"name": "Mongolia (+976)"
},
{
"code": "ME",
"id": "382",
"name": "Montenegro (+382)"
},
{
"code": "MA",
"id": "212",
"name": "Morocco (+212)"
},
{
"code": "MZ",
"id": "258",
"name": "Mozambique (+258)"
},
{
"code": "MM",
"id": "95",
"name": "Myanmar (+95)"
},
{
"code": "NA",
"id": "264",
"name": "Namibia (+264)"
},
{
"code": "NR",
"id": "674",
"name": "Nauru (+674)"
},
{
"code": "NP",
"id": "977",
"name": "Nepal (+977)"
},
{
"code": "NL",
"id": "31",
"name": "Netherlands (+31)"
},
{
"code": "NZ",
"id": "64",
"name": "New Zealand (+64)"
},
{
"code": "NI",
"id": "505",
"name": "Nicaragua (+505)"
},
{
"code": "NE",
"id": "227",
"name": "Niger (+227)"
},
{
"code": "NG",
"id": "234",
"name": "Nigeria (+234)"
},
{
"code": "NO",
"id": "47",
"name": "Norway (+47)"
},
{
"code": "OM",
"id": "968",
"name": "Oman (+968)"
},
{
"code": "PK",
"id": "92",
"name": "Pakistan (+92)"
},
{
"code": "PW",
"id": "680",
"name": "Palau (+680)"
},
{
"code": "PA",
"id": "507",
"name": "Panama (+507)"
},
{
"code": "PG",
"id": "675",
"name": "Papua New Guinea (+675)"
},
{
"code": "PY",
"id": "595",
"name": "Paraguay (+595)"
},
{
"code": "PE",
"id": "51",
"name": "Peru (+51)"
},
{
"code": "PH",
"id": "63",
"name": "Philippines (+63)"
},
{
"code": "PL",
"id": "48",
"name": "Poland (+48)"
},
{
"code": "PT",
"id": "351",
"name": "Portugal (+351)"
},
{
"code": "QA",
"id": "974",
"name": "Qatar (+974)"
},
{
"code": "RO",
"id": "40",
"name": "Romania (+40)"
},
{
"code": "RU",
"id": "7",
"name": "Russia (+7)"
},
{
"code": "RW",
"id": "250",
"name": "Rwanda (+250)"
},
{
"code": "KN",
"id": "1",
"name": "St Kitts & Nevis (+1)"
},
{
"code": "LC",
"id": "1",
"name": "St Lucia (+1)"
},
{
"code": "VC",
"id": "1",
"name": "Saint Vincent & the Grenadines (+1)"
},
{
"code": "WS",
"id": "685",
"name": "Samoa (+685)"
},
{
"code": "SM",
"id": "378",
"name": "San Marino (+378)"
},
{
"code": "ST",
"id": "239",
"name": "Sao Tome & Principe (+239)"
},
{
"code": "SA",
"id": "966",
"name": "Saudi Arabia (+966)"
},
{
"code": "SN",
"id": "221",
"name": "Senegal (+221)"
},
{
"code": "RS",
"id": "381",
"name": "Serbia (+381)"
},
{
"code": "SC",
"id": "248",
"name": "Seychelles (+248)"
},
{
"code": "SL",
"id": "232",
"name": "Sierra Leone (+232)"
},
{
"code": "SG",
"id": "65",
"name": "Singapore (+65)"
},
{
"code": "SK",
"id": "421",
"name": "Slovakia (+421)"
},
{
"code": "SI",
"id": "386",
"name": "Slovenia (+386)"
},
{
"code": "SB",
"id": "677",
"name": "Solomon Islands (+677)"
},
{
"code": "SO",
"id": "252",
"name": "Somalia (+252)"
},
{
"code": "ZA",
"id": "27",
"name": "South Africa (+27)"
},
{
"code": "SS",
"id": "211",
"name": "South Sudan (+211)"
},
{
"code": "ES",
"id": "34",
"name": "Spain (+34)"
},
{
"code": "LK",
"id": "94",
"name": "Sri Lanka (+94)"
},
{
"code": "SD",
"id": "249",
"name": "Sudan (+249)"
},
{
"code": "SR",
"id": "597",
"name": "Suriname (+597)"
},
{
"code": "SZ",
"id": "268",
"name": "Swaziland (+268)"
},
{
"code": "SE",
"id": "46",
"name": "Sweden (+46)"
},
{
"code": "CH",
"id": "41",
"name": "Switzerland (+41)"
},
{
"code": "SY",
"id": "963",
"name": "Syria (+963)"
},
{
"code": "TW",
"id": "886",
"name": "Taiwan (+886)"
},
{
"code": "TJ",
"id": "992",
"name": "Tajikistan (+992)"
},
{
"code": "TZ",
"id": "255",
"name": "Tanzania (+255)"
},
{
"code": "TH",
"id": "66",
"name": "Thailand (+66)"
},
{
"code": "TG",
"id": "228",
"name": "Togo (+228)"
},
{
"code": "TO",
"id": "676",
"name": "Tonga (+676)"
},
{
"code": "TT",
"id": "1",
"name": "Trinidad & Tobago (+1)"
},
{
"code": "TN",
"id": "216",
"name": "Tunisia (+216)"
},
{
"code": "TR",
"id": "90",
"name": "Turkey (+90)"
},
{
"code": "TM",
"id": "993",
"name": "Turkmenistan (+993)"
},
{
"code": "TV",
"id": "688",
"name": "Tuvalu (+688)"
},
{
"code": "UG",
"id": "256",
"name": "Uganda (+256)"
},
{
"code": "UA",
"id": "380",
"name": "Ukraine (+380)"
},
{
"code": "AE",
"id": "971",
"name": "United Arab Emirates (+971)"
},
{
"code": "GB",
"id": "44",
"name": "United Kingdom (+44)"
},
{
"code": "US",
"id": "1",
"name": "United States (+1)"
},
{
"code": "UY",
"id": "598",
"name": "Uruguay (+598)"
},
{
"code": "UZ",
"id": "998",
"name": "Uzbekistan (+998)"
},
{
"code": "VU",
"id": "678",
"name": "Vanuatu (+678)"
},
{
"code": "VA",
"id": "379",
"name": "Vatican City (+379)"
},
{
"code": "VE",
"id": "58",
"name": "Venezuela (+58)"
},
{
"code": "VN",
"id": "84",
"name": "Vietnam (+84)"
},
{
"code": "YE",
"id": "967",
"name": "Yemen (+967)"
},
{
"code": "ZM",
"id": "260",
"name": "Zambia (+260)"
},
{
"code": "ZW",
"id": "263",
"name": "Zimbabwe (+263)"
}
]
Bermuda is missing and it's +1