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