electroidru
electroidru
/ currency_codes_mysql.sql
Last active
May 1, 2023 09:40
List of Currencies, countries and their codes per Currency Codes-ISO 4217 in mysql format
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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 |