中国省市数据库表-MYSQL版.doc

中国省市数据库表-MYSQL版 2010-05-15 14:22 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, 北京市);INSERT INTO `province` VALUES (2, 天津市);INSERT INTO `province` VALUES (3, 上海市);INSERT INTO `province` VALUES (4, 重庆市);INSERT INTO `province` VALUES (5, 河北省);INSERT INTO `province` VALUES (6, 山西省);INSERT INTO `province` VALUES (7, 台湾省);INSERT INTO `province` VALUES (8, 辽宁省);INSERT INTO `province` VALUES (9, 吉林省);INSERT INTO `province` VALUES (10, 黑龙江省);INSERT INTO `province` VALUES (11, 江苏省);INSERT INTO `province` VALUES (12, 浙江省);INSERT INTO `province` VALUES (13, 安徽省);INSERT INTO `province` VALUES (14, 福建省);INSERT INTO `province` VALUES (15, 江西省);INSERT INTO `province` VALUES (16, 山东省);INSERT INTO `province` VALUES (17, 河南省);INSERT INTO `province` VALUES (18, 湖北省);INSERT INTO `province` VALUES (19, 湖南省);INSERT INTO `province` VALUES (20, 广东省);INSERT INTO `province` VALUES (21, 甘肃省);INSERT INTO `province` VALUES (22, 四川省);INSERT INTO `province` VALUES (23, 贵州省);INSERT INTO `province` VALUES (24, 海南省);INSERT INTO `province` VALUES (25, 云南省);INSERT INTO `province` VALUES (26, 青海省);INSERT INTO `province` VALUES (27, 陕西省);INSERT INTO `province` VALUES (28, 广西壮族自治区);INSERT INTO `province` VALUES (29, 西藏自治区);INSERT INTO `province` VALUES (30, 宁夏回族自治区);INSERT INTO `province` VALUES (31, 新疆维吾尔自治区);INSERT INTO `province` VALUES (32, 内蒙古自治区);INSERT INTO `province` VALUES (33, 澳门特别行政区);INSERT INTO `province` VALUES (34, 香港特别行政区); -- ------------------------------ Table structure for `city`-- ----------------------------DROP TABLE IF EXISTS `city`;CREATE TABLE `city` (`id` int(11) NOT NULL AUTO_INCREMENT,`city_index` int(11) NOT NULL,`province_id` int(11) NOT NULL,`name` varchar(1