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

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

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

关于怎么在mysql中导入省份城市数据就分享到这里了，希望以上内容可以对大家有一定的帮助，可以学到更多知识。如果觉得文章不错，可以把它分享出去让更多的人看到。