省市Insert语句.net

insert city (CityID,CityName,ProvinceID) values ( 1,'北京市',1)
insert city (CityID,CityName,ProvinceID) values ( 2,'天津市',2)
insert city (CityID,CityName,ProvinceID) values ( 3,'上海市',3)
insert city (CityID,CityName,ProvinceID) values ( 4,'重庆市',4)
insert city (CityID,CityName,ProvinceID) values ( 5,'石家庄市',5)
insert city (CityID,CityName,ProvinceID) values ( 6,'唐山市',5)
insert city (CityID,CityName,ProvinceID) values ( 7,'秦皇岛市',5)
insert city (CityID,CityName,ProvinceID) values ( 8,'邯郸市',5)
insert city (CityID,CityName,ProvinceID) values ( 9,'邢台市',5)
insert city (CityID,CityName,ProvinceID) values ( 10,'保定市',5)

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