electroidru

Full stack Web and Mobile developer

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

	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