Skip to content

Instantly share code, notes, and snippets.

View canotf's full-sized avatar

Canotf canotf

View GitHub Profile
@turbotree
turbotree / 省市表
Created March 20, 2014 08:51
中国省市表(mysql版)
DROP TABLE IF EXISTS `province`;
CREATE TABLE `province` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=gbk;
-- ----------------------------
-- Records of province
-- ----------------------------
INSERT INTO `province` VALUES ('1', '北京市');