Country table data sql script

Fluxtah — Wed, 11 Nov 2009 13:07:31 GMT

It comes to that point in time when you need a country table in your database and you do not have a list to import at hand, after scouring the web a bit, everything seemed to be out of date, so I wrote a little script to scrape the details from a wikipedia page for the ISO 3166-1 standard for country codes.

I wrote and ran the following quick & dirty JQuery script on that page.

if($('#output_textarea').length ==
0){ $(document.body).append($('<textarea rows="128" id="output_textarea"></textarea>'));
} document.output_textarea_val = "";
$('#sortable_table_id_0 tr').each(function(idx){ if(idx
> 0){ document.output_textarea_val += "INSERT
INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("; var cells = $('td', this),
cellLen = cells.length;
cells.each(function(cellIdx){ if(cellIdx
< 4){ document.output_textarea_val += "\"" + $(this).text().trim() + "\""; if(cellIdx
< cellLen - 2){
document.output_textarea_val += ",
"; } } }); document.output_textarea_val += ');\n'; } }); $('#output_textarea').val(document.output_textarea_val);

This script creates insert statements for mySQL and inserts the results into a text box at the foot of the page, in order for it to work you need to inject jQuery into the document, you can do this with the jQueryify Bookmarklet.>>

I have tested this script and it qualifies for the "works on my machine" certification programme.

The script produces the following output.

INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Afghanistan", "AF", "AFG", "004"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Aland Islands Åland Islands", "AX", "ALA", "248"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Albania", "AL", "ALB", "008"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Algeria", "DZ", "DZA", "012"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("American Samoa", "AS", "ASM", "016"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Andorra", "AD", "AND", "020"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Angola", "AO", "AGO", "024"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Anguilla", "AI", "AIA", "660"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Antarctica", "AQ", "ATA", "010"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Antigua and Barbuda", "AG", "ATG", "028"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Argentina", "AR", "ARG", "032"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Armenia", "AM", "ARM", "051"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Aruba", "AW", "ABW", "533"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Australia", "AU", "AUS", "036"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Austria", "AT", "AUT", "040"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Azerbaijan", "AZ", "AZE", "031"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Bahamas", "BS", "BHS", "044"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Bahrain", "BH", "BHR", "048"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Bangladesh", "BD", "BGD", "050"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Barbados", "BB", "BRB", "052"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Belarus", "BY", "BLR", "112"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Belgium", "BE", "BEL", "056"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Belize", "BZ", "BLZ", "084"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Benin", "BJ", "BEN", "204"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Bermuda", "BM", "BMU", "060"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Bhutan", "BT", "BTN", "064"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Bolivia, Plurinational State of", "BO", "BOL", "068"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Bosnia and Herzegovina", "BA", "BIH", "070"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Botswana", "BW", "BWA", "072"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Bouvet Island", "BV", "BVT", "074"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Brazil", "BR", "BRA", "076"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("British Indian Ocean Territory", "IO", "IOT", "086"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Brunei Darussalam", "BN", "BRN", "096"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Bulgaria", "BG", "BGR", "100"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Burkina Faso", "BF", "BFA", "854"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Burundi", "BI", "BDI", "108"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Cambodia", "KH", "KHM", "116"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Cameroon", "CM", "CMR", "120"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Canada", "CA", "CAN", "124"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Cape Verde", "CV", "CPV", "132"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Cayman Islands", "KY", "CYM", "136"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Central African Republic", "CF", "CAF", "140"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Chad", "TD", "TCD", "148"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Chile", "CL", "CHL", "152"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("China", "CN", "CHN", "156"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Christmas Island", "CX", "CXR", "162"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Cocos (Keeling) Islands", "CC", "CCK", "166"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Colombia", "CO", "COL", "170"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Comoros", "KM", "COM", "174"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Congo", "CG", "COG", "178"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Congo, the Democratic Republic of the", "CD", "COD", "180"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Cook Islands", "CK", "COK", "184"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Costa Rica", "CR", "CRI", "188"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Cote d'Ivoire Côte d'Ivoire", "CI", "CIV", "384"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Croatia", "HR", "HRV", "191"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Cuba", "CU", "CUB", "192"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Cyprus", "CY", "CYP", "196"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Czech Republic", "CZ", "CZE", "203"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Denmark", "DK", "DNK", "208"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Djibouti", "DJ", "DJI", "262"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Dominica", "DM", "DMA", "212"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Dominican Republic", "DO", "DOM", "214"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Ecuador", "EC", "ECU", "218"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Egypt", "EG", "EGY", "818"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("El Salvador", "SV", "SLV", "222"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Equatorial Guinea", "GQ", "GNQ", "226"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Eritrea", "ER", "ERI", "232"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Estonia", "EE", "EST", "233"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Ethiopia", "ET", "ETH", "231"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Falkland Islands (Malvinas)", "FK", "FLK", "238"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Faroe Islands", "FO", "FRO", "234"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Fiji", "FJ", "FJI", "242"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Finland", "FI", "FIN", "246"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("France", "FR", "FRA", "250"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("French Guiana", "GF", "GUF", "254"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("French Polynesia", "PF", "PYF", "258"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("French Southern Territories", "TF", "ATF", "260"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Gabon", "GA", "GAB", "266"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Gambia", "GM", "GMB", "270"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Georgia", "GE", "GEO", "268"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Germany", "DE", "DEU", "276"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Ghana", "GH", "GHA", "288"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Gibraltar", "GI", "GIB", "292"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Greece", "GR", "GRC", "300"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Greenland", "GL", "GRL", "304"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Grenada", "GD", "GRD", "308"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Guadeloupe", "GP", "GLP", "312"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Guam", "GU", "GUM", "316"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Guatemala", "GT", "GTM", "320"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Guernsey", "GG", "GGY", "831"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Guinea", "GN", "GIN", "324"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Guinea-Bissau", "GW", "GNB", "624"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Guyana", "GY", "GUY", "328"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Haiti", "HT", "HTI", "332"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Heard Island and McDonald Islands", "HM", "HMD", "334"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Holy See (Vatican City State)", "VA", "VAT", "336"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Honduras", "HN", "HND", "340"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Hong Kong", "HK", "HKG", "344"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Hungary", "HU", "HUN", "348"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Iceland", "IS", "ISL", "352"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("India", "IN", "IND", "356"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Indonesia", "ID", "IDN", "360"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Iran, Islamic Republic of", "IR", "IRN", "364"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Iraq", "IQ", "IRQ", "368"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Ireland", "IE", "IRL", "372"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Isle of Man", "IM", "IMN", "833"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Israel", "IL", "ISR", "376"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Italy", "IT", "ITA", "380"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Jamaica", "JM", "JAM", "388"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Japan", "JP", "JPN", "392"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Jersey", "JE", "JEY", "832"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Jordan", "JO", "JOR", "400"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Kazakhstan", "KZ", "KAZ", "398"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Kenya", "KE", "KEN", "404"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Kiribati", "KI", "KIR", "296"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Korea, Democratic People's Republic of", "KP", "PRK", "408"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Korea, Republic of", "KR", "KOR", "410"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Kuwait", "KW", "KWT", "414"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Kyrgyzstan", "KG", "KGZ", "417"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Lao People's Democratic Republic", "LA", "LAO", "418"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Latvia", "LV", "LVA", "428"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Lebanon", "LB", "LBN", "422"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Lesotho", "LS", "LSO", "426"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Liberia", "LR", "LBR", "430"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Libyan Arab Jamahiriya", "LY", "LBY", "434"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Liechtenstein", "LI", "LIE", "438"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Lithuania", "LT", "LTU", "440"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Luxembourg", "LU", "LUX", "442"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Macao", "MO", "MAC", "446"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Macedonia, the former Yugoslav Republic of", "MK", "MKD", "807"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Madagascar", "MG", "MDG", "450"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Malawi", "MW", "MWI", "454"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Malaysia", "MY", "MYS", "458"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Maldives", "MV", "MDV", "462"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Mali", "ML", "MLI", "466"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Malta", "MT", "MLT", "470"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Marshall Islands", "MH", "MHL", "584"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Martinique", "MQ", "MTQ", "474"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Mauritania", "MR", "MRT", "478"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Mauritius", "MU", "MUS", "480"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Mayotte", "YT", "MYT", "175"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Mexico", "MX", "MEX", "484"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Micronesia, Federated States of", "FM", "FSM", "583"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Moldova, Republic of", "MD", "MDA", "498"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Monaco", "MC", "MCO", "492"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Mongolia", "MN", "MNG", "496"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Montenegro", "ME", "MNE", "499"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Montserrat", "MS", "MSR", "500"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Morocco", "MA", "MAR", "504"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Mozambique", "MZ", "MOZ", "508"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Myanmar", "MM", "MMR", "104"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Namibia", "NA", "NAM", "516"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Nauru", "NR", "NRU", "520"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Nepal", "NP", "NPL", "524"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Netherlands", "NL", "NLD", "528"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Netherlands Antilles", "AN", "ANT", "530"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("New Caledonia", "NC", "NCL", "540"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("New Zealand", "NZ", "NZL", "554"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Nicaragua", "NI", "NIC", "558"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Niger", "NE", "NER", "562"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Nigeria", "NG", "NGA", "566"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Niue", "NU", "NIU", "570"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Norfolk Island", "NF", "NFK", "574"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Northern Mariana Islands", "MP", "MNP", "580"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Norway", "NO", "NOR", "578"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Oman", "OM", "OMN", "512"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Pakistan", "PK", "PAK", "586"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Palau", "PW", "PLW", "585"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Palestinian Territory, Occupied", "PS", "PSE", "275"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Panama", "PA", "PAN", "591"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Papua New Guinea", "PG", "PNG", "598"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Paraguay", "PY", "PRY", "600"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Peru", "PE", "PER", "604"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Philippines", "PH", "PHL", "608"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Pitcairn", "PN", "PCN", "612"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Poland", "PL", "POL", "616"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Portugal", "PT", "PRT", "620"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Puerto Rico", "PR", "PRI", "630"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Qatar", "QA", "QAT", "634"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Reunion Réunion", "RE", "REU", "638"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Romania", "RO", "ROU", "642"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Russian Federation", "RU", "RUS", "643"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Rwanda", "RW", "RWA", "646"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Saint Barthélemy", "BL", "BLM", "652"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Saint Helena", "SH", "SHN", "654"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Saint Kitts and Nevis", "KN", "KNA", "659"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Saint Lucia", "LC", "LCA", "662"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Saint Martin (French part)", "MF", "MAF", "663"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Saint Pierre and Miquelon", "PM", "SPM", "666"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Saint Vincent and the Grenadines", "VC", "VCT", "670"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Samoa", "WS", "WSM", "882"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("San Marino", "SM", "SMR", "674"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Sao Tome and Principe", "ST", "STP", "678"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Saudi Arabia", "SA", "SAU", "682"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Senegal", "SN", "SEN", "686"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Serbia", "RS", "SRB", "688"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Seychelles", "SC", "SYC", "690"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Sierra Leone", "SL", "SLE", "694"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Singapore", "SG", "SGP", "702"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Slovakia", "SK", "SVK", "703"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Slovenia", "SI", "SVN", "705"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Solomon Islands", "SB", "SLB", "090"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Somalia", "SO", "SOM", "706"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("South Africa", "ZA", "ZAF", "710"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("South Georgia and the South Sandwich Islands", "GS", "SGS", "239"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Spain", "ES", "ESP", "724"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Sri Lanka", "LK", "LKA", "144"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Sudan", "SD", "SDN", "736"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Suriname", "SR", "SUR", "740"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Svalbard and Jan Mayen", "SJ", "SJM", "744"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Swaziland", "SZ", "SWZ", "748"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Sweden", "SE", "SWE", "752"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Switzerland", "CH", "CHE", "756"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Syrian Arab Republic", "SY", "SYR", "760"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Taiwan, Province of China", "TW", "TWN", "158"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Tajikistan", "TJ", "TJK", "762"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Tanzania, United Republic of", "TZ", "TZA", "834"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Thailand", "TH", "THA", "764"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Timor-Leste", "TL", "TLS", "626"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Togo", "TG", "TGO", "768"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Tokelau", "TK", "TKL", "772"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Tonga", "TO", "TON", "776"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Trinidad and Tobago", "TT", "TTO", "780"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Tunisia", "TN", "TUN", "788"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Turkey", "TR", "TUR", "792"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Turkmenistan", "TM", "TKM", "795"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Turks and Caicos Islands", "TC", "TCA", "796"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Tuvalu", "TV", "TUV", "798"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Uganda", "UG", "UGA", "800"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Ukraine", "UA", "UKR", "804"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("United Arab Emirates", "AE", "ARE", "784"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("United Kingdom", "GB", "GBR", "826"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("United States", "US", "USA", "840"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("United States Minor Outlying Islands", "UM", "UMI", "581"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Uruguay", "UY", "URY", "858"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Uzbekistan", "UZ", "UZB", "860"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Vanuatu", "VU", "VUT", "548"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Venezuela, Bolivarian Republic of", "VE", "VEN", "862"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Viet Nam", "VN", "VNM", "704"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Virgin Islands, British", "VG", "VGB", "092"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Virgin Islands, U.S.", "VI", "VIR", "850"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Wallis and Futuna", "WF", "WLF", "876"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Western Sahara", "EH", "ESH", "732"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Yemen", "YE", "YEM", "887"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Zambia", "ZM", "ZMB", "894"); INSERT INTO country (name, code_alpha_2, code_alpha_3, code_numeric) VALUES("Zimbabwe", "ZW", "ZWE", "716");

All things .NET and beyond - SQL

Country table data sql script