这篇文章将为大家详细讲解有关怎么在mysql中导入省份城市数据,文章内容质量较高,因此小编分享给大家做个参考,希望大家阅读完这篇文章后对相关知识有一定的了解。
<pre name="code" class="sql">/* 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中导入省份城市数据就分享到这里了,希望以上内容可以对大家有一定的帮助,可以学到更多知识。如果觉得文章不错,可以把它分享出去让更多的人看到。
免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。