MrP 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),