怎么在mysql中导入省份城市数据

这篇文章将为大家详细讲解有关怎么在mysql中导入省份城市数据，文章内容质量较高，因此小编分享给大家做个参考，希望大家阅读完这篇文章后对相关知识有一定的了解。

/*SQLyog Ultimate v11.24 (32 bit)MySQL - 5.6.17 **********************************************************************//*!40101 SET NAMES utf8 */;create table `province_info` (        `provincecode` varchar (33),        `namecn` varchar (450),        `countrycode` varchar (33),        `sort` int (11)); insert into `province_info` (`provincecode`, `namecn`, `countrycode`, `sort`) values('1','北京市','156','1');insert into `province_info` (`provincecode`, `namecn`, `countrycode`, `sort`) values('2','天津市','156','2');insert into `province_info` (`provincecode`, `namecn`, `countrycode`, `sort`) values('3','上海市','156','3');insert into `province_info` (`provincecode`, `namecn`, `countrycode`, `sort`) values('4','重庆市','156','4');insert into `province_info` (`provincecode`, `namecn`, `countrycode`, `sort`) values('5','河北省','156','5');insert into `province_info` (`provincecode`, `namecn`, `countrycode`, `sort`) values('6','山西省','156','6');insert into `province_info` (`provincecode`, `namecn`, `countrycode`, `sort`) values('7','台湾省','156','34');insert into `province_info` (`provincecode`, `namecn`, `countrycode`, `sort`) values('8','辽宁省','156','7');insert into `province_info` (`provincecode`, `namecn`, `countrycode`, `sort`) values('9','吉林省','156','8');insert into `province_info` (`provincecode`, `namecn`, `countrycode`, `sort`) values('10','黑龙江省','156','9');insert into `province_info` (`provincecode`, `namecn`, `countrycode`, `sort`) values('11','江苏省','156','10');insert into `province_info` (`provincecode`, `namecn`, `countrycode`, `sort`) values('12','浙江省','156','11');insert into `province_info` (`provincecode`, `namecn`, `countrycode`, `sort`) values('13','安徽省','156','12');insert into `province_info` (`provincecode`, `namecn`, `countrycode`, `sort`) values('14','福建省','156','13');insert into `province_info` (`provincecode`, `namecn`, `countrycode`, `sort`) values('15','江西省','156','14');insert into `province_info` (`provincecode`, `namecn`, `countrycode`, `sort`) values('16','山东省','156','15');insert into `province_info` (`provincecode`, `namecn`, `countrycode`, `sort`) values('17','河南省','156','16');insert into `province_info` (`provincecode`, `namecn`, `countrycode`, `sort`) values('18','湖北省','156','17');insert into `province_info` (`provincecode`, `namecn`, `countrycode`, `sort`) values('19','湖南省','156','18');insert into `province_info` (`provincecode`, `namecn`, `countrycode`, `sort`) values('20','广东省','156','19');insert into `province_info` (`provincecode`, `namecn`, `countrycode`, `sort`) values('21','甘肃省','156','20');insert into `province_info` (`provincecode`, `namecn`, `countrycode`, `sort`) values('22','四川省','156','21');insert into `province_info` (`provincecode`, `namecn`, `countrycode`, `sort`) values('23','贵州省','156','22');insert into `province_info` (`provincecode`, `namecn`, `countrycode`, `sort`) values('24','海南省','156','23');insert into `province_info` (`provincecode`, `namecn`, `countrycode`, `sort`) values('25','云南省','156','24');insert into `province_info` (`provincecode`, `namecn`, `countrycode`, `sort`) values('26','青海省','156','25');insert into `province_info` (`provincecode`, `namecn`, `countrycode`, `sort`) values('27','陕西省','156','26');insert into `province_info` (`provincecode`, `namecn`, `countrycode`, `sort`) values('28','广西壮族自治区','156','27');insert into `province_info` (`provincecode`, `namecn`, `countrycode`, `sort`) values('29','西藏自治区','156','28');insert into `province_info` (`provincecode`, `namecn`, `countrycode`, `sort`) values('30','宁夏回族自治区','156','29');insert into `province_info` (`provincecode`, `namecn`, `countrycode`, `sort`) values('31','新疆维吾尔自治区','156','30');insert into `province_info` (`provincecode`, `namecn`, `countrycode`, `sort`) values('32','内蒙古自治区','156','31');insert into `province_info` (`provincecode`, `namecn`, `countrycode`, `sort`) values('33','澳门特别行政区','156','32');insert into `province_info` (`provincecode`, `namecn`, `countrycode`, `sort`) values('34','香港特别行政区','156','33');

