Skip to content

Instantly share code, notes, and snippets.

@electroidru

electroidru/currency_codes_mysql.sql

Last active May 1, 2023 09:40
Show Gist options
  • Save electroidru/f8e55802c34067f3950daee4a80b9f28 to your computer and use it in GitHub Desktop.
Save electroidru/f8e55802c34067f3950daee4a80b9f28 to your computer and use it in GitHub Desktop.
Download ZIP
List of Currencies, countries and their codes per Currency Codes-ISO 4217 in mysql format
Raw
currency_codes_mysql.sql
CREATE TABLE `currency_codes` (
`id` int NOT NULL AUTO_INCREMENT,
`country` varchar(255) NOT NULL DEFAULT '',
`currency` varchar(255) NOT NULL DEFAULT '',
`alphabetic_code` varchar(3) NOT NULL DEFAULT '',
`numeric_code` DECIMAL(3,0) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- INSERT Currency Codes ISO 4217
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('AFGHANISTAN', 'Afghani', 'AFN', 971);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('ÅLAND ISLANDS', 'Euro', 'EUR', 978);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('ALBANIA', 'Lek', 'ALL', 008);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('ALGERIA', 'Algerian Dinar', 'EUR', 012);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('AMERICAN SAMOA', 'US Dollar', 'USD', 840);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('ANDORRA', 'Euro', 'EUR', 978);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('ANGOLA', 'Kwanza', 'AOA', 973);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('ANGUILLA', 'East Caribbean Dollar', 'XCD', 951);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('ANTARCTICA', 'No universal currency', '', 0);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('ANTIGUA AND BARBUDA', 'East Caribbean Dollar', 'XCD', 951);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('ARGENTINA', 'Argentine Peso', 'ARS', 032);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('ARMENIA', 'Armenian Dram', 'AMD', 051);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('ARUBA', 'Aruban Florin', 'AWG', 533);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('AUSTRALIA', 'Australian Dollar', 'AUD', 036);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('AUSTRIA', 'Euro', 'EUR', 978);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('AZERBAIJAN', 'Azerbaijan Manat', 'AZN', 944);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('BAHAMAS (THE)', 'Bahamian Dollar', 'BSD', 044);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('BAHRAIN', 'Bahraini Dinar', 'BHD', 048);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('BANGLADESH', 'Taka', 'BDT', 050);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('BARBADOS', 'Barbados Dollar', 'BBD', 052);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('BELARUS', 'Belarusian Ruble', 'BYN', 933);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('BELGIUM', 'Euro', 'EUR', 978);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('BELIZE', 'Belize Dollar', 'BZD', 084);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('BENIN', 'CFA Franc BCEAO', 'XOF', 952);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('BERMUDA', 'Bermudian Dollar', 'BMD', 060);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('BHUTAN', 'Indian Rupee', 'INR', 356);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('BHUTAN', 'Ngultrum', 'BTN', 064);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('BOLIVIA (PLURINATIONAL STATE OF)', 'Boliviano', 'BOB', 068);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('BOLIVIA (PLURINATIONAL STATE OF)', 'Mvdol', 'BOV', 984);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('BONAIRE, SINT EUSTATIUS AND SABA', 'US Dollar', 'USD', 840);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('BOSNIA AND HERZEGOVINA', 'Convertible Mark', 'BAM', 977);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('BOTSWANA', 'Pula', 'BWP', 072);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('BOUVET ISLAND', 'Norwegian Krone', 'NOK', 578);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('BRAZIL', 'Brazilian Real', 'BRL', 986);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('BRITISH INDIAN OCEAN TERRITORY (THE)', 'US Dollar', 'USD', 840);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('BRUNEI DARUSSALAM', 'Brunei Dollar', 'BND', 096);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('BULGARIA', 'Bulgarian Lev', 'BGN', 975);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('BURKINA FASO', 'CFA Franc BCEAO', 'XOF', 952);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('BURUNDI', 'Burundi Franc', 'BIF', 108);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('CABO VERDE', 'Cabo Verde Escudo', 'CVE', 132);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('CAMBODIA', 'Riel', 'KHR', 116);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('CAMEROON', 'CFA Franc BEAC', 'XAF', 950);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('CANADA', 'Canadian Dollar', 'CAD', 124);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('CAYMAN ISLANDS (THE)', 'Cayman Islands Dollar', 'KYD', 136);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('CENTRAL AFRICAN REPUBLIC (THE)', 'CFA Franc BEAC', 'XAF', 950);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('CHAD', 'CFA Franc BEAC', 'XAF', 950);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('CHILE', 'Chilean Peso', 'CLP', 152);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('CHILE', 'Unidad de Fomento', 'CLF', 990);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('CHINA', 'Yuan Renminbi', 'CNY', 156);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('CHRISTMAS ISLAND', 'Australian Dollar', 'AUD', 036);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('COCOS (KEELING) ISLANDS (THE)', 'Australian Dollar', 'AUD', 036);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('COLOMBIA', 'Colombian Peso', 'COP', 170);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('COLOMBIA', 'Unidad de Valor Real', 'COU', 970);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('COMOROS (THE)', 'Comorian Franc', 'KMF', 174);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('CONGO (THE DEMOCRATIC REPUBLIC OF THE)', 'Congolese Franc', 'CDF', 976);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('CONGO (THE)', 'CFA Franc BEAC', 'XAF', 950);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('COOK ISLANDS (THE)', 'New Zealand Dollar', 'NZD', 554);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('COSTA RICA', 'Costa Rican Colon', 'CRC', 188);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('CÔTE D\'IVOIRE', 'CFA Franc BCEAO', 'XOF', 952);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('CROATIA', 'Kuna', 'HRK', 191);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('CUBA', 'Cuban Peso', 'CUP', 192);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('CUBA', 'Peso Convertible', 'CUC', 931);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('CURAÇAO', 'Netherlands Antillean Guilder', 'ANG', 532);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('CYPRUS', 'Euro', 'EUR', 978);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('CZECHIA', 'Czech Koruna', 'CZK', 203);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('DENMARK', 'Danish Krone', 'DKK', 208);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('DJIBOUTI', 'Djibouti Franc', 'DJF', 262);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('DOMINICA', 'East Caribbean Dollar', 'XCD', 951);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('DOMINICAN REPUBLIC (THE)', 'Dominican Peso', 'DOP', 214);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('ECUADOR', 'US Dollar', 'USD', 840);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('EGYPT', 'Egyptian Pound', 'EGP', 818);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('EL SALVADOR', 'El Salvador Colon', 'SVC', 222);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('EL SALVADOR', 'US Dollar', 'USD', 840);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('EQUATORIAL GUINEA', 'CFA Franc BEAC', 'XAF', 950);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('ERITREA', 'Nakfa', 'ERN', 232);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('ESTONIA', 'Euro', 'EUR', 978);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('ESWATINI', 'Lilangeni', 'SZL', 748);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('ETHIOPIA', 'Ethiopian Birr', 'ETB', 230);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('EUROPEAN UNION', 'Euro', 'EUR', 978);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('FALKLAND ISLANDS (THE) [MALVINAS]', 'Falkland Islands Pound', 'FKP', 238);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('FAROE ISLANDS (THE)', 'Danish Krone', 'DKK', 208);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('FIJI', 'Fiji Dollar', 'FJD', 242);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('FINLAND', 'Euro', 'EUR', 978);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('FRANCE', 'Euro', 'EUR', 978);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('FRENCH GUIANA', 'Euro', 'EUR', 978);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('FRENCH POLYNESIA', 'CFP Franc', 'XPF', 953);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('FRENCH SOUTHERN TERRITORIES (THE)', 'Euro', 'EUR', 978);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('GABON', 'CFA Franc BEAC', 'XAF', 950);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('GAMBIA (THE)', 'Dalasi', 'GMD', 270);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('GEORGIA', 'Lari', 'GEL', 981);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('GERMANY', 'Euro', 'EUR', 978);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('GHANA', 'Ghana Cedi', 'GHS', 936);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('GIBRALTAR', 'Gibraltar Pound', 'GIP', 292);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('GREECE', 'Euro', 'EUR', 978);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('GREENLAND', 'Danish Krone', 'DKK', 208);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('GRENADA', 'East Caribbean Dollar', 'XCD', 951);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('GUADELOUPE', 'Euro', 'EUR', 978);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('GUAM', 'US Dollar', 'USD', 840);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('GUATEMALA', 'Quetzal', 'GTQ', 320);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('GUERNSEY', 'Pound Sterling', 'GBP', 826);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('GUINEA', 'Guinean Franc', 'GNF', 324);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('GUINEA-BISSAU', 'CFA Franc BCEAO', 'XOF', 952);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('GUYANA', 'Guyana Dollar', 'GYD', 328);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('HAITI', 'Gourde', 'HTG', 332);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('HAITI', 'US Dollar', 'USD', 840);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('HEARD ISLAND AND McDONALD ISLANDS', 'Australian Dollar', 'AUD', 036);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('HOLY SEE (THE)', 'Euro', 'EUR', 978);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('HONDURAS', 'Lempira', 'HNL', 340);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('HONG KONG', 'Hong Kong Dollar', 'HKD', 344);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('HUNGARY', 'Forint', 'HUF', 348);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('ICELAND', 'Iceland Krona', 'ISK', 352);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('INDIA', 'Indian Rupee', 'INR', 356);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('INDONESIA', 'Rupiah', 'IDR', 360);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('INTERNATIONAL MONETARY FUND (IMF)', 'SDR (Special Drawing Right)', 'XDR', 960);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('IRAN (ISLAMIC REPUBLIC OF)', 'Iranian Rial', 'IRR', 364);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('IRAQ', 'Iraqi Dinar', 'IQD', 368);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('IRELAND', 'Euro', 'EUR', 978);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('ISLE OF MAN', 'Pound Sterling', 'GBP', 826);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('ISRAEL', 'New Israeli Sheqel', 'ILS', 376);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('ITALY', 'Euro', 'EUR', 978);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('JAMAICA', 'Jamaican Dollar', 'JMD', 388);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('JAPAN', 'Yen', 'JPY', 392);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('JERSEY', 'Pound Sterling', 'GBP', 826);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('JORDAN', 'Jordanian Dinar', 'JOD', 400);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('KAZAKHSTAN', 'Tenge', 'KZT', 398);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('KENYA', 'Kenyan Shilling', 'KES', 404);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('KIRIBATI', 'Australian Dollar', 'AUD', 036);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('KOREA (THE DEMOCRATIC PEOPLE’S REPUBLIC OF)', 'North Korean Won', 'KPW', 408);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('KOREA (THE REPUBLIC OF)', 'Won', 'KRW', 410);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('KUWAIT', 'Kuwaiti Dinar', 'KWD', 414);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('KYRGYZSTAN', 'Som', 'KGS', 417);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('LAO PEOPLE’S DEMOCRATIC REPUBLIC (THE)', 'Lao Kip', 'LAK', 418);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('LATVIA', 'Euro', 'EUR', 978);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('LEBANON', 'Lebanese Pound', 'LBP', 422);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('LESOTHO', 'Loti', 'LSL', 426);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('LESOTHO', 'Rand', 'ZAR', 710);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('LIBERIA', 'Liberian Dollar', 'LRD', 430);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('LIBYA', 'Libyan Dinar', 'LYD', 434);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('LIECHTENSTEIN', 'Swiss Franc', 'CHF', 756);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('LITHUANIA', 'Euro', 'EUR', 978);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('LUXEMBOURG', 'Euro', 'EUR', 978);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('MACAO', 'Pataca', 'MOP', 446);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('MADAGASCAR', 'Malagasy Ariary', 'MGA', 969);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('MALAWI', 'Malawi Kwacha', 'MWK', 454);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('MALAYSIA', 'Malaysian Ringgit', 'MYR', 458);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('MALDIVES', 'Rufiyaa', 'MVR', 462);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('MALI', 'CFA Franc BCEAO', 'XOF', 952);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('MALTA', 'Euro', 'EUR', 978);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('MARSHALL ISLANDS (THE)', 'US Dollar', 'USD', 840);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('MARTINIQUE', 'Euro', 'EUR', 978);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('MAURITANIA', 'Ouguiya', 'MRU', 929);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('MAURITIUS', 'Mauritius Rupee', 'MUR', 480);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('MAYOTTE', 'Euro', 'EUR', 978);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('MEMBER COUNTRIES OF THE AFRICAN DEVELOPMENT BANK GROUP', 'ADB Unit of Account', 'XUA', 965);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('MEXICO', 'Mexican Peso', 'MXN', 484);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('MEXICO', 'Mexican Unidad de Inversion (UDI)', 'MXV', 979);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('MICRONESIA (FEDERATED STATES OF)', 'US Dollar', 'USD', 840);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('MOLDOVA (THE REPUBLIC OF)', 'Moldovan Leu', 'MDL', 498);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('MONACO', 'Euro', 'EUR', 978);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('MONGOLIA', 'Tugrik', 'MNT', 496);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('MONTENEGRO', 'Euro', 'EUR', 978);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('MONTSERRAT', 'East Caribbean Dollar', 'XCD', 951);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('MOROCCO', 'Moroccan Dirham', 'MAD', 504);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('MOZAMBIQUE', 'Mozambique Metical', 'MZN', 943);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('MYANMAR', 'Kyat', 'MMK', 104);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('NAMIBIA', 'Namibia Dollar', 'NAD', 516);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('NAMIBIA', 'Rand', 'ZAR', 710);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('NAURU', 'Australian Dollar', 'AUD', 036);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('NEPAL', 'Nepalese Rupee', 'NPR', 524);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('NETHERLANDS (THE)', 'Euro', 'EUR', 978);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('NEW CALEDONIA', 'CFP Franc', 'XPF', 953);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('NEW ZEALAND', 'New Zealand Dollar', 'NZD', 554);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('NICARAGUA', 'Cordoba Oro', 'NIO', 558);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('NIGER (THE)', 'CFA Franc BCEAO', 'XOF', 952);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('NIGERIA', 'Naira', 'NGN', 566);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('NIUE', 'New Zealand Dollar', 'NZD', 554);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('NORFOLK ISLAND', 'Australian Dollar', 'AUD', 036);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('NORTH MACEDONIA', 'Denar', 'MKD', 807);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('NORTHERN MARIANA ISLANDS (THE)', 'US Dollar', 'USD', 840);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('NORWAY', 'Norwegian Krone', 'NOK', 578);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('OMAN', 'Rial Omani', 'OMR', 512);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('PAKISTAN', 'Pakistan Rupee', 'PKR', 586);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('PALAU', 'US Dollar', 'USD', 840);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('PALESTINE, STATE OF', 'No universal currency', '', 0);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('PANAMA', 'Balboa', 'PAB', 590);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('PANAMA', 'US Dollar', 'USD', 840);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('PAPUA NEW GUINEA', 'Kina', 'PGK', 598);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('PARAGUAY', 'Guarani', 'PYG', 600);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('PERU', 'Sol', 'PEN', 604);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('PHILIPPINES (THE)', 'Philippine Peso', 'PHP', 608);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('PITCAIRN', 'New Zealand Dollar', 'NZD', 554);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('POLAND', 'Zloty', 'PLN', 985);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('PORTUGAL', 'Euro', 'EUR', 978);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('PUERTO RICO', 'US Dollar', 'USD', 840);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('QATAR', 'Qatari Rial', 'QAR', 634);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('RÉUNION', 'Euro', 'EUR', 978);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('ROMANIA', 'Romanian Leu', 'RON', 946);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('RUSSIAN FEDERATION (THE)', 'Russian Ruble', 'RUB', 643);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('RWANDA', 'Rwanda Franc', 'RWF', 646);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('SAINT BARTHÉLEMY', 'Euro', 'EUR', 978);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('SAINT HELENA, ASCENSION AND TRISTAN DA CUNHA', 'Saint Helena Pound', 'SHP', 654);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('SAINT KITTS AND NEVIS', 'East Caribbean Dollar', 'XCD', 951);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('SAINT LUCIA', 'East Caribbean Dollar', 'XCD', 951);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('SAINT MARTIN (FRENCH PART)', 'Euro', 'EUR', 978);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('SAINT PIERRE AND MIQUELON', 'Euro', 'EUR', 978);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('SAINT VINCENT AND THE GRENADINES', 'East Caribbean Dollar', 'XCD', 951);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('SAMOA', 'Tala', 'WST', 882);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('SAN MARINO', 'Euro', 'EUR', 978);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('SAO TOME AND PRINCIPE', 'Dobra', 'STN', 930);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('SAUDI ARABIA', 'Saudi Riyal', 'SAR', 682);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('SENEGAL', 'CFA Franc BCEAO', 'XOF', 952);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('SERBIA', 'Serbian Dinar', 'RSD', 941);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('SEYCHELLES', 'Seychelles Rupee', 'SCR', 690);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('SIERRA LEONE', 'Leone', 'SLL', 694);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('SINGAPORE', 'Singapore Dollar', 'SGD', 702);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('SINT MAARTEN (DUTCH PART)', 'Netherlands Antillean Guilder', 'ANG', 532);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('SISTEMA UNITARIO DE COMPENSACION REGIONAL DE PAGOS "SUCRE"', 'Sucre', 'XSU', 994);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('SLOVAKIA', 'Euro', 'EUR', 978);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('SLOVENIA', 'Euro', 'EUR', 978);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('SOLOMON ISLANDS', 'Solomon Islands Dollar', 'SBD', 090);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('SOMALIA', 'Somali Shilling', 'SOS', 706);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('SOUTH AFRICA', 'Rand', 'ZAR', 710);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS', 'No universal currency', '', 0);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('SOUTH SUDAN', 'South Sudanese Pound', 'SSP', 728);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('SPAIN', 'Euro', 'EUR', 978);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('SRI LANKA', 'Sri Lanka Rupee', 'LKR', 144);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('SUDAN (THE)', 'Sudanese Pound', 'SDG', 938);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('SURINAME', 'Surinam Dollar', 'SRD', 968);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('SVALBARD AND JAN MAYEN', 'Norwegian Krone', 'NOK', 578);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('SWEDEN', 'Swedish Krona', 'SEK', 752);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('SWITZERLAND', 'Swiss Franc', 'CHF', 756);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('SWITZERLAND', 'WIR Euro', 'CHE', 947);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('SWITZERLAND', 'WIR Franc', 'CHW', 948);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('SYRIAN ARAB REPUBLIC', 'Syrian Pound', 'SYP', 760);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('TAIWAN (PROVINCE OF CHINA)', 'New Taiwan Dollar', 'TWD', 901);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('TAJIKISTAN', 'Somoni', 'TJS', 972);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('TANZANIA, UNITED REPUBLIC OF', 'Tanzanian Shilling', 'TZS', 834);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('THAILAND', 'Baht', 'THB', 764);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('TIMOR-LESTE', 'US Dollar', 'USD', 840);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('TOGO', 'CFA Franc BCEAO', 'XOF', 952);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('TOKELAU', 'New Zealand Dollar', 'NZD', 554);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('TONGA', 'Pa’anga', 'TOP', 776);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('TRINIDAD AND TOBAGO', 'Trinidad and Tobago Dollar', 'TTD', 780);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('TUNISIA', 'Tunisian Dinar', 'TND', 788);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('TURKEY', 'Turkish Lira', 'TRY', 949);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('TURKMENISTAN', 'Turkmenistan New Manat', 'TMT', 934);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('TURKS AND CAICOS ISLANDS (THE)', 'US Dollar', 'USD', 840);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('TUVALU', 'Australian Dollar', 'AUD', 036);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('UGANDA', 'Uganda Shilling', 'UGX', 800);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('UKRAINE', 'Hryvnia', 'UAH', 980);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('UNITED ARAB EMIRATES (THE)', 'UAE Dirham', 'AED', 784);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('UNITED KINGDOM OF GREAT BRITAIN AND NORTHERN IRELAND (THE)', 'Pound Sterling', 'GBP', 826);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('UNITED STATES MINOR OUTLYING ISLANDS (THE)', 'US Dollar', 'USD', 840);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('UNITED STATES OF AMERICA (THE)', 'US Dollar', 'USD', 840);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('UNITED STATES OF AMERICA (THE)', 'US Dollar (Next day)', 'USN', 997);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('URUGUAY', 'Peso Uruguayo', 'UYU', 858);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('URUGUAY', 'Uruguay Peso en Unidades Indexadas (UI)', 'UYI', 940);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('URUGUAY', 'Unidad Previsional', 'UYW', 927);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('UZBEKISTAN', 'Uzbekistan Sum', 'UZS', 860);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('VANUATU', 'Vatu', 'VUV', 548);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('VENEZUELA (BOLIVARIAN REPUBLIC OF)', 'Bolívar Soberano', 'VES', 928);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('VIET NAM', 'Dong', 'VND', 704);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('VIRGIN ISLANDS (BRITISH)', 'US Dollar', 'USD', 840);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('VIRGIN ISLANDS (U.S.)', 'US Dollar', 'USD', 840);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('WALLIS AND FUTUNA', 'CFP Franc', 'XPF', 953);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('WESTERN SAHARA', 'Moroccan Dirham', 'MAD', 504);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('YEMEN', 'Yemeni Rial', 'YER', 886);
insert into currency_codes (country, currency, alphabetic_code, numeric_code) values ('ZAMBIA', 'Zambian Kwacha', 'ZMW', 967);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment