Skip to content

Instantly share code, notes, and snippets.

@mizterp
mizterp / mysql_iso_country.sql
Last active April 3, 2020 18:09
MySQL Country table (data source: iso.org)
CREATE TABLE IF NOT EXISTS `country` (
`iso2` char(2) NOT NULL,
`name` varchar(45) NOT NULL,
`iso3` char(3) NOT NULL,
`numeric` smallint(3) UNSIGNED NOT NULL,
PRIMARY KEY (`iso2`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `country` (`iso2`, `name`, `iso3`, `numeric`) VALUES
('AF', 'Afghanistan', 'AFG', 4),