Skip to content

Instantly share code, notes, and snippets.

@freaz
Last active August 29, 2015 14:01
Show Gist options
  • Save freaz/0c7d052a3515350e3580 to your computer and use it in GitHub Desktop.
Save freaz/0c7d052a3515350e3580 to your computer and use it in GitHub Desktop.
MySQL insert with Countries list
INSERT INTO `countries` (`code`, `name`) VALUES
("AF", "Afghanistan (افغانستان‎)"),
("AX", "Aland Islands"),
("AL", "Albania (Shqipëria)"),
("DZ", "Algeria (الجزائر‎)"),
("AS", "American Samoa"),
("AD", "Andorra"),
("AO", "Angola"),
("AI", "Anguilla"),
("AQ", "Antarctica"),
("AG", "Antigua and Barbuda"),
("AR", "Argentina"),
("AM", "Armenia (Հայաստան)"),
("AW", "Aruba"),
("AU", "Australia"),
("AT", "Austria (Österreich)"),
("AZ", "Azerbaijan (Azərbaycan)"),
("BS", "Bahamas"),
("BH", "Bahrain (البحرين‎)"),
("BD", "Bangladesh (বাংলাদেশ)"),
("BB", "Barbados"),
("BY", "Belarus (Беларусь)"),
("BE", "Belgium (België)"),
("BZ", "Belize"),
("BJ", "Benin (Bénin)"),
("BM", "Bermuda"),
("BT", "Bhutan (འབྲུག)"),
("BO", "Bolivia,Plurinational State of"),
("BQ", "Bonaire,Sint Eustatius and Saba"),
("BA", "Bosnia and Herzegovina (Босна и Херцеговина)"),
("BW", "Botswana"),
("BV", "Bouvet Island"),
("BR", "Brazil (Brasil)"),
("IO", "British Indian Ocean Territory"),
("BN", "Brunei Darussalam"),
("BG", "Bulgaria (България)"),
("BF", "Burkina Faso"),
("BI", "Burundi (Uburundi)"),
("KH", "Cambodia (កម្ពុជា)"),
("CM", "Cameroon (Cameroun)"),
("CA", "Canada"),
("CV", "Cape Verde (Kabu Verdi)"),
("KY", "Cayman Islands"),
("CF", "Central African Republic (République centrafricaine)"),
("TD", "Chad (Tchad)"),
("CL", "Chile"),
("CN", "China (中国)"),
("CX", "Christmas Island"),
("CC", "Cocos (Keeling) Islands"),
("CO", "Colombia"),
("KM", "Comoros (جزر القمر‎)"),
("CG", "Congo (Congo-Brazzaville)"),
("CD", "Congo,the Democratic Republic of the (Jamhuri ya Kidemokrasia ya Kongo)"),
("CK", "Cook Islands"),
("CR", "Costa Rica"),
("CI", "Cote d'Ivoire"),
("HR", "Croatia (Hrvatska)"),
("CU", "Cuba"),
("CW", "Curacao"),
("CY", "Cyprus (Κύπρος)"),
("CZ", "Czech Republic (Česká republika)"),
("DK", "Denmark (Danmark)"),
("DJ", "Djibouti"),
("DM", "Dominica"),
("DO", "Dominican Republic (República Dominicana)"),
("EC", "Ecuador"),
("EG", "Egypt (مصر‎)"),
("SV", "El Salvador"),
("GQ", "Equatorial Guinea (Guinea Ecuatorial)"),
("ER", "Eritrea"),
("EE", "Estonia (Eesti)"),
("ET", "Ethiopia"),
("FK", "Falkland Islands (Islas Malvinas)"),
("FO", "Faroe Islands (Føroyar)"),
("FJ", "Fiji"),
("FI", "Finland (Suomi)"),
("FR", "France"),
("GF", "French Guiana (Guyane française)"),
("PF", "French Polynesia (Polynésie française)"),
("TF", "French Southern Territories (Terres australes françaises)"),
("GA", "Gabon"),
("GM", "Gambia"),
("GE", "Georgia (საქართველო)"),
("DE", "Germany (Deutschland)"),
("GH", "Ghana (Gaana)"),
("GI", "Gibraltar"),
("GR", "Greece (Ελλάδα)"),
("GL", "Greenland (Kalaallit Nunaat)"),
("GD", "Grenada"),
("GP", "Guadeloupe"),
("GU", "Guam"),
("GT", "Guatemala"),
("GG", "Guernsey"),
("GN", "Guinea (Guinée)"),
("GW", "Guinea-Bissau (Guiné Bissau)"),
("GY", "Guyana"),
("HT", "Haiti"),
("HM", "Heard Island and McDonald Islands"),
("VA", "Holy See (Vatican City State) (Città del Vaticano)"),
("HN", "Honduras"),
("HK", "Hong Kong (香港)"),
("HU", "Hungary (Magyarország)"),
("IS", "Iceland (Ísland)"),
("IN", "India (भारत)"),
("ID", "Indonesia"),
("IR", "Iran,Islamic Republic of (ایران‎)"),
("IQ", "Iraq (العراق‎)"),
("IE", "Ireland"),
("IM", "Isle of Man"),
("IL", "Israel (ישראל‎)"),
("IT", "Italy (Italia)"),
("JM", "Jamaica"),
("JP", "Japan (日本)"),
("JE", "Jersey"),
("JO", "Jordan (الأردن‎)"),
("KZ", "Kazakhstan (Казахстан)"),
("KE", "Kenya"),
("KI", "Kiribati"),
("KP", "Korea,Democratic People's Republic of (조선 민주주의 인민 공화국)"),
("KR", "Korea,Republic of (대한민국)"),
("KW", "Kuwait (الكويت‎)"),
("KG", "Kyrgyzstan"),
("LA", "Lao People's Democratic Republic (ສ.ປ.ປ ລາວ)"),
("LV", "Latvia (Latvija)"),
("LB", "Lebanon (لبنان‎)"),
("LS", "Lesotho"),
("LR", "Liberia"),
("LY", "Libya (ليبيا‎)"),
("LI", "Liechtenstein"),
("LT", "Lithuania (Lietuva)"),
("LU", "Luxembourg"),
("MO", "Macao (澳門)"),
("MK", "Macedonia,the former Yugoslav Republic of (Македонија)"),
("MG", "Madagascar (Madagasikara)"),
("MW", "Malawi"),
("MY", "Malaysia"),
("MV", "Maldives"),
("ML", "Mali"),
("MT", "Malta"),
("MH", "Marshall Islands"),
("MQ", "Martinique"),
("MR", "Mauritania (موريتانيا‎)"),
("MU", "Mauritius (Moris)"),
("YT", "Mayotte"),
("MX", "Mexico (México)"),
("FM", "Micronesia,Federated States of"),
("MD", "Moldova,Republic of (Republica Moldova)"),
("MC", "Monaco"),
("MN", "Mongolia (Монгол)"),
("ME", "Montenegro (Crna Gora)"),
("MS", "Montserrat"),
("MA", "Morocco (المغرب‎)"),
("MZ", "Mozambique (Moçambique)"),
("MM", "Myanmar (မြန်မာ)"),
("NA", "Namibia"),
("NR", "Nauru"),
("NP", "Nepal (नेपाल)"),
("NL", "Netherlands (Nederland)"),
("NC", "New Caledonia (Nouvelle-Calédonie)"),
("NZ", "New Zealand"),
("NI", "Nicaragua"),
("NE", "Niger (Nijar)"),
("NG", "Nigeria"),
("NU", "Niue"),
("NF", "Norfolk Island"),
("MP", "Northern Mariana Islands"),
("NO", "Norway (Norge)"),
("OM", "Oman (عُمان‎)"),
("PK", "Pakistan (پاکستان‎)"),
("PW", "Palau"),
("PS", "Palestine,State of (فلسطين‎)"),
("PA", "Panama (Panamá)"),
("PG", "Papua New Guinea"),
("PY", "Paraguay"),
("PE", "Peru"),
("PH", "Philippines"),
("PN", "Pitcairn"),
("PL", "Poland (Polska)"),
("PT", "Portugal"),
("PR", "Puerto Rico"),
("QA", "Qatar (قطر‎)"),
("RE", "Reunion"),
("RO", "Romania (România)"),
("RU", "Russian Federation (Россия)"),
("RW", "Rwanda"),
("SH", "Saint Helena,Ascension and Tristan da Cunha"),
("KN", "Saint Kitts and Nevis"),
("LC", "Saint Lucia"),
("MF", "Saint Martin [French part] (Saint-Martin [partie française])"),
("PM", "Saint Pierre and Miquelon (Saint-Pierre-et-Miquelon)"),
("VC", "Saint Vincent and the Grenadines"),
("WS", "Samoa"),
("SM", "San Marino"),
("ST", "Sao Tome and Principe (São Tomé e Príncipe)"),
("SA", "Saudi Arabia (المملكة العربية السعودية‎)"),
("SN", "Senegal (Sénégal)"),
("RS", "Serbia (Србија)"),
("SC", "Seychelles"),
("SL", "Sierra Leone"),
("SG", "Singapore"),
("SX", "Sint Maarten (Dutch part)"),
("SK", "Slovakia (Slovensko)"),
("SI", "Slovenia (Slovenija)"),
("SB", "Solomon Islands"),
("SO", "Somalia (Soomaaliya)"),
("ZA", "South Africa"),
("GS", "South Georgia and the South Sandwich Islands"),
("SS", "South Sudan (جنوب السودان‎)"),
("ES", "Spain"),
("LK", "Sri Lanka (ශ්‍රී ලංකාව))"),
("BL", "St Barths (Saint-Barthélemy)"),
("SD", "Sudan (السودان‎)"),
("SR", "Suriname"),
("SJ", "Svalbard and Jan Mayen (Svalbard og Jan Mayen)"),
("SZ", "Swaziland"),
("SE", "Sweden (Sverige)"),
("CH", "Switzerland (Schweiz)"),
("SY", "Syrian Arab Republic (سوريا‎)"),
("TW", "Taiwan (台灣)"),
("TJ", "Tajikistan"),
("TZ", "Tanzania,United Republic of"),
("TH", "Thailand (ไทย)"),
("TL", "Timor-Leste"),
("TG", "Togo"),
("TK", "Tokelau"),
("TO", "Tonga"),
("TT", "Trinidad and Tobago"),
("TN", "Tunisia (تونس‎)"),
("TR", "Turkey (Türkiye)"),
("TM", "Turkmenistan"),
("TC", "Turks and Caicos Islands"),
("TV", "Tuvalu"),
("UG", "Uganda"),
("UA", "Ukraine (Україна)"),
("AE", "United Arab Emirates (الإمارات العربية المتحدة‎)"),
("GB", "United Kingdom"),
("US", "United States"),
("UM", "United States Minor Outlying Islands"),
("UY", "Uruguay"),
("UZ", "Uzbekistan (Ўзбекистон)"),
("VU", "Vanuatu"),
("VE", "Venezuela,Bolivarian Republic of"),
("VN", "Vietnam (Việt Nam)"),
("VG", "Virgin Islands,British"),
("VI", "Virgin Islands,U.S."),
("WF", "Wallis and Futuna"),
("EH", "Western Sahara (الصحراء الغربية‎)"),
("YE", "Yemen (اليمن‎)"),
("ZM", "Zambia"),
("ZW", "Zimbabwe");
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment