Ali Lahijani alahijani

nobuti / gist:3816985

Created October 2, 2012 07:11

MySQL tables for continent names, country names and their ISO codes

	CREATE TABLE IF NOT EXISTS `continents` (
	`code` CHAR(2) NOT NULL COMMENT 'Continent code',
	`name` VARCHAR(255),
	PRIMARY KEY (`code`)
	) ENGINE=InnoDB;

	INSERT INTO `continents` VALUES
	('AF', 'Africa'),
	('AS', 'Asia'),
	('EU', 'Europe'),