Skip to content

Instantly share code, notes, and snippets.

View alahijani's full-sized avatar

Ali Lahijani alahijani

  • Irvine, California
View GitHub Profile
@nobuti
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'),