之前从网上找的三级联动都太老了,数据也都是很久之前的数据,所以自己把从国家统计局扒下来的省市县三级联动数据做了整理,目前最新的三级联动,童叟无欺。大家看北京市和天津市的几个分区就知道是最新的了。
INSERT INTO `address` VALUES (1, '110000', 0, '北京市', 1);
INSERT INTO `address` VALUES (2, '110100', 110000, '市辖区', 2);
INSERT INTO `address` VALUES (3, '110101', 110100, '东城区', 3);
INSERT INTO `address` VALUES (4, '110102', 110100, '西城区', 3);
INSERT INTO `address` VALUES (5, '110105', 110100, '朝阳区', 3);
INSERT INTO `address` VALUES (6, '110106', 110100, '丰台区', 3);
INSERT INTO `address` VALUES (7, '110107', 110100, '石景山区', 3);
INSERT INTO `address` VALUES (8, '110108', 110100, '海淀区', 3);
INSERT INTO `address` VALUES (9, '110109', 110100, '门头沟区', 3);
INSERT INTO `address` VALUES (10, '110111', 110100, '房山区', 3);
INSERT INTO `address` VALUES (11, '110112', 110100, '通州区', 3);
INSERT INTO `address` VALUES (12, '110113', 110100, '顺义区', 3);
INSERT INTO `address` VALUES (13, '110114', 110100, '昌平区', 3);
INSERT INTO `address` VALUES (14, '110115', 110100, '大兴区', 3);
INSERT INTO `address` VALUES (15, '110116', 110100, '怀柔区', 3);
INSERT INTO `address` VALUES (16, '110117', 110100, '平谷区', 3);
INSERT INTO `address` VALUES (17, '110118', 110100, '密云区', 3);
INSERT INTO `address` VALUES (18, '110119', 110100, '延庆区', 3);
INSERT INTO `address` VALUES (19, '120000', 0, '天津市', 1);
INSERT INTO `address` VALUES (20, '120100', 120000, '市辖区', 2);
INSERT INTO `address` VALUES (21, '120101', 120100, '和平区', 3);
INSERT INTO `address` VALUES (22, '120102', 120100, '河东区', 3);
INSERT INTO `address` VALUES (23, '120103', 120100, '河西区', 3);
INSERT INTO `address` VALUES (24, '120104', 120100, '南开区', 3);
INSERT INTO `address` VALUES (25, '120105', 120100, '河北区', 3);
INSERT INTO `address` VALUES (26, '120106', 120100, '红桥区', 3);
INSERT INTO `address` VALUES (27, '120110', 120100, '东丽区', 3);
INSERT INTO `address` VALUES (28, '120111', 120100, '西青区', 3);
INSERT INTO `address` VALUES (29, '120112', 120100, '津南区', 3);
INSERT INTO `address` VALUES (30, '120113', 120100, '北辰区', 3);
INSERT INTO `address` VALUES (31, '120114', 120100, '武清区', 3);
INSERT INTO `address` VALUES (32, '120115', 120100, '宝坻区', 3);
INSERT INTO `address` VALUES (33, '120116', 120100, '滨海新区', 3);
INSERT INTO `address` VALUES (34, '120117', 120100, '宁河区', 3);
INSERT INTO `address` VALUES (35, '120118', 120100, '静海区', 3);
INSERT INTO `address` VALUES (36, '120119', 120100, '蓟州区', 3);