Guest User

country currency sql

a guest
Dec 13th, 2019
1,959
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 25.29 KB | None | 0 0
  1. CREATE TABLE currency(
  2. id INTEGER NOT NULL PRIMARY KEY
  3. ,country VARCHAR(36) NOT NULL
  4. ,currency VARCHAR(39) NOT NULL
  5. ,code VARCHAR(3) NOT NULL
  6. );
  7. INSERT INTO currency(id,country,currency,code) VALUES (1,'Afghanistan','Afghan afghani','AFN');
  8. INSERT INTO currency(id,country,currency,code) VALUES (2,'Akrotiri and Dhekelia (UK)','European euro','EUR');
  9. INSERT INTO currency(id,country,currency,code) VALUES (3,'Aland Islands (Finland)','European euro','EUR');
  10. INSERT INTO currency(id,country,currency,code) VALUES (4,'Albania','Albanian lek','ALL');
  11. INSERT INTO currency(id,country,currency,code) VALUES (5,'Algeria','Algerian dinar','DZD');
  12. INSERT INTO currency(id,country,currency,code) VALUES (6,'American Samoa (USA)','United States dollar','USD');
  13. INSERT INTO currency(id,country,currency,code) VALUES (7,'Andorra','European euro','EUR');
  14. INSERT INTO currency(id,country,currency,code) VALUES (8,'Angola','Angolan kwanza','AOA');
  15. INSERT INTO currency(id,country,currency,code) VALUES (9,'Anguilla (UK)','East Caribbean dollar','XCD');
  16. INSERT INTO currency(id,country,currency,code) VALUES (10,'Antigua and Barbuda','East Caribbean dollar','XCD');
  17. INSERT INTO currency(id,country,currency,code) VALUES (11,'Argentina','Argentine peso','ARS');
  18. INSERT INTO currency(id,country,currency,code) VALUES (12,'Armenia','Armenian dram','AMD');
  19. INSERT INTO currency(id,country,currency,code) VALUES (13,'Aruba (Netherlands)','Aruban florin','AWG');
  20. INSERT INTO currency(id,country,currency,code) VALUES (14,'Ascension Island (UK)','Saint Helena pound','SHP');
  21. INSERT INTO currency(id,country,currency,code) VALUES (15,'Australia','Australian dollar','AUD');
  22. INSERT INTO currency(id,country,currency,code) VALUES (16,'Austria','European euro','EUR');
  23. INSERT INTO currency(id,country,currency,code) VALUES (17,'Azerbaijan','Azerbaijan manat','AZN');
  24. INSERT INTO currency(id,country,currency,code) VALUES (18,'Bahamas','Bahamian dollar','BSD');
  25. INSERT INTO currency(id,country,currency,code) VALUES (19,'Bahrain','Bahraini dinar','BHD');
  26. INSERT INTO currency(id,country,currency,code) VALUES (20,'Bangladesh','Bangladeshi taka','BDT');
  27. INSERT INTO currency(id,country,currency,code) VALUES (21,'Barbados','Barbadian dollar','BBD');
  28. INSERT INTO currency(id,country,currency,code) VALUES (22,'Belarus','Belarusian ruble','BYN');
  29. INSERT INTO currency(id,country,currency,code) VALUES (23,'Belgium','European euro','EUR');
  30. INSERT INTO currency(id,country,currency,code) VALUES (24,'Belize','Belize dollar','BZD');
  31. INSERT INTO currency(id,country,currency,code) VALUES (25,'Benin','West African CFA franc','XOF');
  32. INSERT INTO currency(id,country,currency,code) VALUES (26,'Bermuda (UK)','Bermudian dollar','BMD');
  33. INSERT INTO currency(id,country,currency,code) VALUES (27,'Bhutan','Bhutanese ngultrum','BTN');
  34. INSERT INTO currency(id,country,currency,code) VALUES (28,'Bolivia','Bolivian boliviano','BOB');
  35. INSERT INTO currency(id,country,currency,code) VALUES (29,'Bonaire (Netherlands)','United States dollar','USD');
  36. INSERT INTO currency(id,country,currency,code) VALUES (30,'Bosnia and Herzegovina','Bosnia and Herzegovina convertible mark','BAM');
  37. INSERT INTO currency(id,country,currency,code) VALUES (31,'Botswana','Botswana pula','BWP');
  38. INSERT INTO currency(id,country,currency,code) VALUES (32,'Brazil','Brazilian real','BRL');
  39. INSERT INTO currency(id,country,currency,code) VALUES (33,'British Indian Ocean Territory (UK)','United States dollar','USD');
  40. INSERT INTO currency(id,country,currency,code) VALUES (34,'British Virgin Islands (UK)','United States dollar','USD');
  41. INSERT INTO currency(id,country,currency,code) VALUES (35,'Brunei','Brunei dollar','BND');
  42. INSERT INTO currency(id,country,currency,code) VALUES (36,'Bulgaria','Bulgarian lev','BGN');
  43. INSERT INTO currency(id,country,currency,code) VALUES (37,'Burkina Faso','West African CFA franc','XOF');
  44. INSERT INTO currency(id,country,currency,code) VALUES (38,'Burundi','Burundi franc','BIF');
  45. INSERT INTO currency(id,country,currency,code) VALUES (39,'Cabo Verde','Cape Verdean escudo','CVE');
  46. INSERT INTO currency(id,country,currency,code) VALUES (40,'Cambodia','Cambodian riel','KHR');
  47. INSERT INTO currency(id,country,currency,code) VALUES (41,'Cameroon','Central African CFA franc','XAF');
  48. INSERT INTO currency(id,country,currency,code) VALUES (42,'Canada','Canadian dollar','CAD');
  49. INSERT INTO currency(id,country,currency,code) VALUES (43,'Caribbean Netherlands (Netherlands)','United States dollar','USD');
  50. INSERT INTO currency(id,country,currency,code) VALUES (44,'Cayman Islands (UK)','Cayman Islands dollar','KYD');
  51. INSERT INTO currency(id,country,currency,code) VALUES (45,'Central African Republic','Central African CFA franc','XAF');
  52. INSERT INTO currency(id,country,currency,code) VALUES (46,'Chad','Central African CFA franc','XAF');
  53. INSERT INTO currency(id,country,currency,code) VALUES (47,'Chatham Islands (New Zealand)','New Zealand dollar','NZD');
  54. INSERT INTO currency(id,country,currency,code) VALUES (48,'Chile','Chilean peso','CLP');
  55. INSERT INTO currency(id,country,currency,code) VALUES (49,'China','Chinese Yuan Renminbi','CNY');
  56. INSERT INTO currency(id,country,currency,code) VALUES (50,'Christmas Island (Australia)','Australian dollar','AUD');
  57. INSERT INTO currency(id,country,currency,code) VALUES (51,'Cocos (Keeling) Islands (Australia)','Australian dollar','AUD');
  58. INSERT INTO currency(id,country,currency,code) VALUES (52,'Colombia','Colombian peso','COP');
  59. INSERT INTO currency(id,country,currency,code) VALUES (53,'Comoros','Comorian franc','KMF');
  60. INSERT INTO currency(id,country,currency,code) VALUES (54,'Congo, Democratic Republic of the','Congolese franc','CDF');
  61. INSERT INTO currency(id,country,currency,code) VALUES (55,'Congo, Republic of the','Central African CFA franc','XAF');
  62. INSERT INTO currency(id,country,currency,code) VALUES (56,'Cook Islands (New Zealand)','Cook Islands dollar','---');
  63. INSERT INTO currency(id,country,currency,code) VALUES (57,'Costa Rica','Costa Rican colon','CRC');
  64. INSERT INTO currency(id,country,currency,code) VALUES (58,'Cote d''Ivoire','West African CFA franc','XOF');
  65. INSERT INTO currency(id,country,currency,code) VALUES (59,'Croatia','Croatian kuna','HRK');
  66. INSERT INTO currency(id,country,currency,code) VALUES (60,'Cuba','Cuban peso','CUP');
  67. INSERT INTO currency(id,country,currency,code) VALUES (61,'Curacao (Netherlands)','Netherlands Antillean guilder','ANG');
  68. INSERT INTO currency(id,country,currency,code) VALUES (62,'Cyprus','European euro','EUR');
  69. INSERT INTO currency(id,country,currency,code) VALUES (63,'Czechia','Czech koruna','CZK');
  70. INSERT INTO currency(id,country,currency,code) VALUES (64,'Denmark','Danish krone','DKK');
  71. INSERT INTO currency(id,country,currency,code) VALUES (65,'Djibouti','Djiboutian franc','DJF');
  72. INSERT INTO currency(id,country,currency,code) VALUES (66,'Dominica','East Caribbean dollar','XCD');
  73. INSERT INTO currency(id,country,currency,code) VALUES (67,'Dominican Republic','Dominican peso','DOP');
  74. INSERT INTO currency(id,country,currency,code) VALUES (68,'Ecuador','United States dollar','USD');
  75. INSERT INTO currency(id,country,currency,code) VALUES (69,'Egypt','Egyptian pound','EGP');
  76. INSERT INTO currency(id,country,currency,code) VALUES (70,'El Salvador','United States dollar','USD');
  77. INSERT INTO currency(id,country,currency,code) VALUES (71,'Equatorial Guinea','Central African CFA franc','XAF');
  78. INSERT INTO currency(id,country,currency,code) VALUES (72,'Eritrea','Eritrean nakfa','ERN');
  79. INSERT INTO currency(id,country,currency,code) VALUES (73,'Estonia','European euro','EUR');
  80. INSERT INTO currency(id,country,currency,code) VALUES (74,'Eswatini (formerly Swaziland)','Swazi lilangeni','SZL');
  81. INSERT INTO currency(id,country,currency,code) VALUES (75,'Ethiopia','Ethiopian birr','ETB');
  82. INSERT INTO currency(id,country,currency,code) VALUES (76,'Falkland Islands (UK)','Falkland Islands pound','FKP');
  83. INSERT INTO currency(id,country,currency,code) VALUES (77,'Faroe Islands (Denmark)','Faroese krona','---');
  84. INSERT INTO currency(id,country,currency,code) VALUES (78,'Fiji','Fijian dollar','FJD');
  85. INSERT INTO currency(id,country,currency,code) VALUES (79,'Finland','European euro','EUR');
  86. INSERT INTO currency(id,country,currency,code) VALUES (80,'France','European euro','EUR');
  87. INSERT INTO currency(id,country,currency,code) VALUES (81,'French Guiana (France)','European euro','EUR');
  88. INSERT INTO currency(id,country,currency,code) VALUES (82,'French Polynesia (France)','CFP franc','XPF');
  89. INSERT INTO currency(id,country,currency,code) VALUES (83,'Gabon','Central African CFA franc','XAF');
  90. INSERT INTO currency(id,country,currency,code) VALUES (84,'Gambia','Gambian dalasi','GMD');
  91. INSERT INTO currency(id,country,currency,code) VALUES (85,'Georgia','Georgian lari','GEL');
  92. INSERT INTO currency(id,country,currency,code) VALUES (86,'Germany','European euro','EUR');
  93. INSERT INTO currency(id,country,currency,code) VALUES (87,'Ghana','Ghanaian cedi','GHS');
  94. INSERT INTO currency(id,country,currency,code) VALUES (88,'Gibraltar (UK)','Gibraltar pound','GIP');
  95. INSERT INTO currency(id,country,currency,code) VALUES (89,'Greece','European euro','EUR');
  96. INSERT INTO currency(id,country,currency,code) VALUES (90,'Greenland (Denmark)','Danish krone','DKK');
  97. INSERT INTO currency(id,country,currency,code) VALUES (91,'Grenada','East Caribbean dollar','XCD');
  98. INSERT INTO currency(id,country,currency,code) VALUES (92,'Guadeloupe (France)','European euro','EUR');
  99. INSERT INTO currency(id,country,currency,code) VALUES (93,'Guam (USA)','United States dollar','USD');
  100. INSERT INTO currency(id,country,currency,code) VALUES (94,'Guatemala','Guatemalan quetzal','GTQ');
  101. INSERT INTO currency(id,country,currency,code) VALUES (95,'Guernsey (UK)','Guernsey Pound','GGP');
  102. INSERT INTO currency(id,country,currency,code) VALUES (96,'Guinea','Guinean franc','GNF');
  103. INSERT INTO currency(id,country,currency,code) VALUES (97,'Guinea-Bissau','West African CFA franc','XOF');
  104. INSERT INTO currency(id,country,currency,code) VALUES (98,'Guyana','Guyanese dollar','GYD');
  105. INSERT INTO currency(id,country,currency,code) VALUES (99,'Haiti','Haitian gourde','HTG');
  106. INSERT INTO currency(id,country,currency,code) VALUES (100,'Honduras','Honduran lempira','HNL');
  107. INSERT INTO currency(id,country,currency,code) VALUES (101,'Hong Kong (China)','Hong Kong dollar','HKD');
  108. INSERT INTO currency(id,country,currency,code) VALUES (102,'Hungary','Hungarian forint','HUF');
  109. INSERT INTO currency(id,country,currency,code) VALUES (103,'Iceland','Icelandic krona','ISK');
  110. INSERT INTO currency(id,country,currency,code) VALUES (104,'India','Indian rupee','INR');
  111. INSERT INTO currency(id,country,currency,code) VALUES (105,'Indonesia','Indonesian rupiah','IDR');
  112. INSERT INTO currency(id,country,currency,code) VALUES (106,'International Monetary Fund (IMF)','SDR (Special Drawing Right)','XDR');
  113. INSERT INTO currency(id,country,currency,code) VALUES (107,'Iran','Iranian rial','IRR');
  114. INSERT INTO currency(id,country,currency,code) VALUES (108,'Iraq','Iraqi dinar','IQD');
  115. INSERT INTO currency(id,country,currency,code) VALUES (109,'Ireland','European euro','EUR');
  116. INSERT INTO currency(id,country,currency,code) VALUES (110,'Isle of Man (UK)','Manx pound','IMP');
  117. INSERT INTO currency(id,country,currency,code) VALUES (111,'Israel','Israeli new shekel','ILS');
  118. INSERT INTO currency(id,country,currency,code) VALUES (112,'Italy','European euro','EUR');
  119. INSERT INTO currency(id,country,currency,code) VALUES (113,'Jamaica','Jamaican dollar','JMD');
  120. INSERT INTO currency(id,country,currency,code) VALUES (114,'Japan','Japanese yen','JPY');
  121. INSERT INTO currency(id,country,currency,code) VALUES (115,'Jersey (UK)','Jersey pound','JEP');
  122. INSERT INTO currency(id,country,currency,code) VALUES (116,'Jordan','Jordanian dinar','JOD');
  123. INSERT INTO currency(id,country,currency,code) VALUES (117,'Kazakhstan','Kazakhstani tenge','KZT');
  124. INSERT INTO currency(id,country,currency,code) VALUES (118,'Kenya','Kenyan shilling','KES');
  125. INSERT INTO currency(id,country,currency,code) VALUES (119,'Kiribati','Australian dollar','AUD');
  126. INSERT INTO currency(id,country,currency,code) VALUES (120,'Kosovo','European euro','EUR');
  127. INSERT INTO currency(id,country,currency,code) VALUES (121,'Kuwait','Kuwaiti dinar','KWD');
  128. INSERT INTO currency(id,country,currency,code) VALUES (122,'Kyrgyzstan','Kyrgyzstani som','KGS');
  129. INSERT INTO currency(id,country,currency,code) VALUES (123,'Laos','Lao kip','LAK');
  130. INSERT INTO currency(id,country,currency,code) VALUES (124,'Latvia','European euro','EUR');
  131. INSERT INTO currency(id,country,currency,code) VALUES (125,'Lebanon','Lebanese pound','LBP');
  132. INSERT INTO currency(id,country,currency,code) VALUES (126,'Lesotho','Lesotho loti','LSL');
  133. INSERT INTO currency(id,country,currency,code) VALUES (127,'Liberia','Liberian dollar','LRD');
  134. INSERT INTO currency(id,country,currency,code) VALUES (128,'Libya','Libyan dinar','LYD');
  135. INSERT INTO currency(id,country,currency,code) VALUES (129,'Liechtenstein','Swiss franc','CHF');
  136. INSERT INTO currency(id,country,currency,code) VALUES (130,'Lithuania','European euro','EUR');
  137. INSERT INTO currency(id,country,currency,code) VALUES (131,'Luxembourg','European euro','EUR');
  138. INSERT INTO currency(id,country,currency,code) VALUES (132,'Macau (China)','Macanese pataca','MOP');
  139. INSERT INTO currency(id,country,currency,code) VALUES (133,'Madagascar','Malagasy ariary','MGA');
  140. INSERT INTO currency(id,country,currency,code) VALUES (134,'Malawi','Malawian kwacha','MWK');
  141. INSERT INTO currency(id,country,currency,code) VALUES (135,'Malaysia','Malaysian ringgit','MYR');
  142. INSERT INTO currency(id,country,currency,code) VALUES (136,'Maldives','Maldivian rufiyaa','MVR');
  143. INSERT INTO currency(id,country,currency,code) VALUES (137,'Mali','West African CFA franc','XOF');
  144. INSERT INTO currency(id,country,currency,code) VALUES (138,'Malta','European euro','EUR');
  145. INSERT INTO currency(id,country,currency,code) VALUES (139,'Marshall Islands','United States dollar','USD');
  146. INSERT INTO currency(id,country,currency,code) VALUES (140,'Martinique (France)','European euro','EUR');
  147. INSERT INTO currency(id,country,currency,code) VALUES (141,'Mauritania','Mauritanian ouguiya','MRU');
  148. INSERT INTO currency(id,country,currency,code) VALUES (142,'Mauritius','Mauritian rupee','MUR');
  149. INSERT INTO currency(id,country,currency,code) VALUES (143,'Mayotte (France)','European euro','EUR');
  150. INSERT INTO currency(id,country,currency,code) VALUES (144,'Mexico','Mexican peso','MXN');
  151. INSERT INTO currency(id,country,currency,code) VALUES (145,'Micronesia','United States dollar','USD');
  152. INSERT INTO currency(id,country,currency,code) VALUES (146,'Moldova','Moldovan leu','MDL');
  153. INSERT INTO currency(id,country,currency,code) VALUES (147,'Monaco','European euro','EUR');
  154. INSERT INTO currency(id,country,currency,code) VALUES (148,'Mongolia','Mongolian tugrik','MNT');
  155. INSERT INTO currency(id,country,currency,code) VALUES (149,'Montenegro','European euro','EUR');
  156. INSERT INTO currency(id,country,currency,code) VALUES (150,'Montserrat (UK)','East Caribbean dollar','XCD');
  157. INSERT INTO currency(id,country,currency,code) VALUES (151,'Morocco','Moroccan dirham','MAD');
  158. INSERT INTO currency(id,country,currency,code) VALUES (152,'Mozambique','Mozambican metical','MZN');
  159. INSERT INTO currency(id,country,currency,code) VALUES (153,'Myanmar (formerly Burma)','Myanmar kyat','MMK');
  160. INSERT INTO currency(id,country,currency,code) VALUES (154,'Namibia','Namibian dollar','NAD');
  161. INSERT INTO currency(id,country,currency,code) VALUES (155,'Nauru','Australian dollar','AUD');
  162. INSERT INTO currency(id,country,currency,code) VALUES (156,'Nepal','Nepalese rupee','NPR');
  163. INSERT INTO currency(id,country,currency,code) VALUES (157,'Netherlands','European euro','EUR');
  164. INSERT INTO currency(id,country,currency,code) VALUES (158,'New Caledonia (France)','CFP franc','XPF');
  165. INSERT INTO currency(id,country,currency,code) VALUES (159,'New Zealand','New Zealand dollar','NZD');
  166. INSERT INTO currency(id,country,currency,code) VALUES (160,'Nicaragua','Nicaraguan cordoba','NIO');
  167. INSERT INTO currency(id,country,currency,code) VALUES (161,'Niger','West African CFA franc','XOF');
  168. INSERT INTO currency(id,country,currency,code) VALUES (162,'Nigeria','Nigerian naira','NGN');
  169. INSERT INTO currency(id,country,currency,code) VALUES (163,'Niue (New Zealand)','New Zealand dollar','NZD');
  170. INSERT INTO currency(id,country,currency,code) VALUES (164,'Norfolk Island (Australia)','Australian dollar','AUD');
  171. INSERT INTO currency(id,country,currency,code) VALUES (165,'Northern Mariana Islands (USA)','United States dollar','USD');
  172. INSERT INTO currency(id,country,currency,code) VALUES (166,'North Korea','North Korean won','KPW');
  173. INSERT INTO currency(id,country,currency,code) VALUES (167,'North Macedonia (formerly Macedonia)','Macedonian denar','MKD');
  174. INSERT INTO currency(id,country,currency,code) VALUES (168,'Norway','Norwegian krone','NOK');
  175. INSERT INTO currency(id,country,currency,code) VALUES (169,'Oman','Omani rial','OMR');
  176. INSERT INTO currency(id,country,currency,code) VALUES (170,'Pakistan','Pakistani rupee','PKR');
  177. INSERT INTO currency(id,country,currency,code) VALUES (171,'Palau','United States dollar','USD');
  178. INSERT INTO currency(id,country,currency,code) VALUES (172,'Palestine','Israeli new shekel','ILS');
  179. INSERT INTO currency(id,country,currency,code) VALUES (173,'Panama','United States dollar','USD');
  180. INSERT INTO currency(id,country,currency,code) VALUES (174,'Papua New Guinea','Papua New Guinean kina','PGK');
  181. INSERT INTO currency(id,country,currency,code) VALUES (175,'Paraguay','Paraguayan guarani','PYG');
  182. INSERT INTO currency(id,country,currency,code) VALUES (176,'Peru','Peruvian sol','PEN');
  183. INSERT INTO currency(id,country,currency,code) VALUES (177,'Philippines','Philippine peso','PHP');
  184. INSERT INTO currency(id,country,currency,code) VALUES (178,'Pitcairn Islands (UK)','New Zealand dollar','NZD');
  185. INSERT INTO currency(id,country,currency,code) VALUES (179,'Poland','Polish zloty','PLN');
  186. INSERT INTO currency(id,country,currency,code) VALUES (180,'Portugal','European euro','EUR');
  187. INSERT INTO currency(id,country,currency,code) VALUES (181,'Puerto Rico (USA)','United States dollar','USD');
  188. INSERT INTO currency(id,country,currency,code) VALUES (182,'Qatar','Qatari riyal','QAR');
  189. INSERT INTO currency(id,country,currency,code) VALUES (183,'Reunion (France)','European euro','EUR');
  190. INSERT INTO currency(id,country,currency,code) VALUES (184,'Romania','Romanian leu','RON');
  191. INSERT INTO currency(id,country,currency,code) VALUES (185,'Russia','Russian ruble','RUB');
  192. INSERT INTO currency(id,country,currency,code) VALUES (186,'Rwanda','Rwandan franc','RWF');
  193. INSERT INTO currency(id,country,currency,code) VALUES (187,'Saba (Netherlands)','United States dollar','USD');
  194. INSERT INTO currency(id,country,currency,code) VALUES (188,'Saint Barthelemy (France)','European euro','EUR');
  195. INSERT INTO currency(id,country,currency,code) VALUES (189,'Saint Helena (UK)','Saint Helena pound','SHP');
  196. INSERT INTO currency(id,country,currency,code) VALUES (190,'Saint Kitts and Nevis','East Caribbean dollar','XCD');
  197. INSERT INTO currency(id,country,currency,code) VALUES (191,'Saint Lucia','East Caribbean dollar','XCD');
  198. INSERT INTO currency(id,country,currency,code) VALUES (192,'Saint Martin (France)','European euro','EUR');
  199. INSERT INTO currency(id,country,currency,code) VALUES (193,'Saint Pierre and Miquelon (France)','European euro','EUR');
  200. INSERT INTO currency(id,country,currency,code) VALUES (194,'Saint Vincent and the Grenadines','East Caribbean dollar','XCD');
  201. INSERT INTO currency(id,country,currency,code) VALUES (195,'Samoa','Samoan tala','WST');
  202. INSERT INTO currency(id,country,currency,code) VALUES (196,'San Marino','European euro','EUR');
  203. INSERT INTO currency(id,country,currency,code) VALUES (197,'Sao Tome and Principe','Sao Tome and Principe dobra','STN');
  204. INSERT INTO currency(id,country,currency,code) VALUES (198,'Saudi Arabia','Saudi Arabian riyal','SAR');
  205. INSERT INTO currency(id,country,currency,code) VALUES (199,'Senegal','West African CFA franc','XOF');
  206. INSERT INTO currency(id,country,currency,code) VALUES (200,'Serbia','Serbian dinar','RSD');
  207. INSERT INTO currency(id,country,currency,code) VALUES (201,'Seychelles','Seychellois rupee','SCR');
  208. INSERT INTO currency(id,country,currency,code) VALUES (202,'Sierra Leone','Sierra Leonean leone','SLL');
  209. INSERT INTO currency(id,country,currency,code) VALUES (203,'Singapore','Singapore dollar','SGD');
  210. INSERT INTO currency(id,country,currency,code) VALUES (204,'Sint Eustatius (Netherlands)','United States dollar','USD');
  211. INSERT INTO currency(id,country,currency,code) VALUES (205,'Sint Maarten (Netherlands)','Netherlands Antillean guilder','ANG');
  212. INSERT INTO currency(id,country,currency,code) VALUES (206,'Slovakia','European euro','EUR');
  213. INSERT INTO currency(id,country,currency,code) VALUES (207,'Slovenia','European euro','EUR');
  214. INSERT INTO currency(id,country,currency,code) VALUES (208,'Solomon Islands','Solomon Islands dollar','SBD');
  215. INSERT INTO currency(id,country,currency,code) VALUES (209,'Somalia','Somali shilling','SOS');
  216. INSERT INTO currency(id,country,currency,code) VALUES (210,'South Africa','South African rand','ZAR');
  217. INSERT INTO currency(id,country,currency,code) VALUES (211,'South Georgia Island (UK)','Pound sterling','GBP');
  218. INSERT INTO currency(id,country,currency,code) VALUES (212,'South Korea','South Korean won','KRW');
  219. INSERT INTO currency(id,country,currency,code) VALUES (213,'South Sudan','South Sudanese pound','SSP');
  220. INSERT INTO currency(id,country,currency,code) VALUES (214,'Spain','European euro','EUR');
  221. INSERT INTO currency(id,country,currency,code) VALUES (215,'Sri Lanka','Sri Lankan rupee','LKR');
  222. INSERT INTO currency(id,country,currency,code) VALUES (216,'Sudan','Sudanese pound','SDG');
  223. INSERT INTO currency(id,country,currency,code) VALUES (217,'Suriname','Surinamese dollar','SRD');
  224. INSERT INTO currency(id,country,currency,code) VALUES (218,'Svalbard and Jan Mayen (Norway)','Norwegian krone','NOK');
  225. INSERT INTO currency(id,country,currency,code) VALUES (219,'Sweden','Swedish krona','SEK');
  226. INSERT INTO currency(id,country,currency,code) VALUES (220,'Switzerland','Swiss franc','CHF');
  227. INSERT INTO currency(id,country,currency,code) VALUES (221,'Syria','Syrian pound','SYP');
  228. INSERT INTO currency(id,country,currency,code) VALUES (222,'Taiwan','New Taiwan dollar','TWD');
  229. INSERT INTO currency(id,country,currency,code) VALUES (223,'Tajikistan','Tajikistani somoni','TJS');
  230. INSERT INTO currency(id,country,currency,code) VALUES (224,'Tanzania','Tanzanian shilling','TZS');
  231. INSERT INTO currency(id,country,currency,code) VALUES (225,'Thailand','Thai baht','THB');
  232. INSERT INTO currency(id,country,currency,code) VALUES (226,'Timor-Leste','United States dollar','USD');
  233. INSERT INTO currency(id,country,currency,code) VALUES (227,'Togo','West African CFA franc','XOF');
  234. INSERT INTO currency(id,country,currency,code) VALUES (228,'Tokelau (New Zealand)','New Zealand dollar','NZD');
  235. INSERT INTO currency(id,country,currency,code) VALUES (229,'Tonga','Tongan pa’anga','TOP');
  236. INSERT INTO currency(id,country,currency,code) VALUES (230,'Trinidad and Tobago','Trinidad and Tobago dollar','TTD');
  237. INSERT INTO currency(id,country,currency,code) VALUES (231,'Tristan da Cunha (UK)','Pound sterling','GBP');
  238. INSERT INTO currency(id,country,currency,code) VALUES (232,'Tunisia','Tunisian dinar','TND');
  239. INSERT INTO currency(id,country,currency,code) VALUES (233,'Turkey','Turkish lira','TRY');
  240. INSERT INTO currency(id,country,currency,code) VALUES (234,'Turkmenistan','Turkmen manat','TMT');
  241. INSERT INTO currency(id,country,currency,code) VALUES (235,'Turks and Caicos Islands (UK)','United States dollar','USD');
  242. INSERT INTO currency(id,country,currency,code) VALUES (236,'Tuvalu','Australian dollar','AUD');
  243. INSERT INTO currency(id,country,currency,code) VALUES (237,'Uganda','Ugandan shilling','UGX');
  244. INSERT INTO currency(id,country,currency,code) VALUES (238,'Ukraine','Ukrainian hryvnia','UAH');
  245. INSERT INTO currency(id,country,currency,code) VALUES (239,'United Arab Emirates','UAE dirham','AED');
  246. INSERT INTO currency(id,country,currency,code) VALUES (240,'United Kingdom','Pound sterling','GBP');
  247. INSERT INTO currency(id,country,currency,code) VALUES (241,'United States of America','United States dollar','USD');
  248. INSERT INTO currency(id,country,currency,code) VALUES (242,'Uruguay','Uruguayan peso','UYU');
  249. INSERT INTO currency(id,country,currency,code) VALUES (243,'US Virgin Islands (USA)','United States dollar','USD');
  250. INSERT INTO currency(id,country,currency,code) VALUES (244,'Uzbekistan','Uzbekistani som','UZS');
  251. INSERT INTO currency(id,country,currency,code) VALUES (245,'Vanuatu','Vanuatu vatu','VUV');
  252. INSERT INTO currency(id,country,currency,code) VALUES (246,'Vatican City (Holy See)','European euro','EUR');
  253. INSERT INTO currency(id,country,currency,code) VALUES (247,'Venezuela','Venezuelan bolivar','VES');
  254. INSERT INTO currency(id,country,currency,code) VALUES (248,'Vietnam','Vietnamese dong','VND');
  255. INSERT INTO currency(id,country,currency,code) VALUES (249,'Wake Island (USA)','United States dollar','USD');
  256. INSERT INTO currency(id,country,currency,code) VALUES (250,'Wallis and Futuna (France)','CFP franc','XPF');
  257. INSERT INTO currency(id,country,currency,code) VALUES (251,'Yemen','Yemeni rial','YER');
  258. INSERT INTO currency(id,country,currency,code) VALUES (252,'Zambia','Zambian kwacha','ZMW');
  259. INSERT INTO currency(id,country,currency,code) VALUES (253,'Zimbabwe','United States dollar','USD');
Add Comment
Please, Sign In to add comment