MySQL的5级地区sql文件

/* Navicat MySQL Data Transfer Source Server : spzx_server Source Server Version : 50718 Source Host : 221.236.16.233:23306 Source Database : spzx123 Target Server Type : MYSQL Target Server Version : 50718 File Encoding : 65001 Date: 2017-08-31 12:50:10 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for spzx_business_position_all -- ---------------------------- DROP TABLE IF EXISTS `spzx_business_position_all`; CREATE TABLE `spzx_business_position_all` ( `id` int(11) NOT NULL AUTO_INCREMENT, `province_id` bigint(20) unsigned NOT NULL, `province_name` char(64) NOT NULL, `city_id` bigint(20) unsigned NOT NULL, `city_name` char(64) NOT NULL, `county_id` bigint(20) unsigned NOT NULL, `county_name` char(64) NOT NULL, `town_id` bigint(20) unsigned NOT NULL, `town_name` char(64) NOT NULL, `village_id` bigint(20) unsigned NOT NULL, `village_name` char(64) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `village_id` (`village_id`) ) ENGINE=InnoDB AUTO_INCREMENT=693338 DEFAULT CHARSET=utf8 COMMENT='省市县镇村数据'; -- ---------------------------- -- Records of spzx_business_position_all -- ---------------------------- INSERT INTO `spzx_business_position_all` VALUES ('1', '110000000000', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101001000', '东华门街道办事处', '110101001001', '多福巷社区'); INSERT INTO `spzx_business_position_all` VALUES ('2', '110000000000', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101001000', '东华门街道办事处', '110101001002', '银闸社区'); INSERT INTO `spzx_business_position_all` VALUES ('3', '110000000000', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101001000', '东华门街道办事处', '110101001005', '东厂社区'); INSERT INTO `spzx_business_position_all` VALUES ('4', '110000000000', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101001000', '东华门街道办事处', '110101001006', '智德社区'); INSERT INTO `spzx_business_position_all` VALUES ('5', '110000000000', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101001000', '东华门街道办事处', '110101001007', '南池子社区'); INSERT INTO `spzx_business_position_all` VALUES ('6', '110000000000', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101001000', '东华门街道办事处', '110101001008', '黄图岗社区'); INSERT INTO `spzx_business_position_all` VALUES ('7', '110000000000', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101001000', '东华门街道办事处', '110101001009', '灯市口社区'); INSERT INTO `spzx_business_position_all` VALUES ('8', '110000000000', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101001000', '东华门街道办事处', '110101001010', '正义路社区'); INSERT INTO `spzx_business_position_all` VALUES ('9', '110000000000', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101001000', '东华门街道办事处', '110101001011', '甘雨社区'); INSERT INTO `spzx_business_position_all` VALUES ('10', '110000000000', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101001000', '东华门街道办事处', '110101001013', '台基厂社区'); INSERT INTO `spzx_business_position_all` VALUES ('11', '110000000000', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101001000', '东华门街道办事处', '110101001014', '韶九社区'); INSERT INTO `spzx_business_position_all` VALUES ('12', '110000000000', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101001000', '东华门街道办事处', '110101001015', '王府井社区'); INSERT INTO `spzx_business_position_all` VALUES ('13', '110000000000', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101002000', '景山街道办事处', '110101002001', '隆福寺社区'); INSERT INTO `spzx_business_position_all` VALUES ('14', '110000000000', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101002000', '景山街道办事处', '110101002002', '吉祥社区'); INSERT INTO `spzx_business_position_all` VALUES ('15', '110000000000', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101002000', '景山街道办事处', '110101002003', '黄化门社区'); INSERT INTO `spzx_business_position_all` VALUES ('16', '110000000000', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101002000', '景山街道办事处', '110101002004', '钟鼓社区'); INSERT INTO `spzx_business_position_all` VALUES ('17', '110000000000', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101002000', '景山街道办事处', '110101002005', '魏家社区'); INSERT INTO `spzx_business_position_all` VALUES ('18', '110000000000', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101002000', '景山街道办事处', '110101002006', '汪芝麻社区'); INSERT INTO `spzx_business_position_all` VALUES ('19', '110000000000', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101002000', '景山街道办事处', '110101002008', '景山东街社区'); INSERT INTO `spzx_business_position_all` VALUES ('20', '110000000000', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101002000', '景山街道办事处', '110101002009', '皇城根北街社区'); INSERT INTO `spzx_business_position_all` VALUES ('21', '110000000000', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101003000', '交道口街道办事处', '110101003001', '交东社区'); INSERT INTO `spzx_business_position_all` VALUES ('22', '110000000000', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101003000', '交道口街道办事处', '110101003002', '福祥社区'); INSERT INTO `spzx_business_position_all` VALUES ('23', '110000000000', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101003000', '交道口街道办事处', '110101003003', '大兴社区'); INSERT INTO `spzx_business_position_all` VALUES ('24', '110000000000', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101003000', '交道口街道办事处', '110101003005', '府学社区'); INSERT INTO `spzx_business_position_all` VALUES ('25', '110000000000', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101003000', '交道口街道办事处', '110101003007', '鼓楼苑社区'); INSERT INTO `spzx_business_position_all` VALUES ('26', '110000000000', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101003000', '交道口街道办事处', '110101003008', '菊儿社区'); INSERT INTO `spzx_business_position_all` VALUES ('27', '110000000000', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101003000', '交道口街道办事处', '110101003009', '南锣鼓巷社区'); INSERT INTO `spzx_business_position_all` VALUES ('28', '110000000000', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101004000', '安定门街道办事处', '110101004001', '交北头条社区'); INSERT INTO `spzx_business_position_all` VALUES ('29', '110000000000', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101004000', '安定门街道办事处', '110101004002', '北锣鼓巷社区'); INSERT INTO `spzx_business_position_all` VALUES ('30', '110000000000', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101004000', '安定门街道办事处', '110101004003', '国子监社区'); INSERT INTO `spzx_business_position_all` VALUES ('31', '110000000000', '北京市', '110100000000'