Posted By

bcmoney on 05/30/11


Tagged

code country world currency currencies ISO-4217


Versions (?)

currency.sql


 / Published in: SQL
 

URL: http://bcmoney-mobiletv.com/blog/2008/12/30/currency-codes-dropdown-and-sql-table/

  1. CREATE TABLE IF NOT EXISTS `currency` (
  2. `currency_id` int(11) NOT NULL AUTO_INCREMENT,
  3. `currency_name` varchar(64) DEFAULT NULL,
  4. `currency_code` char(3) DEFAULT NULL,
  5. PRIMARY KEY (`currency_id`),
  6. KEY `idx_currency_name` (`currency_name`)
  7. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;
  8.  
  9. --
  10. -- Dumping data for table `currency`
  11. --
  12. INSERT INTO `currency` (`currency_id`, `currency_name`, `currency_code`) VALUES
  13. (1, 'Andorran Peseta', 'ADP'),
  14. (2, 'United Arab Emirates Dirham', 'AED'),
  15. (3, 'Afghanistan Afghani', 'AFA'),
  16. (4, 'Albanian Lek', 'ALL'),
  17. (5, 'Netherlands Antillian Guilder', 'ANG'),
  18. (6, 'Angolan Kwanza', 'AOK'),
  19. (7, 'Argentine Peso', 'ARS'),
  20. (9, 'Australian Dollar', 'AUD'),
  21. (10, 'Aruban Florin', 'AWG'),
  22. (11, 'Barbados Dollar', 'BBD'),
  23. (12, 'Bangladeshi Taka', 'BDT'),
  24. (14, 'Bulgarian Lev', 'BGN'),
  25. (15, 'Bahraini Dinar', 'BHD'),
  26. (16, 'Burundi Franc', 'BIF'),
  27. (17, 'Bermudian Dollar', 'BMD'),
  28. (18, 'Brunei Dollar', 'BND'),
  29. (19, 'Bolivian Boliviano', 'BOB'),
  30. (20, 'Brazilian Real', 'BRL'),
  31. (21, 'Bahamian Dollar', 'BSD'),
  32. (22, 'Bhutan Ngultrum', 'BTN'),
  33. (23, 'Burma Kyat', 'BUK'),
  34. (24, 'Botswanian Pula', 'BWP'),
  35. (25, 'Belize Dollar', 'BZD'),
  36. (26, 'Canadian Dollar', 'CAD'),
  37. (27, 'Swiss Franc', 'CHF'),
  38. (28, 'Chilean Unidades de Fomento', 'CLF'),
  39. (29, 'Chilean Peso', 'CLP'),
  40. (30, 'Yuan (Chinese) Renminbi', 'CNY'),
  41. (31, 'Colombian Peso', 'COP'),
  42. (32, 'Costa Rican Colon', 'CRC'),
  43. (33, 'Czech Republic Koruna', 'CZK'),
  44. (34, 'Cuban Peso', 'CUP'),
  45. (35, 'Cape Verde Escudo', 'CVE'),
  46. (36, 'Cyprus Pound', 'CYP'),
  47. (40, 'Danish Krone', 'DKK'),
  48. (41, 'Dominican Peso', 'DOP'),
  49. (42, 'Algerian Dinar', 'DZD'),
  50. (43, 'Ecuador Sucre', 'ECS'),
  51. (44, 'Egyptian Pound', 'EGP'),
  52. (45, 'Estonian Kroon (EEK)', 'EEK'),
  53. (46, 'Ethiopian Birr', 'ETB'),
  54. (47, 'Euro', 'EUR'),
  55. (49, 'Fiji Dollar', 'FJD'),
  56. (50, 'Falkland Islands Pound', 'FKP'),
  57. (52, 'British Pound', 'GBP'),
  58. (53, 'Ghanaian Cedi', 'GHC'),
  59. (54, 'Gibraltar Pound', 'GIP'),
  60. (55, 'Gambian Dalasi', 'GMD'),
  61. (56, 'Guinea Franc', 'GNF'),
  62. (58, 'Guatemalan Quetzal', 'GTQ'),
  63. (59, 'Guinea-Bissau Peso', 'GWP'),
  64. (60, 'Guyanan Dollar', 'GYD'),
  65. (61, 'Hong Kong Dollar', 'HKD'),
  66. (62, 'Honduran Lempira', 'HNL'),
  67. (63, 'Haitian Gourde', 'HTG'),
  68. (64, 'Hungarian Forint', 'HUF'),
  69. (65, 'Indonesian Rupiah', 'IDR'),
  70. (66, 'Irish Punt', 'IEP'),
  71. (67, 'Israeli Shekel', 'ILS'),
  72. (68, 'Indian Rupee', 'INR'),
  73. (69, 'Iraqi Dinar', 'IQD'),
  74. (70, 'Iranian Rial', 'IRR'),
  75. (73, 'Jamaican Dollar', 'JMD'),
  76. (74, 'Jordanian Dinar', 'JOD'),
  77. (75, 'Japanese Yen', 'JPY'),
  78. (76, 'Kenyan Schilling', 'KES'),
  79. (77, 'Kampuchean (Cambodian) Riel', 'KHR'),
  80. (78, 'Comoros Franc', 'KMF'),
  81. (79, 'North Korean Won', 'KPW'),
  82. (80, '(South) Korean Won', 'KRW'),
  83. (81, 'Kuwaiti Dinar', 'KWD'),
  84. (82, 'Cayman Islands Dollar', 'KYD'),
  85. (83, 'Lao Kip', 'LAK'),
  86. (84, 'Lebanese Pound', 'LBP'),
  87. (85, 'Sri Lanka Rupee', 'LKR'),
  88. (86, 'Liberian Dollar', 'LRD'),
  89. (87, 'Lesotho Loti', 'LSL'),
  90. (89, 'Libyan Dinar', 'LYD'),
  91. (90, 'Moroccan Dirham', 'MAD'),
  92. (91, 'Malagasy Franc', 'MGF'),
  93. (92, 'Mongolian Tugrik', 'MNT'),
  94. (93, 'Macau Pataca', 'MOP'),
  95. (94, 'Mauritanian Ouguiya', 'MRO'),
  96. (95, 'Maltese Lira', 'MTL'),
  97. (96, 'Mauritius Rupee', 'MUR'),
  98. (97, 'Maldive Rufiyaa', 'MVR'),
  99. (98, 'Malawi Kwacha', 'MWK'),
  100. (99, 'Mexican Peso', 'MXP'),
  101. (100, 'Malaysian Ringgit', 'MYR'),
  102. (101, 'Mozambique Metical', 'MZM'),
  103. (102, 'Namibian Dollar', 'NAD'),
  104. (103, 'Nigerian Naira', 'NGN'),
  105. (104, 'Nicaraguan Cordoba', 'NIO'),
  106. (105, 'Norwegian Kroner', 'NOK'),
  107. (106, 'Nepalese Rupee', 'NPR'),
  108. (107, 'New Zealand Dollar', 'NZD'),
  109. (108, 'Omani Rial', 'OMR'),
  110. (109, 'Panamanian Balboa', 'PAB'),
  111. (110, 'Peruvian Nuevo Sol', 'PEN'),
  112. (111, 'Papua New Guinea Kina', 'PGK'),
  113. (112, 'Philippine Peso', 'PHP'),
  114. (113, 'Pakistan Rupee', 'PKR'),
  115. (114, 'Polish Zloty', 'PLN'),
  116. (116, 'Paraguay Guarani', 'PYG'),
  117. (117, 'Qatari Rial', 'QAR'),
  118. (118, 'Romanian Leu', 'RON'),
  119. (119, 'Rwanda Franc', 'RWF'),
  120. (120, 'Saudi Arabian Riyal', 'SAR'),
  121. (121, 'Solomon Islands Dollar', 'SBD'),
  122. (122, 'Seychelles Rupee', 'SCR'),
  123. (123, 'Sudanese Pound', 'SDP'),
  124. (124, 'Swedish Krona', 'SEK'),
  125. (125, 'Singapore Dollar', 'SGD'),
  126. (126, 'St. Helena Pound', 'SHP'),
  127. (127, 'Sierra Leone Leone', 'SLL'),
  128. (128, 'Somali Schilling', 'SOS'),
  129. (129, 'Suriname Guilder', 'SRG'),
  130. (130, 'Sao Tome and Principe Dobra', 'STD'),
  131. (131, 'Russian Ruble', 'RUB'),
  132. (132, 'El Salvador Colon', 'SVC'),
  133. (133, 'Syrian Potmd', 'SYP'),
  134. (134, 'Swaziland Lilangeni', 'SZL'),
  135. (135, 'Thai Baht', 'THB'),
  136. (136, 'Tunisian Dinar', 'TND'),
  137. (137, 'Tongan Paanga', 'TOP'),
  138. (138, 'East Timor Escudo', 'TPE'),
  139. (139, 'Turkish Lira', 'TRY'),
  140. (140, 'Trinidad and Tobago Dollar', 'TTD'),
  141. (141, 'Taiwan Dollar', 'TWD'),
  142. (142, 'Tanzanian Schilling', 'TZS'),
  143. (143, 'Uganda Shilling', 'UGX'),
  144. (144, 'US Dollar', 'USD'),
  145. (145, 'Uruguayan Peso', 'UYU'),
  146. (146, 'Venezualan Bolivar', 'VEF'),
  147. (147, 'Vietnamese Dong', 'VND'),
  148. (148, 'Vanuatu Vatu', 'VUV'),
  149. (149, 'Samoan Tala', 'WST'),
  150. (150, 'Communauté Financière Africaine BEAC, Francs', 'XAF'),
  151. (151, 'Silver, Ounces', 'XAG'),
  152. (152, 'Gold, Ounces', 'XAU'),
  153. (153, 'East Caribbean Dollar', 'XCD'),
  154. (154, 'International Monetary Fund (IMF) Special Drawing Rights', 'XDR'),
  155. (155, 'Communauté Financière Africaine BCEAO - Francs', 'XOF'),
  156. (156, 'Palladium Ounces', 'XPD'),
  157. (157, 'Comptoirs Français du Pacifique Francs', 'XPF'),
  158. (158, 'Platinum, Ounces', 'XPT'),
  159. (159, 'Democratic Yemeni Dinar', 'YDD'),
  160. (160, 'Yemeni Rial', 'YER'),
  161. (161, 'New Yugoslavia Dinar', 'YUD'),
  162. (162, 'South African Rand', 'ZAR'),
  163. (163, 'Zambian Kwacha', 'ZMK'),
  164. (164, 'Zaire Zaire', 'ZRZ'),
  165. (165, 'Zimbabwe Dollar', 'ZWD'),
  166. (166, 'Slovak Koruna', 'SKK'),
  167. (167, 'Armenian Dram', 'AMD');

Report this snippet  

Comments

RSS Icon Subscribe to comments
Posted By: Some0ne on May 31, 2011

Error on this line:

(158, 'Platinum, Ounces', 'XPT');

should be:

(158, 'Platinum, Ounces', 'XPT'),

Posted By: bcmoney on July 27, 2011

good eye, thx! should have waited until I imported the file to post!

You need to login to post a comment.