/*
Navicat Premium Data Transfer
Source Server : 本地MySQL
Source Server Type : MySQL
Source Server Version : 80012
Source Host : localhost:3306
Source Schema : position
Target Server Type : MySQL
Target Server Version : 80012
File Encoding : 65001
Date: 20/05/2019 08:20:01
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for city
-- ----------------------------
DROP TABLE IF EXISTS `city`;
CREATE TABLE `city` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`code` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`province_id` int(10) UNSIGNED NOT NULL,
PRIMARY KEY (`id`) USING BTREE,
INDEX `fk_city_province_idx`(`province_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of city
-- ----------------------------
INSERT INTO `city` VALUES (1, '市辖区', '110100000000', 1);
INSERT INTO `city` VALUES (2, '市辖区', '120100000000', 2);
INSERT INTO `city` VALUES (3, '石家庄市', '130100000000', 3);
INSERT INTO `city` VALUES (4, '唐山市', '130200000000', 3);
INSERT INTO `city` VALUES (5, '秦皇岛市', '130300000000', 3);
INSERT INTO `city` VALUES (6, '邯郸市', '130400000000', 3);
INSERT INTO `city` VALUES (7, '邢台市', '130500000000', 3);
INSERT INTO `city` VALUES (8, '保定市', '130600000000', 3);
INSERT INTO `city` VALUES (9, '张家口市', '130700000000', 3);
INSERT INTO `city` VALUES (10, '承德市', '130800000000', 3);
INSERT INTO `city` VALUES (11, '沧州市', '130900000000', 3);
INSERT INTO `city` VALUES (12, '廊坊市', '131000000000', 3);
INSERT INTO `city` VALUES (13, '衡水市', '131100000000', 3);
INSERT INTO `city` VALUES (14, '太原市', '140100000000', 4);
INSERT INTO `city` VALUES (15, '大同市', '140200000000', 4);
INSERT INTO `city` VALUES (16, '阳泉市', '140300000000', 4);
INSERT INTO `city` VALUES (17, '长治市', '140400000000', 4);
INSERT INTO `city` VALUES (18, '晋城市', '140500000000', 4);
INSERT INTO `city` VALUES (19, '朔州市', '140600000000', 4);
INSERT INTO `city` VALUES (20, '晋中市', '140700000000', 4);
INSERT INTO `city` VALUES (21, '运城市', '140800000000', 4);
INSERT INTO `city` VALUES (22, '忻州市', '140900000000', 4);
INSERT INTO `city` VALUES (23, '临汾市', '141000000000', 4);
INSERT INTO `city` VALUES (24, '吕梁市', '141100000000', 4);
INSERT INTO `city` VALUES (25, '呼和浩特市', '150100000000', 5);
INSERT INTO `city` VALUES (26, '包头市', '150200000000', 5);
INSERT INTO `city` VALUES (27, '乌海市', '150300000000', 5);
INSERT INTO `city` VALUES (28, '赤峰市', '150400000000', 5);
INSERT INTO `city` VALUES (29, '通辽市', '150500000000', 5);
INSERT INTO `city` VALUES (30, '鄂尔多斯市', '150600000000', 5);
INSERT INTO `city` VALUES (31, '呼伦贝尔市', '150700000000', 5);
INSERT INTO `city` VALUES (32, '巴彦淖尔市', '150800000000', 5);
INSERT INTO `city` VALUES (33, '乌兰察布市', '150900000000', 5);
INSERT INTO `city` VALUES (34, '兴安盟', '152200000000', 5);
INSERT INTO `city` VALUES (35, '锡林郭勒盟', '152500000000', 5);
INSERT INTO `city` VALUES (36, '阿拉善盟', '152900000000', 5);
INSERT INTO `city` VALUES (37, '沈阳市', '210100000000', 6);
INSERT INTO `city` VALUES (38, '大连市', '210200000000', 6);
INSERT INTO `city` VALUES (39, '鞍山市', '210300000000', 6);
INSERT INTO `city` VALUES (40, '抚顺市', '210400000000', 6);
INSERT INTO `city` VALUES (41, '本溪市', '210500000000', 6);
INSERT INTO `city` VALUES (42, '丹东市', '210600000000', 6);
INSERT INTO `city` VALUES (43, '锦州市', '210700000000', 6);
INSERT INTO `city` VALUES (44, '营口市', '210800000000', 6);
INSERT INTO `city` VALUES (45, '阜新市', '210900000000', 6);
INSERT INTO `city` VALUES (46, '辽阳市', '211000000000', 6);
INSERT INTO `city` VALUES (47, '盘锦市', '211100000000', 6);
INSERT INTO `city` VALUES (48, '铁岭市', '211200000000', 6);
INSERT INTO `city` VALUES (49, '朝阳市', '211300000000', 6);
INSERT INTO `city` VALUES (50, '葫芦岛市', '211400000000', 6);
INSERT INTO `city` VALUES (51, '长春市', '220100000000', 7);
INSERT INTO `city` VALUES (52, '吉林市', '220200000000', 7);
INSERT INTO `city` VALUES (53, '四平市', '220300000000', 7);
INSERT INTO `city` VALUES (54, '辽源市', '220400000000', 7);
INSERT INTO `city` VALUES (55, '通化市', '220500000000', 7);
INSERT INTO `city` VALUES (56, '白山市', '220600000000', 7);
INSERT INTO `city` VALUES (57, '松原市', '220700000000', 7);
INSERT INTO `city` VALUES (58, '白城市', '220800000000', 7);
INSERT INTO `city` VALUES (59, '延边朝鲜族自治州', '222400000000', 7);
INSERT INTO `city` VALUES (60, '哈尔滨市', '230100000000', 8);
INSERT INTO `city` VALUES (61, '齐齐哈尔市', '230200000000', 8);
INSERT INTO `city` VALUES (62, '鸡西市', '230300000000', 8);
INSERT INTO `city` VALUES (63, '鹤岗市', '230400000000', 8);
INSERT INTO `city` VALUES (64, '双鸭山市', '230500000000', 8);
INSERT INTO `city` VALUES (65, '大庆市', '230600000000', 8);
INSERT INTO `city` VALUES (66, '伊春市', '230700000000', 8);
INSERT INTO `city` VALUES (67, '佳木斯市', '230800000000', 8);
INSERT INTO `city` VALUES (68, '七台河市', '230900000000', 8);
INSERT INTO `city` VALUES (69, '牡丹江市', '231000000000', 8);
INSERT INTO `city` VALUES (70, '黑河市', '231100000000', 8);
INSERT INTO `city` VALUES (71, '绥化市', '231200000000', 8);
INSERT INTO `city` VALUES (72, '大兴安岭地区', '232700000000', 8);
INSERT INTO `city` VALUES (73, '市辖区', '310100000000', 9);
INSERT INTO `city` VALUES (74, '南京市', '320100000000', 10);
INSERT INTO `city` VALUES (75, '无锡市', '320200000000', 10);
INSERT INTO `city` VALUES (76, '徐州市', '320300000000', 10);
INSERT INTO `city` VALUES (77, '常州市', '320400000000', 10);
INSERT INTO `city` VALUES (78, '苏州市', '320500000000', 10);
INSERT INTO `city` VALUES (79, '南通市', '320600000000', 10);
INSERT INTO `city` VALUES (80, '连云港市', '320700000000', 10);
INSERT INTO `city` VALUES (81, '淮安市', '320800000000', 10);
INSERT INTO `city` VALUES (82, '盐城市', '320900000000', 10);
INSERT INTO `city` VALUES (83, '扬州市', '321000000000', 10);
INSERT INTO `city` VALUES (84, '镇江市', '321100000000', 10);
INSERT INTO `city` VALUES (85, '泰州市', '321200000000', 10);
INSERT INTO `city` VALUES (86, '宿迁市', '321300000000', 10);
INSERT INTO `city` VALUES (87, '杭州市', '330100000000', 11);
INSERT INTO `city` VALUES (88, '宁波市', '330200000000', 11);
INSERT INTO `city` VALUES (89, '温州市', '330300000000', 11);
INSERT INTO `city` VALUES (90, '嘉兴市', '330400000000', 11);
INSERT INTO `city` VALUES (91, '湖州市', '330500000000', 11);
INSERT INTO `city` VALUES (92, '绍兴市', '330600000000', 11);
INSERT INTO `city` VALUES (93, '金华市', '330700000000', 11);
INSERT INTO `city` VALUES (94, '衢州市', '330800000000', 11);
INSERT INTO `city` VALUES (95, '舟山市', '330900000000', 11);
INSERT INTO `city` VALUES (96, '台州市', '331000000000', 11);
INSERT INTO `city` VALUES (97, '丽水市', '331100000000', 11);
INSERT INTO `city` VALUES (98, '合肥市', '340100000000', 12);
INSERT INTO `city` VALUES (99, '芜湖市', '340200000000', 12);
INSERT INTO `city` VALUES (100, '蚌埠市', '340300000000', 12);
INSERT INTO `city` VALUES (101, '淮南市', '340400000000', 12);
INSERT INTO `city` VALUES (102, '马鞍山市', '340500000000', 12);
INSERT INTO `city` VALUES (103, '淮北市', '340600000000', 12);
INSERT INTO `city` VALUES (104, '铜陵市', '340700000000', 12);
INSERT INTO `city` VALUES (105, '安庆市', '34
没有合适的资源?快使用搜索试试~ 我知道了~
温馨提示
修正上一版生僻字乱码问题 数据来源:http://www.stats.gov.cn/tjsj/tjbz/tjyqhdmhcxhfdm/2018/ 其中:province:31条,city:343条,district:3,285条,town:43,563条,village:666,260条 解压后60.3M 数据表关系看字段名就能明白 使用MySQL8.0.12 使用Navicat导出的数据 生成的插入语句是标准的MySQL语句,如果出现导入失败可能是MySQL版过低,在理解文件中的生成表的MySQL语句基础上,重建数据表就可以解决问题。
资源推荐
资源详情
资源评论
收起资源包目录
position.rar (1个子文件)
position.sql 60.38MB
共 1 条
- 1
资源评论
- w_wsh762020-01-10必须五星评价,找了很久了,估计统计局马上会更新2019年的最新数据了。luojxun2020-10-19不好意思,之前没看到那里设置下载积分,我现在设置下载积分为0
luojxun
- 粉丝: 35
- 资源: 30
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功