2021省市区最新数据#yyds干货盘点#
下面是创建一个mysql的数据表然后执行添加的sql数据
/*
Navicat Premium Data Transfer
Source Server : xykj-xs3ttest
Source Server Type : MySQL
Source Server Version : 50649
Source Host : 218.29.54.19:3306
Source Schema : xs3ttest
Target Server Type : MySQL
Target Server Version : 50649
File Encoding : 65001
Date: 28/07/2021 11:52:10
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for area
-- ----------------------------
DROP TABLE IF EXISTS `area`;
CREATE TABLE `area` (
`base_areaid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`parentid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`vieworder` int(11) NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '最新省市区表' ROW_FORMAT = Compact;
-- ----------------------------
-- Records of area
-- ----------------------------
INSERT INTO `area` VALUES ('10000001', '北京市', '0', 1);
INSERT INTO `area` VALUES ('10000002', '天津市', '0', 2);
INSERT INTO `area` VALUES ('10000003', '河北省', '0', 3);
INSERT INTO `area` VALUES ('10000004', '山西省', '0', 4);
INSERT INTO `area` VALUES ('10000005', '内蒙古自治区', '0', 5);
INSERT INTO `area` VALUES ('10000006', '辽宁省', '0', 6);
INSERT INTO `area` VALUES ('10000007', '吉林省', '0', 7);
INSERT INTO `area` VALUES ('10000008', '黑龙江省', '0', 8);
INSERT INTO `area` VALUES ('10000009', '上海市', '0', 9);
INSERT INTO `area` VALUES ('10000010', '江苏省', '0', 10);
INSERT INTO `area` VALUES ('10000011', '浙江省', '0', 11);
INSERT INTO `area` VALUES ('10000012', '安徽省', '0', 12);
INSERT INTO `area` VALUES ('10000013', '福建省', '0', 13);
INSERT INTO `area` VALUES ('10000014', '江西省', '0', 14);
INSERT INTO `area` VALUES ('10000015', '山东省', '0', 15);
INSERT INTO `area` VALUES ('10000016', '河南省', '0', 16);
INSERT INTO `area` VALUES ('10000017', '湖北省', '0', 17);
INSERT INTO `area` VALUES ('10000018', '湖南省', '0', 18);
INSERT INTO `area` VALUES ('10000019', '广东省', '0', 19);
INSERT INTO `area` VALUES ('10000020', '广西壮族自治区', '0', 20);
INSERT INTO `area` VALUES ('10000021', '海南省', '0', 21);
INSERT INTO `area` VALUES ('10000022', '重庆市', '0', 22);
INSERT INTO `area` VALUES ('10000023', '四川省', '0', 23);
INSERT INTO `area` VALUES ('10000024', '贵州省', '0', 24);
INSERT INTO `area` VALUES ('10000025', '云南省', '0', 25);
INSERT INTO `area` VALUES ('10000026', '西藏自治区', '0', 26);
INSERT INTO `area` VALUES ('10000027', '陕西省', '0', 27);
INSERT INTO `area` VALUES ('10000028', '甘肃省', '0', 28);
INSERT INTO `area` VALUES ('10000029', '青海省', '0', 29);
INSERT INTO `area` VALUES ('10000030', '宁夏回族自治区', '0', 30);
INSERT INTO `area` VALUES ('10000031', '新疆维吾尔自治区', '0', 31);
INSERT INTO `area` VALUES ('10000032', '台湾省', '0', 32);
INSERT INTO `area` VALUES ('10000033', '香港特别行政区', '0', 33);
INSERT INTO `area` VALUES ('10000034', '澳门特别行政区', '0', 34);
INSERT INTO `area` VALUES ('10000037', '石家庄市', '10000003', 3);
INSERT INTO `area` VALUES ('10000038', '唐山市', '10000003', 4);
INSERT INTO `area` VALUES ('10000039', '秦皇岛市', '10000003', 5);
INSERT INTO `area` VALUES ('10000040', '邯郸市', '10000003', 6);
INSERT INTO `area` VALUES ('10000041', '邢台市', '10000003', 7);
INSERT INTO `area` VALUES ('10000042', '保定市', '10000003', 8);
INSERT INTO `area` VALUES ('10000043', '张家口市', '10000003', 9);
INSERT INTO `area` VALUES ('10000044', '承德市', '10000003', 10);
INSERT INTO `area` VALUES ('10000045', '沧州市', '10000003', 11);
INSERT INTO `area` VALUES ('10000046', '廊坊市', '10000003', 12);
INSERT INTO `area` VALUES ('10000047', '衡水市', '10000003', 13);
INSERT INTO `area` VALUES ('10000048', '太原市', '10000004', 14);
INSERT INTO `area` VALUES ('10000049', '大同市', '10000004', 15);
INSERT INTO `area` VALUES ('10000050', '阳泉市', '10000004', 16);
INSERT INTO `area` VALUES ('10000051', '长治市', '10000004', 17);
INSERT INTO `area` VALUES ('10000052', '晋城市', '10000004', 18);
INSERT INTO `area` VALUES ('10000053', '朔州市', '10000004', 19);
INSERT INTO `area` VALUES ('10000054', '晋中市', '10000004', 20);
INSERT INTO `area` VALUES ('10000055', '运城市', '10000004', 21);
INSERT INTO `area` VALUES ('10000056', '忻州市', '10000004', 22);
INSERT INTO `area` VALUES ('10000057', '临汾市', '10000004', 23);
INSERT INTO `area` VALUES ('10000058', '吕梁市', '10000004', 24);
INSERT INTO `area` VALUES ('10000059', '呼和浩特市', '10000005', 25);
INSERT INTO `area` VALUES ('10000060', '包头市', '10000005', 26);
INSERT INTO `area` VALUES ('10000061', '乌海市', '10000005', 27);
INSERT INTO `area` VALUES ('10000062', '赤峰市', '10000005', 28);
INSERT INTO `area` VALUES ('10000063', '通辽市', '10000005', 29);
INSERT INTO `area` VALUES ('10000064', '鄂尔多斯市', '10000005', 30);
INSERT INTO `area` VALUES ('10000065', '呼伦贝尔市', '10000005', 31);
INSERT INTO `area` VALUES ('10000066', '巴彦淖尔市', '10000005', 32);
INSERT INTO `area` VALUES ('10000067', '乌兰察布市', '10000005', 33);
INSERT INTO `area` VALUES ('10000068', '兴安盟', '10000005', 34);
INSERT INTO `area` VALUES ('10000069', '锡林郭勒盟', '10000005', 35);
INSERT INTO `area` VALUES ('10000070', '阿拉善盟', '10000005', 36);
INSERT INTO `area` VALUES ('10000071', '沈阳市', '10000006', 37);
INSERT INTO `area` VALUES ('10000072', '大连市', '10000006', 38);
INSERT INTO `area` VALUES ('10000073', '鞍山市', '10000006', 39);
INSERT INTO `area` VALUES ('10000074', '抚顺市', '10000006', 40);
INSERT INTO `area` VALUES ('10000075', '本溪市', '10000006', 41);
INSERT INTO `area` VALUES ('10000076', '丹东市', '10000006', 42);
INSERT INTO `area` VALUES ('10000077', '锦州市', '10000006', 43);
INSERT INTO `area` VALUES ('10000078', '营口市', '10000006', 44);
INSERT INTO `area` VALUES ('10000079', '阜新市', '10000006', 45);
INSERT INTO `area` VALUES ('10000080', '辽阳市', '10000006', 46);
INSERT INTO `area` VALUES ('10000081', '盘锦市', '10000006', 47);
INSERT INTO `area` VALUES ('10000082', '铁岭市', '10000006', 48);
INSERT INTO `area` VALUES ('10000083', '朝阳市', '10000006', 49);
INSERT INTO `area` VALUES ('10000084', '葫芦岛市', '10000006', 50);
INSERT INTO `area` VALUES ('10000085', '长春市', '10000007', 51);
INSERT INTO `area` VALUES ('10000086', '吉林市', '10000007', 52);
INSERT INTO `area` VALUES ('10000087', '四平市', '10000007', 53);
INSERT INTO `area` VALUES ('10000088', '辽源市', '10000007', 54);
INSERT INTO `area` VALUES ('10000089', '通化市', '10000007', 55);
INSERT INTO `area` VALUES ('10000090', '白山市', '10000007', 56);
INSERT INTO `area` VALUES ('10000091', '松原市', '10000007', 57);
INSERT INTO `area` VALUES ('10000092', '白城市', '10000007', 58);
INSERT INTO `area` VALUES ('10000093', '延边朝鲜族自治州', '10000007', 59);
INSERT INTO `area` VALUES ('10000094', '哈尔滨市', '10000008', 60);
INSERT INTO `area` VALUES ('10000095', '齐齐哈尔市', '10000008', 61);
INSERT INTO `area` VALUES ('10000096', '鸡西市', '10000008', 62);
INSERT INTO `area` VALUES ('10000097', '鹤岗市', '10000008', 63);
INSERT INTO `area` VALUES ('10000098', '双鸭山市', '10000008', 64);
INSERT INTO `area` VALUES ('10000099', '大庆市', '10000008', 65);
INSERT INTO `area` VALUES ('10000100', '伊春市', '10000008', 66);
INSERT INTO `area` VALUES ('10000101', '佳木斯市', '10000008', 67);
INSERT INTO `area` VALUES ('10000102', '七台河市', '10000008', 68);
INSERT INTO `area` VALUES ('10000103', '牡丹江市', '10000008', 69);
INSERT INTO `area` VALUES ('10000104', '黑河市', '10000008', 70);
INSERT INTO `area` VALUES ('10000105', '绥化市', '10000008', 71);
INSERT INTO `area` VALUES ('10000106', '大兴安岭地区', '10000008', 72);
INSERT INTO `area` VALUES ('10000108', '南京市', '10000010', 74);
INSERT INTO `area` VALUES ('10000109', '无锡市', '10000010', 75);
INSERT INTO `area` VALUES ('10000110', '徐州市', '10000010', 76);
INSERT INTO `area` VALUES ('10000111', '常州市', '10000010', 77);
INSERT INTO `area` VALUES ('10000112', '苏州市', '10000010', 78);
INSERT INTO `area` VALUES ('10000113', '南通市', '10000010', 79);
INSERT INTO `area` VALUES ('10000114', '连云港市', '10000010', 80);
INSERT INTO `area` VALUES ('10000115', '淮安市', '10000010', 81);
INSERT INTO `area` VALUES ('10000116', '盐城市', '10000010', 82);
INSERT INTO `area` VALUES ('10000117', '扬州市', '10000010', 83);
INSERT INTO `area` VALUES ('10000118', '镇江市', '10000010', 84);
INSERT INTO `area` VALUES ('10000119', '泰州市', '10000010', 85);
INSERT INTO `area` VALUES ('10000120', '宿迁市', '10000010', 86);
INSERT INTO `area` VALUES ('10000121', '杭州市', '10000011', 87);
INSERT INTO `area` VALUES ('10000122', '宁波市', '10000011', 88);
INSERT INTO `area` VALUES ('10000123', '温州市', '10000011', 89);
INSERT INTO `area` VALUES ('10000124', '嘉兴市', '10000011', 90);
INSERT INTO `area` VALUES ('10000125', '湖州市', '10000011', 91);
INSERT INTO `area` VALUES ('10000126', '绍兴市', '10000011', 92);
INSERT INTO `area` VALUES ('10000127', '金华市', '10000011', 93);
INSERT INTO `area` VALUES ('10000128', '衢州市', '10000011', 94);
INSERT INTO `area` VALUES ('10000129', '舟山市', '10000011', 95);
INSERT INTO `area` VALUES ('10000130', '台州市', '10000011', 96);
INSERT INTO `area` VALUES ('10000131', '丽水市', '10000011', 97);
INSERT INTO `area` VALUES ('10000132', '合肥市', '10000012', 98);
INSERT INTO `area` VALUES ('10000133', '芜湖市', '10000012', 99);
INSERT INTO `area` VALUES ('10000134', '蚌埠市', '10000012', 100);
INSERT INTO `area` VALUES ('10000135', '淮南市', '10000012', 101);
INSERT INTO `area` VALUES ('10000136', '马鞍山市', '10000012', 102);
INSERT INTO `area` VALUES ('10000137', '淮北市', '10000012', 103);
INSERT INTO `area` VALUES ('10000138', '铜陵市', '10000012', 104);
INSERT INTO `area` VALUES ('10000139', '安庆市', '10000012', 105);
INSERT INTO `area` VALUES ('10000140', '黄山市', '10000012', 106);
INSERT INTO `area` VALUES ('10000141', '滁州市', '10000012', 107);
INSERT INTO `area` VALUES ('10000142', '阜阳市', '10000012', 108);
INSERT INTO `area` VALUES ('10000143', '宿州市', '10000012', 109);
INSERT INTO `area` VALUES ('10000144', '六安市', '10000012', 110);
INSERT INTO `area` VALUES ('10000145', '亳州市', '10000012', 111);
INSERT INTO `area` VALUES ('10000146', '池州市', '10000012', 112);
INSERT INTO `area` VALUES ('10000147', '宣城市', '10000012', 113);
INSERT INTO `area` VALUES ('10000148', '福州市', '10000013', 114);
INSERT INTO `area` VALUES ('10000149', '厦门市', '10000013', 115);
INSERT INTO `area` VALUES ('10000150', '莆田市', '10000013', 116);
INSERT INTO `area` VALUES ('10000151', '三明市', '10000013', 117);
INSERT INTO `area` VALUES ('10000152', '泉州市', '10000013', 118);
INSERT INTO `area` VALUES ('10000153', '漳州市', '10000013', 119);
INSERT INTO `area` VALUES ('10000154', '南平市', '10000013', 120);
-----------------------------------
https://github.com/leoparddne/Areas/blob/master/%E7%9C%81%E5%B8%82%E5%8C%BA%E6%95%B0%E6%8D%AE%E5%BA%93.sql
- 上一篇 »gojs 无水印版
- 下一篇 »Wireshark的Openflow扩展