create table `city_info` (        `citycode` int (11),        `sort` int (11),        `provincecode` int (11),        `namecn` varchar (150)); insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('1','1','1','北京市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('2','1','2','天津市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('3','1','3','上海市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('4','1','4','重庆市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('5','1','5','石家庄市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('6','2','5','唐山市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('7','3','5','秦皇岛市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('8','4','5','邯郸市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('9','5','5','邢台市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('10','6','5','保定市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('11','7','5','张家口市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('12','8','5','承德市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('13','9','5','沧州市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('14','10','5','廊坊市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('15','11','5','衡水市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('16','1','6','太原市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('17','2','6','大同市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('18','3','6','阳泉市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('19','4','6','长治市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('20','5','6','晋城市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('21','6','6','朔州市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('22','7','6','晋中市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('23','8','6','运城市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('24','9','6','忻州市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('25','10','6','临汾市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('26','11','6','吕梁市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('27','1','7','台北市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('28','2','7','高雄市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('29','3','7','基隆市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('30','4','7','台中市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('31','5','7','台南市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('32','6','7','新竹市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('33','7','7','嘉义市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('34','8','7','台北县');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('35','9','7','宜兰县');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('36','10','7','桃园县');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('37','11','7','新竹县');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('38','12','7','苗栗县');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('39','13','7','台中县');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('40','14','7','彰化县');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('41','15','7','南投县');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('42','16','7','云林县');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('43','17','7','嘉义县');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('44','18','7','台南县');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('45','19','7','高雄县');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('46','20','7','屏东县');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('47','21','7','澎湖县');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('48','22','7','台东县');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('49','23','7','花莲县');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('50','1','8','沈阳市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('51','2','8','大连市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('52','3','8','鞍山市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('53','4','8','抚顺市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('54','5','8','本溪市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('55','6','8','丹东市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('56','7','8','锦州市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('57','8','8','营口市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('58','9','8','阜新市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('59','10','8','辽阳市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('60','11','8','盘锦市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('61','12','8','铁岭市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('62','13','8','朝阳市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('63','14','8','葫芦岛市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('64','1','9','长春市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('65','2','9','吉林市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('66','3','9','四平市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('67','4','9','辽源市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('68','5','9','通化市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('69','6','9','白山市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('70','7','9','松原市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('71','8','9','白城市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('72','9','9','延边朝鲜族自治州');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('73','1','10','哈尔滨市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('74','2','10','齐齐哈尔市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('75','3','10','鹤岗市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('76','4','10','双鸭山市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('77','5','10','鸡西市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('78','6','10','大庆市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('79','7','10','伊春市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('80','8','10','牡丹江市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('81','9','10','佳木斯市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('82','10','10','七台河市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('83','11','10','黑河市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('84','12','10','绥化市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('85','13','10','大兴安岭地区');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('86','1','11','南京市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('87','2','11','无锡市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('88','3','11','徐州市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('89','4','11','常州市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('90','5','11','苏州市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('91','6','11','南通市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('92','7','11','连云港市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('93','8','11','淮安市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('94','9','11','盐城市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('95','10','11','扬州市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('96','11','11','镇江市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('97','12','11','泰州市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('98','13','11','宿迁市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('99','1','12','杭州市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('100','2','12','宁波市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('101','3','12','温州市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('102','4','12','嘉兴市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('103','5','12','湖州市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('104','6','12','绍兴市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('105','7','12','金华市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('106','8','12','衢州市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('107','9','12','舟山市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('108','10','12','台州市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('109','11','12','丽水市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('110','1','13','合肥市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('111','2','13','芜湖市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('112','3','13','蚌埠市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('113','4','13','淮南市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('114','5','13','马鞍山市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('115','6','13','淮北市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('116','7','13','铜陵市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('117','8','13','安庆市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('118','9','13','黄山市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('119','10','13','滁州市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('120','11','13','阜阳市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('121','12','13','宿州市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('122','13','13','巢湖市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('123','14','13','六安市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('124','15','13','亳州市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('125','16','13','池州市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('126','17','13','宣城市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('127','1','14','福州市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('128','2','14','厦门市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('129','3','14','莆田市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('130','4','14','三明市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('131','5','14','泉州市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('132','6','14','漳州市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('133','7','14','南平市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('134','8','14','龙岩市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('135','9','14','宁德市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('136','1','15','南昌市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('137','2','15','景德镇市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('138','3','15','萍乡市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('139','4','15','九江市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('140','5','15','新余市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('141','6','15','鹰潭市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('142','7','15','赣州市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('143','8','15','吉安市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('144','9','15','宜春市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('145','10','15','抚州市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('146','11','15','上饶市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('147','1','16','济南市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('148','2','16','青岛市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('149','3','16','淄博市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('150','4','16','枣庄市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('151','5','16','东营市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('152','6','16','烟台市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('153','7','16','潍坊市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('154','8','16','济宁市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('155','9','16','泰安市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('156','10','16','威海市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('157','11','16','日照市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('158','12','16','莱芜市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('159','13','16','临沂市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('160','14','16','德州市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('161','15','16','聊城市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('162','16','16','滨州市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('163','17','16','菏泽市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('164','1','17','郑州市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('165','2','17','开封市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('166','3','17','洛阳市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('167','4','17','平顶山市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('168','5','17','安阳市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('169','6','17','鹤壁市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('170','7','17','新乡市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('171','8','17','焦作市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('172','9','17','濮阳市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('173','10','17','许昌市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('174','11','17','漯河市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('175','12','17','三门峡市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('176','13','17','南阳市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('177','14','17','商丘市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('178','15','17','信阳市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('179','16','17','周口市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('180','17','17','驻马店市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('181','18','17','济源市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('182','1','18','武汉市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('183','2','18','黄石市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('184','3','18','十堰市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('185','4','18','荆州市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('186','5','18','宜昌市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('187','6','18','襄樊市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('188','7','18','鄂州市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('189','8','18','荆门市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('190','9','18','孝感市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('191','10','18','黄冈市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('192','11','18','咸宁市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('193','12','18','随州市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('194','13','18','仙桃市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('195','14','18','天门市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('196','15','18','潜江市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('197','16','18','神农架林区');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('198','17','18','恩施土家族苗族自治州');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('199','1','19','长沙市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('200','2','19','株洲市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('201','3','19','湘潭市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('202','4','19','衡阳市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('203','5','19','邵阳市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('204','6','19','岳阳市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('205','7','19','常德市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('206','8','19','张家界市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('207','9','19','益阳市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('208','10','19','郴州市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('209','11','19','永州市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('210','12','19','怀化市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('211','13','19','娄底市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('212','14','19','湘西土家族苗族自治州');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('213','1','20','广州市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('214','2','20','深圳市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('215','3','20','珠海市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('216','4','20','汕头市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('217','5','20','韶关市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('218','6','20','佛山市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('219','7','20','江门市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('220','8','20','湛江市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('221','9','20','茂名市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('222','10','20','肇庆市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('223','11','20','惠州市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('224','12','20','梅州市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('225','13','20','汕尾市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('226','14','20','河源市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('227','15','20','阳江市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('228','16','20','清远市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('229','17','20','东莞市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('230','18','20','中山市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('231','19','20','潮州市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('232','20','20','揭阳市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('233','21','20','云浮市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('234','1','21','兰州市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('235','2','21','金昌市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('236','3','21','白银市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('237','4','21','天水市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('238','5','21','嘉峪关市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('239','6','21','武威市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('240','7','21','张掖市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('241','8','21','平凉市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('242','9','21','酒泉市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('243','10','21','庆阳市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('244','11','21','定西市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('245','12','21','陇南市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('246','13','21','临夏回族自治州');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('247','14','21','甘南藏族自治州');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('248','1','22','成都市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('249','2','22','自贡市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('250','3','22','攀枝花市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('251','4','22','泸州市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('252','5','22','德阳市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('253','6','22','绵阳市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('254','7','22','广元市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('255','8','22','遂宁市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('256','9','22','内江市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('257','10','22','乐山市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('258','11','22','南充市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('259','12','22','眉山市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('260','13','22','宜宾市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('261','14','22','广安市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('262','15','22','达州市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('263','16','22','雅安市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('264','17','22','巴中市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('265','18','22','资阳市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('266','19','22','阿坝藏族羌族自治州');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('267','20','22','甘孜藏族自治州');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('268','21','22','凉山彝族自治州');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('269','1','23','贵阳市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('270','2','23','六盘水市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('271','3','23','遵义市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('272','4','23','安顺市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('273','5','23','铜仁地区');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('274','6','23','毕节地区');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('275','7','23','黔西南布依族苗族自治州');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('276','8','23','黔东南苗族侗族自治州');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('277','9','23','黔南布依族苗族自治州');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('278','1','24','海口市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('279','2','24','三亚市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('280','3','24','五指山市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('281','4','24','琼海市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('282','5','24','儋州市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('283','6','24','文昌市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('284','7','24','万宁市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('285','8','24','东方市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('286','9','24','澄迈县');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('287','10','24','定安县');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('288','11','24','屯昌县');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('289','12','24','临高县');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('290','13','24','白沙黎族自治县');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('291','14','24','昌江黎族自治县');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('292','15','24','乐东黎族自治县');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('293','16','24','陵水黎族自治县');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('294','17','24','保亭黎族苗族自治县');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('295','18','24','琼中黎族苗族自治县');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('296','1','25','昆明市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('297','2','25','曲靖市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('298','3','25','玉溪市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('299','4','25','保山市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('300','5','25','昭通市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('301','6','25','丽江市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('302','7','25','思茅市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('303','8','25','临沧市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('304','9','25','文山壮族苗族自治州');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('305','10','25','红河哈尼族彝族自治州');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('306','11','25','西双版纳傣族自治州');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('307','12','25','楚雄彝族自治州');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('308','13','25','大理白族自治州');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('309','14','25','德宏傣族景颇族自治州');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('310','15','25','怒江傈傈族自治州');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('311','16','25','迪庆藏族自治州');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('312','1','26','西宁市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('313','2','26','海东地区');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('314','3','26','海北藏族自治州');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('315','4','26','黄南藏族自治州');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('316','5','26','海南藏族自治州');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('317','6','26','果洛藏族自治州');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('318','7','26','玉树藏族自治州');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('319','8','26','海西蒙古族藏族自治州');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('320','1','27','西安市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('321','2','27','铜川市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('322','3','27','宝鸡市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('323','4','27','咸阳市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('324','5','27','渭南市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('325','6','27','延安市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('326','7','27','汉中市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('327','8','27','榆林市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('328','9','27','安康市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('329','10','27','商洛市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('330','1','28','南宁市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('331','2','28','柳州市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('332','3','28','桂林市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('333','4','28','梧州市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('334','5','28','北海市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('335','6','28','防城港市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('336','7','28','钦州市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('337','8','28','贵港市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('338','9','28','玉林市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('339','10','28','百色市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('340','11','28','贺州市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('341','12','28','河池市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('342','13','28','来宾市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('343','14','28','崇左市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('344','1','29','拉萨市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('345','2','29','那曲地区');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('346','3','29','昌都地区');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('347','4','29','山南地区');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('348','5','29','日喀则地区');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('349','6','29','阿里地区');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('350','7','29','林芝地区');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('351','1','30','银川市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('352','2','30','石嘴山市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('353','3','30','吴忠市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('354','4','30','固原市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('355','5','30','中卫市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('356','1','31','乌鲁木齐市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('357','2','31','克拉玛依市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('358','3','31','石河子市　');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('359','4','31','阿拉尔市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('360','5','31','图木舒克市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('361','6','31','五家渠市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('362','7','31','吐鲁番市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('363','8','31','阿克苏市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('364','9','31','喀什市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('365','10','31','哈密市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('366','11','31','和田市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('367','12','31','阿图什市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('368','13','31','库尔勒市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('369','14','31','昌吉市　');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('370','15','31','阜康市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('371','16','31','米泉市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('372','17','31','博乐市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('373','18','31','伊宁市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('374','19','31','奎屯市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('375','20','31','塔城市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('376','21','31','乌苏市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('377','22','31','阿勒泰市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('378','1','32','呼和浩特市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('379','2','32','包头市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('380','3','32','乌海市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('381','4','32','赤峰市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('382','5','32','通辽市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('383','6','32','鄂尔多斯市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('384','7','32','呼伦贝尔市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('385','8','32','巴彦淖尔市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('386','9','32','乌兰察布市');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('387','10','32','锡林郭勒盟');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('388','11','32','兴安盟');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('389','12','32','阿拉善盟');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('390','1','33','澳门特别行政区');insert into `city_info` (`citycode`, `sort`, `provincecode`, `namecn`) values('391','1','34','香港特别行政区');
关于怎么在mysql中导入省份城市数据就分享到这里了，希望以上内容可以对大家有一定的帮助，可以学到更多知识。如果觉得文章不错，可以把它分享出去让更多的人看到。