共计 35694 个字符,预计需要花费 90 分钟才能阅读完成。
自动写代码机器人,免费开通
这篇文章将为大家详细讲解有关怎么在 mysql 中导入省份城市数据,文章内容质量较高,因此丸趣 TV 小编分享给大家做个参考,希望大家阅读完这篇文章后对相关知识有一定的了解。
pre name= code >
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 中导入省份城市数据就分享到这里了,希望以上内容可以对大家有一定的帮助,可以学到更多知识。如果觉得文章不错,可以把它分享出去让更多的人看到。
向 AI 问一下细节
正文完