Klaubinho

voskobovich / gist:537b2000108e4781f70b

Last active June 30, 2024 01:33

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;