文件名称：中国5级省市县镇村MySQL完整数据-SQL文件
文件大小：13.62MB
文件格式：RAR
更新时间：2021-02-01 11:53:25
5级省市 5级联动 Mysql数据 sql文件
中国五级省市县镇村的MySQL完整数据，已经做成SQL文件，带建表语句 /* Navicat MySQL Data Transfer Target Server Type : MYSQL Target Server Version : 50612 File Encoding : 65001 Date: 2017-03-07 16:05:36 */ DROP TABLE IF EXISTS `thk_position`; CREATE TABLE `thk_position` ( `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`), KEY `province_id` (`province_id`) USING BTREE, KEY `city_id` (`city_id`) USING BTREE, KEY `town_id` (`town_id`) USING BTREE, KEY `county_id` (`county_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=693338 DEFAULT CHARSET=utf8 COMMENT='省市县镇村数据'; INSERT INTO `thk_position` VALUES ('1', '110', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101001000', '东华门街道办事处', '110101001001', '多福巷社区');
【文件预览】：
ssyc_position.sql