中国省市数据库表sql

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(100) NOT NULL DEFAULT '',

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=392 DEFAULT CHARSET=gbk;

-- ----------------------------

-- Records of city

-- ----------------------------

INSERT INTO `city` VALUES ('1', '1', '1', '北京市');

INSERT INTO `city` VALUES ('2', '1', '2', '天津市');

INSERT INTO `city` VALUES ('3', '1', '3', '上海市');

INSERT INTO `city` VALUES ('4', '1', '4', '重庆市');

INSERT INTO `city` VALUES ('5', '1', '5', '石家庄市');

INSERT INTO `city` VALUES ('6', '2', '5', '唐山市');

INSERT INTO `city` VALUES ('7', '3', '5', '秦皇岛市');

INSERT INTO `city` VALUES ('8', '4', '5', '邯郸市');

INSERT INTO `city` VALUES ('9', '5', '5', '邢台市');

INSERT INTO `city` VALUES ('10', '6', '5', '保定市');

INSERT INTO `city` VALUES ('11', '7', '5', '张家口市');

INSERT INTO `city` VALUES ('12', '8', '5', '承德市');

INSERT INTO `city` VALUES ('13', '9', '5', '沧州市');

INSERT INTO `city` VALUES ('14', '10', '5', '廊坊市');

INSERT INTO `city` VALUES ('15', '11', '5', '衡水市');

INSERT INTO `city` VALUES ('16', '1', '6', '太原市');

INSERT INTO `city` VALUES ('17', '2', '6', '大同市');

INSERT INTO `city` VALUES ('18', '3', '6', '阳泉市');

INSERT INTO `city` VALUES ('19', '4', '6', '长治市');

INSERT INTO `city` VALUES ('20', '5', '6', '晋城市');

INSERT INTO `city` VALUES ('21', '6', '6', '朔州市');

INSERT INTO `city` VALUES ('22', '7', '6', '晋中市');

INSERT INTO `city` VALUES ('23', '8', '6', '运城市');

INSERT INTO `city` VALUES ('24', '9', '6', '忻州市');

INSERT INTO `city` VALUES ('25', '10', '6', '临汾市');

INSERT INTO `city` VALUES ('26', '11', '6', '吕梁市');

INSERT INTO `city` VALUES ('27', '1', '7', '台北市');