advanced code snippet search

Posted By

misteroneill on 08/23/09


Tagged

countries iso nations


Versions (?)

Who likes this?

7 people have marked this snippet as a favorite

NyX
nerdfiles
dantreacy
kubaitis
megadeth_tom
helloworlder
virendrakryadav


ISO Country List/Table

 / Published in: MySQL
 

URL: http://www.misteroneill.com

Pretty straightforward - some SQL to create a table called "countries" and populate it with an ISO standard list of countries.

Expand | Embed | Plain Text 
  1. CREATE TABLE IF NOT EXISTS countries (
  2. 	iso CHAR(2) NOT NULL PRIMARY KEY,
  3. 	name VARCHAR(80) NOT NULL,
  4. 	printable_name VARCHAR(80) NOT NULL,
  5. 	iso3 CHAR(3),
  6. 	numcode SMALLINT
  7. );
  8.  
  9. INSERT INTO countries VALUES ('AF','AFGHANISTAN','Afghanistan','AFG','004');
  10. INSERT INTO countries VALUES ('AL','ALBANIA','Albania','ALB','008');
  11. INSERT INTO countries VALUES ('DZ','ALGERIA','Algeria','DZA','012');
  12. INSERT INTO countries VALUES ('AS','AMERICAN SAMOA','American Samoa','ASM','016');
  13. INSERT INTO countries VALUES ('AD','ANDORRA','Andorra','AND','020');
  14. INSERT INTO countries VALUES ('AO','ANGOLA','Angola','AGO','024');
  15. INSERT INTO countries VALUES ('AI','ANGUILLA','Anguilla','AIA','660');
  16. INSERT INTO countries VALUES ('AQ','ANTARCTICA','Antarctica',NULL,NULL);
  17. INSERT INTO countries VALUES ('AG','ANTIGUA AND BARBUDA','Antigua and Barbuda','ATG','028');
  18. INSERT INTO countries VALUES ('AR','ARGENTINA','Argentina','ARG','032');
  19. INSERT INTO countries VALUES ('AM','ARMENIA','Armenia','ARM','051');
  20. INSERT INTO countries VALUES ('AW','ARUBA','Aruba','ABW','533');
  21. INSERT INTO countries VALUES ('AU','AUSTRALIA','Australia','AUS','036');
  22. INSERT INTO countries VALUES ('AT','AUSTRIA','Austria','AUT','040');
  23. INSERT INTO countries VALUES ('AZ','AZERBAIJAN','Azerbaijan','AZE','031');
  24. INSERT INTO countries VALUES ('BS','BAHAMAS','Bahamas','BHS','044');
  25. INSERT INTO countries VALUES ('BH','BAHRAIN','Bahrain','BHR','048');
  26. INSERT INTO countries VALUES ('BD','BANGLADESH','Bangladesh','BGD','050');
  27. INSERT INTO countries VALUES ('BB','BARBADOS','Barbados','BRB','052');
  28. INSERT INTO countries VALUES ('BY','BELARUS','Belarus','BLR','112');
  29. INSERT INTO countries VALUES ('BE','BELGIUM','Belgium','BEL','056');
  30. INSERT INTO countries VALUES ('BZ','BELIZE','Belize','BLZ','084');
  31. INSERT INTO countries VALUES ('BJ','BENIN','Benin','BEN','204');
  32. INSERT INTO countries VALUES ('BM','BERMUDA','Bermuda','BMU','060');
  33. INSERT INTO countries VALUES ('BT','BHUTAN','Bhutan','BTN','064');
  34. INSERT INTO countries VALUES ('BO','BOLIVIA','Bolivia','BOL','068');
  35. INSERT INTO countries VALUES ('BA','BOSNIA AND HERZEGOVINA','Bosnia and Herzegovina','BIH','070');
  36. INSERT INTO countries VALUES ('BW','BOTSWANA','Botswana','BWA','072');
  37. INSERT INTO countries VALUES ('BV','BOUVET ISLAND','Bouvet Island',NULL,NULL);
  38. INSERT INTO countries VALUES ('BR','BRAZIL','Brazil','BRA','076');
  39. INSERT INTO countries VALUES ('IO','BRITISH INDIAN OCEAN TERRITORY','British Indian Ocean Territory',NULL,NULL);
  40. INSERT INTO countries VALUES ('BN','BRUNEI DARUSSALAM','Brunei Darussalam','BRN','096');
  41. INSERT INTO countries VALUES ('BG','BULGARIA','Bulgaria','BGR','100');
  42. INSERT INTO countries VALUES ('BF','BURKINA FASO','Burkina Faso','BFA','854');
  43. INSERT INTO countries VALUES ('BI','BURUNDI','Burundi','BDI','108');
  44. INSERT INTO countries VALUES ('KH','CAMBODIA','Cambodia','KHM','116');
  45. INSERT INTO countries VALUES ('CM','CAMEROON','Cameroon','CMR','120');
  46. INSERT INTO countries VALUES ('CA','CANADA','Canada','CAN','124');
  47. INSERT INTO countries VALUES ('CV','CAPE VERDE','Cape Verde','CPV','132');
  48. INSERT INTO countries VALUES ('KY','CAYMAN ISLANDS','Cayman Islands','CYM','136');
  49. INSERT INTO countries VALUES ('CF','CENTRAL AFRICAN REPUBLIC','Central African Republic','CAF','140');
  50. INSERT INTO countries VALUES ('TD','CHAD','Chad','TCD','148');
  51. INSERT INTO countries VALUES ('CL','CHILE','Chile','CHL','152');
  52. INSERT INTO countries VALUES ('CN','CHINA','China','CHN','156');
  53. INSERT INTO countries VALUES ('CX','CHRISTMAS ISLAND','Christmas Island',NULL,NULL);
  54. INSERT INTO countries VALUES ('CC','COCOS (KEELING) ISLANDS','Cocos (Keeling) Islands',NULL,NULL);
  55. INSERT INTO countries VALUES ('CO','COLOMBIA','Colombia','COL','170');
  56. INSERT INTO countries VALUES ('KM','COMOROS','Comoros','COM','174');
  57. INSERT INTO countries VALUES ('CG','CONGO','Congo','COG','178');
  58. INSERT INTO countries VALUES ('CD','CONGO, THE DEMOCRATIC REPUBLIC OF THE','Congo, the Democratic Republic of the','COD','180');
  59. INSERT INTO countries VALUES ('CK','COOK ISLANDS','Cook Islands','COK','184');
  60. INSERT INTO countries VALUES ('CR','COSTA RICA','Costa Rica','CRI','188');
  61. INSERT INTO countries VALUES ('CI','COTE D\'IVOIRE','Cote D\'Ivoire','CIV','384');
  62. INSERT INTO countries VALUES ('HR','CROATIA','Croatia','HRV','191');
  63. INSERT INTO countries VALUES ('CU','CUBA','Cuba','CUB','192');
  64. INSERT INTO countries VALUES ('CY','CYPRUS','Cyprus','CYP','196');
  65. INSERT INTO countries VALUES ('CZ','CZECH REPUBLIC','Czech Republic','CZE','203');
  66. INSERT INTO countries VALUES ('DK','DENMARK','Denmark','DNK','208');
  67. INSERT INTO countries VALUES ('DJ','DJIBOUTI','Djibouti','DJI','262');
  68. INSERT INTO countries VALUES ('DM','DOMINICA','Dominica','DMA','212');
  69. INSERT INTO countries VALUES ('DO','DOMINICAN REPUBLIC','Dominican Republic','DOM','214');
  70. INSERT INTO countries VALUES ('EC','ECUADOR','Ecuador','ECU','218');
  71. INSERT INTO countries VALUES ('EG','EGYPT','Egypt','EGY','818');
  72. INSERT INTO countries VALUES ('SV','EL SALVADOR','El Salvador','SLV','222');
  73. INSERT INTO countries VALUES ('GQ','EQUATORIAL GUINEA','Equatorial Guinea','GNQ','226');
  74. INSERT INTO countries VALUES ('ER','ERITREA','Eritrea','ERI','232');
  75. INSERT INTO countries VALUES ('EE','ESTONIA','Estonia','EST','233');
  76. INSERT INTO countries VALUES ('ET','ETHIOPIA','Ethiopia','ETH','231');
  77. INSERT INTO countries VALUES ('FK','FALKLAND ISLANDS (MALVINAS)','Falkland Islands (Malvinas)','FLK','238');
  78. INSERT INTO countries VALUES ('FO','FAROE ISLANDS','Faroe Islands','FRO','234');
  79. INSERT INTO countries VALUES ('FJ','FIJI','Fiji','FJI','242');
  80. INSERT INTO countries VALUES ('FI','FINLAND','Finland','FIN','246');
  81. INSERT INTO countries VALUES ('FR','FRANCE','France','FRA','250');
  82. INSERT INTO countries VALUES ('GF','FRENCH GUIANA','French Guiana','GUF','254');
  83. INSERT INTO countries VALUES ('PF','FRENCH POLYNESIA','French Polynesia','PYF','258');
  84. INSERT INTO countries VALUES ('TF','FRENCH SOUTHERN TERRITORIES','French Southern Territories',NULL,NULL);
  85. INSERT INTO countries VALUES ('GA','GABON','Gabon','GAB','266');
  86. INSERT INTO countries VALUES ('GM','GAMBIA','Gambia','GMB','270');
  87. INSERT INTO countries VALUES ('GE','GEORGIA','Georgia','GEO','268');
  88. INSERT INTO countries VALUES ('DE','GERMANY','Germany','DEU','276');
  89. INSERT INTO countries VALUES ('GH','GHANA','Ghana','GHA','288');
  90. INSERT INTO countries VALUES ('GI','GIBRALTAR','Gibraltar','GIB','292');
  91. INSERT INTO countries VALUES ('GR','GREECE','Greece','GRC','300');
  92. INSERT INTO countries VALUES ('GL','GREENLAND','Greenland','GRL','304');
  93. INSERT INTO countries VALUES ('GD','GRENADA','Grenada','GRD','308');
  94. INSERT INTO countries VALUES ('GP','GUADELOUPE','Guadeloupe','GLP','312');
  95. INSERT INTO countries VALUES ('GU','GUAM','Guam','GUM','316');
  96. INSERT INTO countries VALUES ('GT','GUATEMALA','Guatemala','GTM','320');
  97. INSERT INTO countries VALUES ('GN','GUINEA','Guinea','GIN','324');
  98. INSERT INTO countries VALUES ('GW','GUINEA-BISSAU','Guinea-Bissau','GNB','624');
  99. INSERT INTO countries VALUES ('GY','GUYANA','Guyana','GUY','328');
  100. INSERT INTO countries VALUES ('HT','HAITI','Haiti','HTI','332');
  101. INSERT INTO countries VALUES ('HM','HEARD ISLAND AND MCDONALD ISLANDS','Heard Island and Mcdonald Islands',NULL,NULL);
  102. INSERT INTO countries VALUES ('VA','HOLY SEE (VATICAN CITY STATE)','Holy See (Vatican City State)','VAT','336');
  103. INSERT INTO countries VALUES ('HN','HONDURAS','Honduras','HND','340');
  104. INSERT INTO countries VALUES ('HK','HONG KONG','Hong Kong','HKG','344');
  105. INSERT INTO countries VALUES ('HU','HUNGARY','Hungary','HUN','348');
  106. INSERT INTO countries VALUES ('IS','ICELAND','Iceland','ISL','352');
  107. INSERT INTO countries VALUES ('IN','INDIA','India','IND','356');
  108. INSERT INTO countries VALUES ('ID','INDONESIA','Indonesia','IDN','360');
  109. INSERT INTO countries VALUES ('IR','IRAN, ISLAMIC REPUBLIC OF','Iran, Islamic Republic of','IRN','364');
  110. INSERT INTO countries VALUES ('IQ','IRAQ','Iraq','IRQ','368');
  111. INSERT INTO countries VALUES ('IE','IRELAND','Ireland','IRL','372');
  112. INSERT INTO countries VALUES ('IL','ISRAEL','Israel','ISR','376');
  113. INSERT INTO countries VALUES ('IT','ITALY','Italy','ITA','380');
  114. INSERT INTO countries VALUES ('JM','JAMAICA','Jamaica','JAM','388');
  115. INSERT INTO countries VALUES ('JP','JAPAN','Japan','JPN','392');
  116. INSERT INTO countries VALUES ('JO','JORDAN','Jordan','JOR','400');
  117. INSERT INTO countries VALUES ('KZ','KAZAKHSTAN','Kazakhstan','KAZ','398');
  118. INSERT INTO countries VALUES ('KE','KENYA','Kenya','KEN','404');
  119. INSERT INTO countries VALUES ('KI','KIRIBATI','Kiribati','KIR','296');
  120. INSERT INTO countries VALUES ('KP','KOREA, DEMOCRATIC PEOPLE\'S REPUBLIC OF','Korea, Democratic People\'s Republic of','PRK','408');
  121. INSERT INTO countries VALUES ('KR','KOREA, REPUBLIC OF','Korea, Republic of','KOR','410');
  122. INSERT INTO countries VALUES ('KW','KUWAIT','Kuwait','KWT','414');
  123. INSERT INTO countries VALUES ('KG','KYRGYZSTAN','Kyrgyzstan','KGZ','417');
  124. INSERT INTO countries VALUES ('LA','LAO PEOPLE\'S DEMOCRATIC REPUBLIC','Lao People\'s Democratic Republic','LAO','418');
  125. INSERT INTO countries VALUES ('LV','LATVIA','Latvia','LVA','428');
  126. INSERT INTO countries VALUES ('LB','LEBANON','Lebanon','LBN','422');
  127. INSERT INTO countries VALUES ('LS','LESOTHO','Lesotho','LSO','426');
  128. INSERT INTO countries VALUES ('LR','LIBERIA','Liberia','LBR','430');
  129. INSERT INTO countries VALUES ('LY','LIBYAN ARAB JAMAHIRIYA','Libyan Arab Jamahiriya','LBY','434');
  130. INSERT INTO countries VALUES ('LI','LIECHTENSTEIN','Liechtenstein','LIE','438');
  131. INSERT INTO countries VALUES ('LT','LITHUANIA','Lithuania','LTU','440');
  132. INSERT INTO countries VALUES ('LU','LUXEMBOURG','Luxembourg','LUX','442');
  133. INSERT INTO countries VALUES ('MO','MACAO','Macao','MAC','446');
  134. INSERT INTO countries VALUES ('MK','MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF','Macedonia, the Former Yugoslav Republic of','MKD','807');
  135. INSERT INTO countries VALUES ('MG','MADAGASCAR','Madagascar','MDG','450');
  136. INSERT INTO countries VALUES ('MW','MALAWI','Malawi','MWI','454');
  137. INSERT INTO countries VALUES ('MY','MALAYSIA','Malaysia','MYS','458');
  138. INSERT INTO countries VALUES ('MV','MALDIVES','Maldives','MDV','462');
  139. INSERT INTO countries VALUES ('ML','MALI','Mali','MLI','466');
  140. INSERT INTO countries VALUES ('MT','MALTA','Malta','MLT','470');
  141. INSERT INTO countries VALUES ('MH','MARSHALL ISLANDS','Marshall Islands','MHL','584');
  142. INSERT INTO countries VALUES ('MQ','MARTINIQUE','Martinique','MTQ','474');
  143. INSERT INTO countries VALUES ('MR','MAURITANIA','Mauritania','MRT','478');
  144. INSERT INTO countries VALUES ('MU','MAURITIUS','Mauritius','MUS','480');
  145. INSERT INTO countries VALUES ('YT','MAYOTTE','Mayotte',NULL,NULL);
  146. INSERT INTO countries VALUES ('MX','MEXICO','Mexico','MEX','484');
  147. INSERT INTO countries VALUES ('FM','MICRONESIA, FEDERATED STATES OF','Micronesia, Federated States of','FSM','583');
  148. INSERT INTO countries VALUES ('MD','MOLDOVA, REPUBLIC OF','Moldova, Republic of','MDA','498');
  149. INSERT INTO countries VALUES ('MC','MONACO','Monaco','MCO','492');
  150. INSERT INTO countries VALUES ('MN','MONGOLIA','Mongolia','MNG','496');
  151. INSERT INTO countries VALUES ('MS','MONTSERRAT','Montserrat','MSR','500');
  152. INSERT INTO countries VALUES ('MA','MOROCCO','Morocco','MAR','504');
  153. INSERT INTO countries VALUES ('MZ','MOZAMBIQUE','Mozambique','MOZ','508');
  154. INSERT INTO countries VALUES ('MM','MYANMAR','Myanmar','MMR','104');
  155. INSERT INTO countries VALUES ('NA','NAMIBIA','Namibia','NAM','516');
  156. INSERT INTO countries VALUES ('NR','NAURU','Nauru','NRU','520');
  157. INSERT INTO countries VALUES ('NP','NEPAL','Nepal','NPL','524');
  158. INSERT INTO countries VALUES ('NL','NETHERLANDS','Netherlands','NLD','528');
  159. INSERT INTO countries VALUES ('AN','NETHERLANDS ANTILLES','Netherlands Antilles','ANT','530');
  160. INSERT INTO countries VALUES ('NC','NEW CALEDONIA','New Caledonia','NCL','540');
  161. INSERT INTO countries VALUES ('NZ','NEW ZEALAND','New Zealand','NZL','554');
  162. INSERT INTO countries VALUES ('NI','NICARAGUA','Nicaragua','NIC','558');
  163. INSERT INTO countries VALUES ('NE','NIGER','Niger','NER','562');
  164. INSERT INTO countries VALUES ('NG','NIGERIA','Nigeria','NGA','566');
  165. INSERT INTO countries VALUES ('NU','NIUE','Niue','NIU','570');
  166. INSERT INTO countries VALUES ('NF','NORFOLK ISLAND','Norfolk Island','NFK','574');
  167. INSERT INTO countries VALUES ('MP','NORTHERN MARIANA ISLANDS','Northern Mariana Islands','MNP','580');
  168. INSERT INTO countries VALUES ('NO','NORWAY','Norway','NOR','578');
  169. INSERT INTO countries VALUES ('OM','OMAN','Oman','OMN','512');
  170. INSERT INTO countries VALUES ('PK','PAKISTAN','Pakistan','PAK','586');
  171. INSERT INTO countries VALUES ('PW','PALAU','Palau','PLW','585');
  172. INSERT INTO countries VALUES ('PS','PALESTINIAN TERRITORY, OCCUPIED','Palestinian Territory, Occupied',NULL,NULL);
  173. INSERT INTO countries VALUES ('PA','PANAMA','Panama','PAN','591');
  174. INSERT INTO countries VALUES ('PG','PAPUA NEW GUINEA','Papua New Guinea','PNG','598');
  175. INSERT INTO countries VALUES ('PY','PARAGUAY','Paraguay','PRY','600');
  176. INSERT INTO countries VALUES ('PE','PERU','Peru','PER','604');
  177. INSERT INTO countries VALUES ('PH','PHILIPPINES','Philippines','PHL','608');
  178. INSERT INTO countries VALUES ('PN','PITCAIRN','Pitcairn','PCN','612');
  179. INSERT INTO countries VALUES ('PL','POLAND','Poland','POL','616');
  180. INSERT INTO countries VALUES ('PT','PORTUGAL','Portugal','PRT','620');
  181. INSERT INTO countries VALUES ('PR','PUERTO RICO','Puerto Rico','PRI','630');
  182. INSERT INTO countries VALUES ('QA','QATAR','Qatar','QAT','634');
  183. INSERT INTO countries VALUES ('RE','REUNION','Reunion','REU','638');
  184. INSERT INTO countries VALUES ('RO','ROMANIA','Romania','ROM','642');
  185. INSERT INTO countries VALUES ('RU','RUSSIAN FEDERATION','Russian Federation','RUS','643');
  186. INSERT INTO countries VALUES ('RW','RWANDA','Rwanda','RWA','646');
  187. INSERT INTO countries VALUES ('SH','SAINT HELENA','Saint Helena','SHN','654');
  188. INSERT INTO countries VALUES ('KN','SAINT KITTS AND NEVIS','Saint Kitts and Nevis','KNA','659');
  189. INSERT INTO countries VALUES ('LC','SAINT LUCIA','Saint Lucia','LCA','662');
  190. INSERT INTO countries VALUES ('PM','SAINT PIERRE AND MIQUELON','Saint Pierre and Miquelon','SPM','666');
  191. INSERT INTO countries VALUES ('VC','SAINT VINCENT AND THE GRENADINES','Saint Vincent and the Grenadines','VCT','670');
  192. INSERT INTO countries VALUES ('WS','SAMOA','Samoa','WSM','882');
  193. INSERT INTO countries VALUES ('SM','SAN MARINO','San Marino','SMR','674');
  194. INSERT INTO countries VALUES ('ST','SAO TOME AND PRINCIPE','Sao Tome and Principe','STP','678');
  195. INSERT INTO countries VALUES ('SA','SAUDI ARABIA','Saudi Arabia','SAU','682');
  196. INSERT INTO countries VALUES ('SN','SENEGAL','Senegal','SEN','686');
  197. INSERT INTO countries VALUES ('CS','SERBIA AND MONTENEGRO','Serbia and Montenegro',NULL,NULL);
  198. INSERT INTO countries VALUES ('SC','SEYCHELLES','Seychelles','SYC','690');
  199. INSERT INTO countries VALUES ('SL','SIERRA LEONE','Sierra Leone','SLE','694');
  200. INSERT INTO countries VALUES ('SG','SINGAPORE','Singapore','SGP','702');
  201. INSERT INTO countries VALUES ('SK','SLOVAKIA','Slovakia','SVK','703');
  202. INSERT INTO countries VALUES ('SI','SLOVENIA','Slovenia','SVN','705');
  203. INSERT INTO countries VALUES ('SB','SOLOMON ISLANDS','Solomon Islands','SLB','090');
  204. INSERT INTO countries VALUES ('SO','SOMALIA','Somalia','SOM','706');
  205. INSERT INTO countries VALUES ('ZA','SOUTH AFRICA','South Africa','ZAF','710');
  206. INSERT INTO countries VALUES ('GS','SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS','South Georgia and the South Sandwich Islands',NULL,NULL);
  207. INSERT INTO countries VALUES ('ES','SPAIN','Spain','ESP','724');
  208. INSERT INTO countries VALUES ('LK','SRI LANKA','Sri Lanka','LKA','144');
  209. INSERT INTO countries VALUES ('SD','SUDAN','Sudan','SDN','736');
  210. INSERT INTO countries VALUES ('SR','SURINAME','Suriname','SUR','740');
  211. INSERT INTO countries VALUES ('SJ','SVALBARD AND JAN MAYEN','Svalbard and Jan Mayen','SJM','744');
  212. INSERT INTO countries VALUES ('SZ','SWAZILAND','Swaziland','SWZ','748');
  213. INSERT INTO countries VALUES ('SE','SWEDEN','Sweden','SWE','752');
  214. INSERT INTO countries VALUES ('CH','SWITZERLAND','Switzerland','CHE','756');
  215. INSERT INTO countries VALUES ('SY','SYRIAN ARAB REPUBLIC','Syrian Arab Republic','SYR','760');
  216. INSERT INTO countries VALUES ('TW','TAIWAN, PROVINCE OF CHINA','Taiwan, Province of China','TWN','158');
  217. INSERT INTO countries VALUES ('TJ','TAJIKISTAN','Tajikistan','TJK','762');
  218. INSERT INTO countries VALUES ('TZ','TANZANIA, UNITED REPUBLIC OF','Tanzania, United Republic of','TZA','834');
  219. INSERT INTO countries VALUES ('TH','THAILAND','Thailand','THA','764');
  220. INSERT INTO countries VALUES ('TL','TIMOR-LESTE','Timor-Leste',NULL,NULL);
  221. INSERT INTO countries VALUES ('TG','TOGO','Togo','TGO','768');
  222. INSERT INTO countries VALUES ('TK','TOKELAU','Tokelau','TKL','772');
  223. INSERT INTO countries VALUES ('TO','TONGA','Tonga','TON','776');
  224. INSERT INTO countries VALUES ('TT','TRINIDAD AND TOBAGO','Trinidad and Tobago','TTO','780');
  225. INSERT INTO countries VALUES ('TN','TUNISIA','Tunisia','TUN','788');
  226. INSERT INTO countries VALUES ('TR','TURKEY','Turkey','TUR','792');
  227. INSERT INTO countries VALUES ('TM','TURKMENISTAN','Turkmenistan','TKM','795');
  228. INSERT INTO countries VALUES ('TC','TURKS AND CAICOS ISLANDS','Turks and Caicos Islands','TCA','796');
  229. INSERT INTO countries VALUES ('TV','TUVALU','Tuvalu','TUV','798');
  230. INSERT INTO countries VALUES ('UG','UGANDA','Uganda','UGA','800');
  231. INSERT INTO countries VALUES ('UA','UKRAINE','Ukraine','UKR','804');
  232. INSERT INTO countries VALUES ('AE','UNITED ARAB EMIRATES','United Arab Emirates','ARE','784');
  233. INSERT INTO countries VALUES ('GB','UNITED KINGDOM','United Kingdom','GBR','826');
  234. INSERT INTO countries VALUES ('US','UNITED STATES','United States','USA','840');
  235. INSERT INTO countries VALUES ('UM','UNITED STATES MINOR OUTLYING ISLANDS','United States Minor Outlying Islands',NULL,NULL);
  236. INSERT INTO countries VALUES ('UY','URUGUAY','Uruguay','URY','858');
  237. INSERT INTO countries VALUES ('UZ','UZBEKISTAN','Uzbekistan','UZB','860');
  238. INSERT INTO countries VALUES ('VU','VANUATU','Vanuatu','VUT','548');
  239. INSERT INTO countries VALUES ('VE','VENEZUELA','Venezuela','VEN','862');
  240. INSERT INTO countries VALUES ('VN','VIET NAM','Viet Nam','VNM','704');
  241. INSERT INTO countries VALUES ('VG','VIRGIN ISLANDS, BRITISH','Virgin Islands, British','VGB','092');
  242. INSERT INTO countries VALUES ('VI','VIRGIN ISLANDS, U.S.','Virgin Islands, U.s.','VIR','850');
  243. INSERT INTO countries VALUES ('WF','WALLIS AND FUTUNA','Wallis and Futuna','WLF','876');
  244. INSERT INTO countries VALUES ('EH','WESTERN SAHARA','Western Sahara','ESH','732');
  245. INSERT INTO countries VALUES ('YE','YEMEN','Yemen','YEM','887');
  246. INSERT INTO countries VALUES ('ZM','ZAMBIA','Zambia','ZMB','894');
  247. INSERT INTO countries VALUES ('ZW','ZIMBABWE','Zimbabwe','ZWE','716');

Report this snippet  

Comments

RSS Icon Subscribe to comments
Posted By: minghua on August 4, 2010

Serbia and Montenegro are now two countries.

You need to login to post a comment.