José Marcos joseMarcosJ

joseMarcosJ / gist:f2dba5e7604d9bac242c52e2831e055e

Created November 25, 2024 18:36 — forked from voskobovich/gist:537b2000108e4781f70b

List of most currency ISO code and symbol format in SQL.

	DROP TABLE currency;

	-- Create table variable
	CREATE TABLE currency (
	name VARCHAR(20),
	code VARCHAR(3),
	symbol VARCHAR(5)
	);

	ALTER TABLE currency CONVERT TO CHARACTER SET utf8;

joseMarcosJ / ISO currencies

Created November 25, 2024 18:34 — forked from jorgsowa/ISO currencies

Table with all currencies for MySQl database

	# List of currencies based on the official ISO standard
	# https://www.currency-iso.org/en/home/tables/table-a1.html
	CREATE TABLE `currencies` (
	country VARCHAR(100),
	currency VARCHAR(100),
	code VARCHAR(4),
	minor_unit SMALLINT,
	symbol VARCHAR(100)
	);