INSERT INTO `area` VALUES (11, '330000', '0', '浙江省', 11, 'province'); INSERT INTO `area` VALUES (12, '340000', '0', '安徽省', 16, 'province'); INSERT INTO `area` VALUES (13, '350000', '0', '福建省', 9, 'province'); INSERT INTO `area` VALUES (14, '360000', '0', '江西省', 11, 'province'); INSERT INTO `area` VALUES (15, '370000', '0', '山东省', 16, 'province'); INSERT INTO `area` VALUES (137, '232700', '230000', '大兴安岭地区', 4, 'city'); INSERT INTO `area` VALUES (138, '310101', '310000', '黄浦区', 0, 'district'); IN

全国地区数据库表四级mysql，精确到街道

CREATE TABLE `region` ( `id` mediumint(7) unsigned NOT NULL AUTO_INCREMENT, `level` tinyint(1) unsigned NOT NULL COMMENT '层级', `parent_code` bigint(14) unsigned NOT NULL DEFAULT '0' COMMENT '父级行政代码', `area_code` bigint(14) unsigned NOT NULL DEFAULT '0' COMMENT '行政代码', `zip_code` mediumint(6) unsigned zerofill NOT NULL DEFAULT '000000' COMMENT '邮政编码', `city_code` char(6) NOT NULL DEFAULT '' COMMENT '区号', `name` varchar(50) NOT NULL DEFAULT '' COMMENT '名称', `short_name` varchar(50) NOT NULL DEFAULT '' COMMENT '简称', `merger_name` varchar(50) NOT NULL DEFAULT '' COMMENT '组合名', `pinyin` varchar(30) NOT NULL DEFAULT '' COMMENT '拼音', `lng` decimal(10,6) NOT NULL DEFAULT '0.000000' COMMENT '经度', `lat` decimal(10,6) NOT NULL DEFAULT '0.000000' COMMENT '纬度', PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `uk_code` (`area_code`) USING BTREE, KEY `idx_parent_code` (`parent_code`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=758050 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='中国行政地区表'; INSERT INTO `region` VALUES (1, 0, 0, 110000000000, 000000, '', '北京市', '北京', '北京', 'BeiJing', 116.407526, 39.904030); INSERT INTO `region` VALUES (2, 1, 110000000000, 110100000000, 100000, '010', '直辖区', '北京', '北京', 'BeiJing', 116.407526, 39.904030); INSERT INTO `region` VALUES (3, 2, 110100000000, 110101000000, 100000, '010', '东城区', '东城', '北京,东城', 'DongCheng', 116.416357, 39.928353);

mysql全国地区表，二级地区表，全国省份，市区，一张表存全部

-- ---------------------------- -- Table structure for xdr_regions -- ---------------------------- DROP TABLE IF EXISTS `xdr_regions`; CREATE TABLE `xdr_regions` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `p_code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '上一级编码', `code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '编码', `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '名称', `level` tinyint(4) NOT NULL COMMENT '级别:1-省，2-市，3-县，4-镇，5-村委会', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 846463 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of xdr_regions -- ---------------------------- INSERT INTO `xdr_regions` VALUES (1, '0', '11', '北京市', 1); INSERT INTO `xdr_regions` VALUES (2, '0', '12', '天津市', 1); INSERT INTO `xdr_regions` VALUES (3, '0', '13', '河北省', 1); INSERT INTO `xdr_regions` VALUES (4, '0', '14', '山西省', 1); INSERT INTO `xdr_regions` VALUES (5, '0', '15', '内蒙古自治区', 1); INSERT INTO `xdr_regions` VALUES (6, '0', '21', '辽宁省', 1); INSERT INTO `xdr_regions` VALUES (7, '0', '22', '吉林省', 1); INSERT INTO `xdr_regions` VALUES (8, '0', '23', '黑龙江省', 1); INSERT INTO `xdr_regions` VALUES (9, '0', '31', '上海市', 1); INSERT INTO `xdr_regions` VALUES (10, '0', '32', '江苏省', 1); INSERT INTO `xdr_regions` VALUES (11, '0', '33', '浙江省', 1); INSERT INTO `xdr_regions` VALUES (12, '0', '34', '安徽省', 1); INSERT INTO `xdr_regions` VALUES (13, '0', '35', '福建省', 1); INSERT INTO `xdr_regions` VALUES (14, '0', '36', '江西省', 1); INSERT INTO `xdr_regions` VALUES (15, '0', '37', '山东省', 1); INSERT INTO `xdr_regions` VALUES (16, '0', '41', '河南省', 1); INSERT INTO `xdr_regions` VALUES (17, '0', '42', '湖北省', 1); INSERT INTO `xdr_regions` VALUES (18, '0', '43', '湖南省', 1); INSERT INTO `xdr_regions` VALUES (19, '0', '44', '广东省', 1); INSERT INTO `xdr_regions` VALUES (20, '0', '45', '

包含全国所有地区、省/市(区)/县，资源中包含建表语句+数据，适用于Mysql

国家统计局2020最新区域数据，地区表，区域表

2018年最新全国地区表，表内容如下： CREATE TABLE `t_area` ( `id` int(10) unsigned NOT NULL COMMENT 'ID', `area_name` varchar(50) NOT NULL DEFAULT '' COMMENT '地区名', `parent_id` int(10) NOT NULL COMMENT '父ID', `zipcode` varchar(10) DEFAULT NULL COMMENT '邮编', PRIMARY KEY (`id`), KEY `parentid` (`parent_id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8;