文件名称：mysql全国地区详细数据表带街道社区村庄
文件大小：131.71MB
文件格式：SQL
更新时间：2021-08-14 07:45:01
mysql 全国地区
CREATE TABLE IF NOT EXISTS `j_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`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='省市县镇村数据' AUTO_INCREMENT=693338 ;.............................. -- -- 转存表中的数据 `j_position` -- INSERT INTO `j_position` (`id`, `province_id`, `province_name`, `city_id`, `city_name`, `county_id`, `county_name`, `town_id`, `town_name`, `village_id`, `village_name`) VALUES (1, 110, '北京市', 110100000000, '市辖区', 110101000000, '东城区', 110101001000, '东华门街道办事处', 110101001001, '多福巷社区'), (2, 110, '北京市', 110100000000, '市辖区', 110101000000, '东城区', 110101001000, '东华门街道办事处', 110101001002, '银闸社区'), (3, 110, '北京市', 110100000000, '市辖区', 110101000000, '东城区', 110101001000, '东华门街道办事处', 110101001005, '东厂社区'), (4, 110, '北京市', 110100000000, '市辖区', 110101000000, '东城区', 110101001000, '东华门街道办事处', 110101001006, '智德社区'),