MySQL Table of all Countries in Spanish

Last Updated: 7 April 2012

The below-linked MySQL script coordinates with my MySQL Table of all Countries, which contains the ISO2, ISO3, ISO numerical codes, calling codes, and ccTLDs, as well as the English short and long names for the countries shown below. This script adds Spanish short names as another field in the database. The script must be used with my English script, unless you already have a database containing all of the names on the list with a unique field for the ISO2 code.

Note: All of the letters which are not found on a standard US keyboard are saved as HTML character entities. For example, ñ is ñ — If you prefer to use UTF-8 (or another encoding) for your characters, you’ll need to adjust the script accordingly.

Another note: I created this table because someone asked me to, not because I’m an expert on the topic of Spanish-language country names! I’m not even close to being a native Spanish-speaker—I did pretty well in high school Spanish, and can muddle through children’s books, but Don Quixote in fourth-year Spanish just about killed me (I suspect it might do that to some native speakers as well, though!). So if I’ve made any horrific errors, please feel free to point them out.

Link to Spanish Country Names Update Script File: add-spanish-country-names-to-database.sql.txt

Flag English Short Name English Long Name Spanish Short Name
Flag of Afghanistan Afghanistan Islamic Republic of Afghanistan Afganistán
Flag of Aland Islands Aland Islands Åland Islands Islas Âland
Flag of Albania Albania Republic of Albania Albania
Flag of Algeria Algeria People’s Democratic Republic of Algeria Argelia
Flag of American Samoa American Samoa American Samoa Samoa Americana
Flag of Andorra Andorra Principality of Andorra Andorra
Flag of Angola Angola Republic of Angola Angola
Flag of Anguilla Anguilla Anguilla Anguilla
Flag of Antarctica Antarctica Antarctica Antártida
Flag of Antigua and Barbuda Antigua and Barbuda Antigua and Barbuda Antigua y Barbuda
Flag of Argentina Argentina Argentine Republic Argentina
Flag of Armenia Armenia Republic of Armenia Armenia
Flag of Aruba Aruba Aruba Aruba
Flag of Australia Australia Commonwealth of Australia Australia
Flag of Austria Austria Republic of Austria Austria
Flag of Azerbaijan Azerbaijan Republic of Azerbaijan Azerbaiyán
Flag of Bahamas Bahamas Commonwealth of The Bahamas Bahamas
Flag of Bahrain Bahrain Kingdom of Bahrain Bahrein
Flag of Bangladesh Bangladesh People’s Republic of Bangladesh Bangladesh
Flag of Barbados Barbados Barbados Barbados
Flag of Belarus Belarus Republic of Belarus Bielorrusia
Flag of Belgium Belgium Kingdom of Belgium Bélgica
Flag of Belize Belize Belize Belice
Flag of Benin Benin Republic of Benin Benín
Flag of Bermuda Bermuda Bermuda Islands Bermudas
Flag of Bhutan Bhutan Kingdom of Bhutan Bután
Flag of Bolivia Bolivia Plurinational State of Bolivia Bolivia
Flag of Bonaire, Sint Eustatius and Saba Bonaire, Sint Eustatius and Saba Bonaire, Sint Eustatius and Saba Caribe Neerlandés
Flag of Bosnia and Herzegovina Bosnia and Herzegovina Bosnia and Herzegovina Bosnia-Herzegovina
Flag of Botswana Botswana Republic of Botswana Botswana
Flag of Bouvet Island Bouvet Island Bouvet Island Isla Bouvet
Flag of Brazil Brazil Federative Republic of Brazil Brasil
Flag of British Indian Ocean Territory British Indian Ocean Territory British Indian Ocean Territory Territorio Británico del Océano Indico
Flag of Brunei Brunei Brunei Darussalam Brunei Darussalam
Flag of Bulgaria Bulgaria Republic of Bulgaria Bulgaria
Flag of Burkina Faso Burkina Faso Burkina Faso Burkina Faso
Flag of Burundi Burundi Republic of Burundi Burundi
Flag of Cambodia Cambodia Kingdom of Cambodia Camboya
Flag of Cameroon Cameroon Republic of Cameroon Camerún
Flag of Canada Canada Canada Canadá
Flag of Cape Verde Cape Verde Republic of Cape Verde Cabo Verde
Flag of Cayman Islands Cayman Islands The Cayman Islands Islas Caimán
Flag of Central African Republic Central African Republic Central African Republic República Centroafricana
Flag of Chad Chad Republic of Chad Chad
Flag of Chile Chile Republic of Chile Chile
Flag of China China People’s Republic of China China
Flag of Christmas Island Christmas Island Christmas Island Isla de Navidad, Isla Christmas
Flag of Cocos (Keeling) Islands Cocos (Keeling) Islands Cocos (Keeling) Islands Islas Cocos
Flag of Colombia Colombia Republic of Colombia Colombia
Flag of Comoros Comoros Union of the Comoros Comores
Flag of Congo Congo Republic of the Congo República del Congo
Flag of Cook Islands Cook Islands Cook Islands Islas Cook
Flag of Costa Rica Costa Rica Republic of Costa Rica Costa Rica
Flag of Cote d'ivoire (Ivory Coast) Cote d’ivoire (Ivory Coast) Republic of Côte D’Ivoire (Ivory Coast) Costa de Marfil
Flag of Croatia Croatia Republic of Croatia Croacia
Flag of Cuba Cuba Republic of Cuba Cuba
Flag of Curacao Curacao Curaçao Curazao
Flag of Cyprus Cyprus Republic of Cyprus Chipre
Flag of Czech Republic Czech Republic Czech Republic República Checa
Flag of Democratic Republic of the Congo Democratic Republic of the Congo Democratic Republic of the Congo República Democrática del Congo
Flag of Denmark Denmark Kingdom of Denmark Dinamarca
Flag of Djibouti Djibouti Republic of Djibouti Djibouti
Flag of Dominica Dominica Commonwealth of Dominica Dominica
Flag of Dominican Republic Dominican Republic Dominican Republic República Dominicana
Flag of Ecuador Ecuador Republic of Ecuador Ecuador
Flag of Egypt Egypt Arab Republic of Egypt Egiipto
Flag of El Salvador El Salvador Republic of El Salvador El Salvador
Flag of Equatorial Guinea Equatorial Guinea Republic of Equatorial Guinea Guinea Ecuatorial
Flag of Eritrea Eritrea State of Eritrea Eritrea
Flag of Estonia Estonia Republic of Estonia Estonia
Flag of Ethiopia Ethiopia Federal Democratic Republic of Ethiopia Etiopía
Flag of Falkland Islands (Malvinas) Falkland Islands (Malvinas) The Falkland Islands (Malvinas) Islas Malvinas
Flag of Faroe Islands Faroe Islands The Faroe Islands Islas Feroe
Flag of Fiji Fiji Republic of Fiji Fiyi
Flag of Finland Finland Republic of Finland Finlandia
Flag of France France French Republic Francia
Flag of French Guiana French Guiana French Guiana Guayana Francesa
Flag of French Polynesia French Polynesia French Polynesia Polinesia Francesa
Flag of French Southern Territories French Southern Territories French Southern Territories Tierras Australes Frencesas
Flag of Gabon Gabon Gabonese Republic Gabón
Flag of Gambia Gambia Republic of The Gambia Gambia
Flag of Georgia Georgia Georgia Georgia
Flag of Germany Germany Federal Republic of Germany Alemania
Flag of Ghana Ghana Republic of Ghana Ghana
Flag of Gibraltar Gibraltar Gibraltar Gibraltar
Flag of Greece Greece Hellenic Republic Grecia
Flag of Greenland Greenland Greenland Groenlandia
Flag of Grenada Grenada Grenada Granada
Flag of Guadaloupe Guadaloupe Guadeloupe Guadalupe
Flag of Guam Guam Guam Guam
Flag of Guatemala Guatemala Republic of Guatemala Guatemala
Flag of Guernsey Guernsey Guernsey Guernsey
Flag of Guinea Guinea Republic of Guinea República Guinea
Flag of Guinea-Bissau Guinea-Bissau Republic of Guinea-Bissau Guinea Bissau
Flag of Guyana Guyana Co-operative Republic of Guyana Guyana
Flag of Haiti Haiti Republic of Haiti Haiti
Flag of Heard Island and McDonald Islands Heard Island and McDonald Islands Heard Island and McDonald Islands Islas de Heard y McDonald
Flag of Honduras Honduras Republic of Honduras Honduras
Flag of Hong Kong Hong Kong Hong Kong Hong Kong
Flag of Hungary Hungary Hungary Hungría
Flag of Iceland Iceland Republic of Iceland Islandia
Flag of India India Republic of India India
Flag of Indonesia Indonesia Republic of Indonesia Indonesia
Flag of Iran Iran Islamic Republic of Iran Irán
Flag of Iraq Iraq Republic of Iraq Iraq
Flag of Ireland Ireland Ireland Irlanda
Flag of Isle of Man Isle of Man Isle of Man Isla Man
Flag of Israel Israel State of Israel Israel
Flag of Italy Italy Italian Republic Italia
Flag of Jamaica Jamaica Jamaica Jamaica
Flag of Japan Japan Japan Japón
Flag of Jersey Jersey The Bailiwick of Jersey Jersey
Flag of Jordan Jordan Hashemite Kingdom of Jordan Jordania
Flag of Kazakhstan Kazakhstan Republic of Kazakhstan Kazajstán
Flag of Kenya Kenya Republic of Kenya Kenia
Flag of Kiribati Kiribati Republic of Kiribati Kiribati
Flag of Kosovo Kosovo Republic of Kosovo Kosovo
Flag of Kuwait Kuwait State of Kuwait Kuwait
Flag of Kyrgyzstan Kyrgyzstan Kyrgyz Republic Kirguistán
Flag of Laos Laos Lao People’s Democratic Republic Laos
Flag of Latvia Latvia Republic of Latvia Letonia
Flag of Lebanon Lebanon Republic of Lebanon Líbano
Flag of Lesotho Lesotho Kingdom of Lesotho Lesotho
Flag of Liberia Liberia Republic of Liberia Liberia
Flag of Libya Libya Libya Libia
Flag of Liechtenstein Liechtenstein Principality of Liechtenstein Liechtenstein
Flag of Lithuania Lithuania Republic of Lithuania Lituania
Flag of Luxembourg Luxembourg Grand Duchy of Luxembourg Luxemburgo
Flag of Macao Macao The Macao Special Administrative Region Macao
Flag of Macedonia Macedonia The Former Yugoslav Republic of Macedonia Macedonia
Flag of Madagascar Madagascar Republic of Madagascar Madagascar
Flag of Malawi Malawi Republic of Malawi Malawi
Flag of Malaysia Malaysia Malaysia Malasia
Flag of Maldives Maldives Republic of Maldives Maldivas
Flag of Mali Mali Republic of Mali Malí
Flag of Malta Malta Republic of Malta Malta
Flag of Marshall Islands Marshall Islands Republic of the Marshall Islands Islas Marshall
Flag of Martinique Martinique Martinique Martinica
Flag of Mauritania Mauritania Islamic Republic of Mauritania Mauritania
Flag of Mauritius Mauritius Republic of Mauritius Mauricio
Flag of Mayotte Mayotte Mayotte Mayotte
Flag of Mexico Mexico United Mexican States México
Flag of Micronesia Micronesia Federated States of Micronesia Micronesia
Flag of Moldava Moldava Republic of Moldova Modavia
Flag of Monaco Monaco Principality of Monaco Mónaco
Flag of Mongolia Mongolia Mongolia Mongolia
Flag of Montenegro Montenegro Montenegro Montenegro
Flag of Montserrat Montserrat Montserrat Montserrat
Flag of Morocco Morocco Kingdom of Morocco Marruecos
Flag of Mozambique Mozambique Republic of Mozambique Mozambique
Flag of Myanmar (Burma) Myanmar (Burma) Republic of the Union of Myanmar Myanmar (Birmania)
Flag of Namibia Namibia Republic of Namibia Namibia
Flag of Nauru Nauru Republic of Nauru Nauru
Flag of Nepal Nepal Federal Democratic Republic of Nepal Nepal
Flag of Netherlands Netherlands Kingdom of the Netherlands Países Bajos, Holanda
Flag of New Caledonia New Caledonia New Caledonia Nueva Caledonia
Flag of New Zealand New Zealand New Zealand Nueva Zelanda
Flag of Nicaragua Nicaragua Republic of Nicaragua Nicaragua
Flag of Niger Niger Republic of Niger Niger
Flag of Nigeria Nigeria Federal Republic of Nigeria Nigeria
Flag of Niue Niue Niue Niue
Flag of Norfolk Island Norfolk Island Norfolk Island Norfolk Island
Flag of North Korea North Korea Democratic People’s Republic of Korea Corea del Norte
Flag of Northern Mariana Islands Northern Mariana Islands Northern Mariana Islands Marianas del Norte
Flag of Norway Norway Kingdom of Norway Noruega
Flag of Oman Oman Sultanate of Oman Omáman
Flag of Pakistan Pakistan Islamic Republic of Pakistan Pakistán
Flag of Palau Palau Republic of Palau Palau
Flag of Palestine Palestine State of Palestine (or Occupied Palestinian Territory) Palestina
Flag of Panama Panama Republic of Panama Panamá
Flag of Papua New Guinea Papua New Guinea Independent State of Papua New Guinea Papúa-Nueva Guinea
Flag of Paraguay Paraguay Republic of Paraguay Paraguay
Flag of Peru Peru Republic of Peru Perú
Flag of Phillipines Phillipines Republic of the Philippines Filipinas
Flag of Pitcairn Pitcairn Pitcairn Isla Pitcairn
Flag of Poland Poland Republic of Poland Polonia
Flag of Portugal Portugal Portuguese Republic Portugal
Flag of Puerto Rico Puerto Rico Commonwealth of Puerto Rico Puerto Rico
Flag of Qatar Qatar State of Qatar Qatar
Flag of Reunion Reunion Réunion Reunión
Flag of Romania Romania Romania Rumania
Flag of Russia Russia Russian Federation Federación Rusa
Flag of Rwanda Rwanda Republic of Rwanda Ruanda
Flag of Saint Barthelemy Saint Barthelemy Saint Barthélemy San Barolomé
Flag of Saint Helena Saint Helena Saint Helena, Ascension and Tristan da Cunha Santa Elena
Flag of Saint Kitts and Nevis Saint Kitts and Nevis Federation of Saint Christopher and Nevis San Cristobal y Nevis
Flag of Saint Lucia Saint Lucia Saint Lucia Santa Lucía
Flag of Saint Martin Saint Martin Saint Martin San Martín
Flag of Saint Pierre and Miquelon Saint Pierre and Miquelon Saint Pierre and Miquelon San Pedro y Miquelón
Flag of Saint Vincent and the Grenadines Saint Vincent and the Grenadines Saint Vincent and the Grenadines San Vincente y Granadinas
Flag of Samoa Samoa Independent State of Samoa Samoa
Flag of San Marino San Marino Republic of San Marino San Marino
Flag of Sao Tome and Principe Sao Tome and Principe Democratic Republic of São Tomé and Príncipe San Tomé y Principe
Flag of Saudi Arabia Saudi Arabia Kingdom of Saudi Arabia Arabia Saudita
Flag of Senegal Senegal Republic of Senegal Senegal
Flag of Serbia Serbia Republic of Serbia Serbia
Flag of Seychelles Seychelles Republic of Seychelles Seychelles
Flag of Sierra Leone Sierra Leone Republic of Sierra Leone Sierra Leona
Flag of Singapore Singapore Republic of Singapore Singapur
Flag of Sint Maarten Sint Maarten Sint Maarten Sint Maarten
Flag of Slovakia Slovakia Slovak Republic Eslovaquia
Flag of Slovenia Slovenia Republic of Slovenia Eslovenia
Flag of Solomon Islands Solomon Islands Solomon Islands Islas Salomón
Flag of Somalia Somalia Somali Republic Somalia
Flag of South Africa South Africa Republic of South Africa Sudáfrica
Flag of South Georgia and the South Sandwich Islands South Georgia and the South Sandwich Islands South Georgia and the South Sandwich Islands Sudo Georgia y los Islas Sandwich del Sur
Flag of South Korea South Korea Republic of Korea Corea del Sur
Flag of South Sudan South Sudan Republic of South Sudan Sudán del Sur
Flag of Spain Spain Kingdom of Spain España
Flag of Sri Lanka Sri Lanka Democratic Socialist Republic of Sri Lanka Sri Lanka
Flag of Sudan Sudan Republic of the Sudan Sudán
Flag of Suriname Suriname Republic of Suriname Surinam
Flag of Svalbard and Jan Mayen Svalbard and Jan Mayen Svalbard and Jan Mayen Isla Jan Mayen y Archipiélago de Svalbard
Flag of Swaziland Swaziland Kingdom of Swaziland Swazilandia
Flag of Sweden Sweden Kingdom of Sweden Suecia
Flag of Switzerland Switzerland Swiss Confederation Suiza
Flag of Syria Syria Syrian Arab Republic Siria
Flag of Taiwan Taiwan Republic of China (Taiwan) Taiwan
Flag of Tajikistan Tajikistan Republic of Tajikistan Tadjikistan
Flag of Tanzania Tanzania United Republic of Tanzania Tanzania
Flag of Thailand Thailand Kingdom of Thailand Tailandia
Flag of Timor-Leste (East Timor) Timor-Leste (East Timor) Democratic Republic of Timor-Leste Timor Oriental
Flag of Togo Togo Togolese Republic Togo
Flag of Tokelau Tokelau Tokelau Tokelau
Flag of Tonga Tonga Kingdom of Tonga Tonga
Flag of Trinidad and Tobago Trinidad and Tobago Republic of Trinidad and Tobago Trinidad y Tobago
Flag of Tunisia Tunisia Republic of Tunisia Túez
Flag of Turkey Turkey Republic of Turkey Turquía
Flag of Turkmenistan Turkmenistan Turkmenistan Turkmenistan
Flag of Turks and Caicos Islands Turks and Caicos Islands Turks and Caicos Islands Islas Turcas y Caicos
Flag of Tuvalu Tuvalu Tuvalu Tuvalu
Flag of Uganda Uganda Republic of Uganda Uganda
Flag of Ukraine Ukraine Ukraine Ucrania
Flag of United Arab Emirates United Arab Emirates United Arab Emirates Emiratos Árebes Unidos
Flag of United Kingdom United Kingdom United Kingdom of Great Britain and Nothern Ireland Reino Unido
Flag of United States United States United States of America Estados Unidos
Flag of United States Minor Outlying Islands United States Minor Outlying Islands United States Minor Outlying Islands Islas ultramarinas menores de Estados Unidos
Flag of Uruguay Uruguay Eastern Republic of Uruguay Uruguay
Flag of Uzbekistan Uzbekistan Republic of Uzbekistan Uzbekistán
Flag of Vanuatu Vanuatu Republic of Vanuatu Vanuatu
Flag of Vatican City Vatican City State of the Vatican City Ciudad del Vaticano
Flag of Venezuela Venezuela Bolivarian Republic of Venezuela Venezuela
Flag of Vietnam Vietnam Socialist Republic of Vietnam Vietnam
Flag of Virgin Islands, British Virgin Islands, British British Virgin Islands Islas Virgenes Británicas
Flag of Virgin Islands, US Virgin Islands, US Virgin Islands of the United States Islas Virgenes Americanas
Flag of Wallis and Futuna Wallis and Futuna Wallis and Futuna Wallis y Futuna
Western Sahara Western Sahara Sáhara Occidental
Flag of Yemen Yemen Republic of Yemen Yemen
Flag of Zambia Zambia Republic of Zambia Zambia
Flag of Zimbabwe Zimbabwe Republic of Zimbabwe Zimbabwe