全国城市数据库录入sql语句

CREATE TABLE Province(ProvinceID INT Primary Key ,Name nvarchar(50))
CREATE TABLE City(CityID INT Primary Key ,ProvinceID INT ,Name nvarchar(50))

INSERT INTO Province(ProvinceID,Name)VALUES('1','北京')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('1','东城区','1')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('2','西城区','1')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('3','宣武区','1')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('4','崇文区','1')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('5','朝阳区','1')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('6','海淀区','1')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('7','丰台区','1')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('8','石景山区','1')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('9','门头沟区','1')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('10','昌平区','1')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('11','大兴区','1')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('12','怀柔区','1')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('13','密云县','1')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('14','平谷区','1')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('15','顺义区','1')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('16','通州区','1')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('17','延庆县','1')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('103','房山区','1')
INSERT INTO Province(ProvinceID,Name)VALUES('2','上海')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('18','黄浦区','2')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('19','南市区','2')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('20','卢湾区','2')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('21','徐汇区','2')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('22','长宁区','2')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('23','静安区','2')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('24','普陀区','2')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('25','金山区','2')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('26','闸北区','2')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('27','虹口区','2')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('28','杨浦区','2')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('29','宝山区','2')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('30','闵行区','2')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('31','嘉定区','2')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('32','松江区','2')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('33','浦东新区','2')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('34','青浦县','2')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('35','奉贤县','2')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('36','南汇县','2')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('37','崇明县','2')
INSERT INTO Province(ProvinceID,Name)VALUES('3','天津')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('38','和平区','3')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('39','河东区','3')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('40','河西区','3')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('41','河北区','3')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('42','南开区','3')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('43','红桥区','3')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('44','塘沽区','3')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('45','汉沽区','3')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('105','大港区','3')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('106','东丽区','3')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('107','西青区','3')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('108','津南区','3')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('109','北辰区','3')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('110',' 武清区','3')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('111','宝坻区','3')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('112','蓟 县','3')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('113','宁河县','3')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('114','静海县','3')
INSERT INTO Province(ProvinceID,Name)VALUES('4',' 重庆')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('46','永川市','4')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('47','黔江区','4')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('48','涪陵区','4')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('49','万洲区','4')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('115','渝中区','4')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('116','大渡口区','4')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('117','江北区','4')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('118','沙坪坝区','4')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('119','九龙坡区','4')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('120','南岸区','4')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('121','北碚区','4')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('122',' 万盛区','4')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('123','双桥区','4')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('124','渝北区','4')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('125','巴南区','4')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('126','长寿区','4')
INSERT INTO Province(ProvinceID,Name)VALUES('5',' 黑龙江')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('50','哈尔滨','5')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('51','齐齐哈尔','5')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('52','牡丹江','5')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('127','鹤岗','5')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('128','双鸭山','5')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('129','鸡西','5')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('130','大庆','5')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('131','伊春','5')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('132','佳木斯','5')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('133','七台河','5')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('134','黑河','5')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('135','绥化','5')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('136','大兴安岭地区','5')
INSERT INTO Province(ProvinceID,Name)VALUES('6','吉林')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('53','长春','6')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('54','吉林','6')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('137','四平','6')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('138','辽源','6')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('139','通化','6')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('140','白山','6')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('141','松原','6')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('142','白城','6')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('143','延边朝鲜族自治州','6')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('449','高新','6')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('450','延吉','6')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('451','梅河口','6')
INSERT INTO Province(ProvinceID,Name)VALUES('7','辽宁')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('55','沈阳','7')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('56','大连','7')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('57','锦州','7')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('144','鞍山','7')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('145','抚顺','7')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('146','本溪','7')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('147','丹东','7')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('148','葫芦岛','7')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('149','营口','7')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('150','盘锦','7')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('151','阜新','7')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('152','辽阳','7')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('153','铁岭','7')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('154','朝阳','7')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('467','瓦房店','7')
INSERT INTO Province(ProvinceID,Name)VALUES('8','内蒙古')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('58','呼和浩特','8')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('59','包头','8')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('155','乌海','8')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('156','赤峰','8')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('157','通辽','8')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('158','鄂尔多斯','8')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('160','乌兰察布盟','8')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('161','锡林郭勒盟','8')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('162','巴彦淖尔盟','8')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('163','阿拉善盟','8')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('164','兴安盟','8')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('468','巴彦淖尔','8')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('469','呼伦贝尔','8')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('470','集宁','8')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('471',' 乌兰浩特','8')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('472','锡林浩特','8')
INSERT INTO Province(ProvinceID,Name)VALUES('9','宁夏')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('60','银川','9')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('165','石嘴山','9')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('166','吴忠','9')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('167','固原','9')
INSERT INTO Province(ProvinceID,Name)VALUES('10','新疆')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('61','乌鲁木齐','10')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('168','克拉玛依','10')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('169','吐鲁番地区','10')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('170','哈密地区','10')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('171','和田地区','10')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('172','阿克苏地区','10')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('173','喀什地区','10')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('174','克孜勒苏柯尔克孜自治州','10')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('175','巴音郭楞蒙古自治州','10')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('176','昌吉回族自治州','10')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('177','博尔塔拉蒙古自治州','10')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('178','伊犁哈萨克自治州','10')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('500','阿克苏','10')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('501','昌吉','10')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('502','哈密','10')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('503','和田','10')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('504','喀什','10')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('505','克拉马依','10')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('506','库尔勒','10')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('507','石河子','10')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('508','吐鲁番','10')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('509',' 乌市','10')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('510','奎屯','10')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('511','伊犁','10')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('512','伊宁','10')
INSERT INTO Province(ProvinceID,Name)VALUES('11','青海')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('62','西宁','11')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('179','海东地区','11')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('180',' 海北藏族自治州','11')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('181','黄南藏族自治州','11')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('182','海南藏族自治州','11')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('183','果洛藏族自治州','11')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('184','玉树藏族自治州','11')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('185','海西蒙古族藏族自治州','11')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('473','格尔木','11')
INSERT INTO Province(ProvinceID,Name)VALUES('12','甘肃')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('63','兰州','12')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('64','天水','12')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('186','金昌','12')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('187','白银','12')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('188','嘉峪关','12')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('189','武 威 ','12')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('190','张掖','12')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('191','平凉','12')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('192','酒泉','12')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('193','庆阳','12')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('194','定西地区','12')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('195','陇南地区','12')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('196','甘南藏族自治州','12')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('197','临夏回族自治州','12')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('422','嘉峪','12')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('423','武威','12')
INSERT INTO Province(ProvinceID,Name)VALUES('13','陕西')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('65','西安','13')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('66','宝鸡','13')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('67','延安','13')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('198','铜川','13')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('199','咸阳','13')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('200','渭南','13')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('201','汉中','13')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('202','榆林','13')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('203','安康','13')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('204','商洛','13')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('496','韩城','13')
INSERT INTO Province(ProvinceID,Name)VALUES('14','河北')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('68','石家庄','14')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('69','保定','14')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('205','唐山','14')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('206','秦皇岛','14')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('207','邯郸','14')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('208','邢台','14')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('209','张家口','14')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('210','承德','14')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('211','沧州','14')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('212','廊坊','14')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('213','衡水','14')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('436','霸州','14')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('437','青县','14')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('438','任丘','14')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('439','涿州','14')
INSERT INTO Province(ProvinceID,Name)VALUES('15','河南')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('70','郑州','15')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('71','洛阳','15')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('214','开封','15')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('215','平顶山','15')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('216','焦作','15')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('217','鹤壁','15')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('218','新乡','15')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('219','安阳','15')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('220','濮阳','15')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('221','许昌','15')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('222','漯河','15')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('223','三门峡','15')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('224','南阳','15')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('225','商丘','15')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('226','信阳','15')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('227','周口','15')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('228','驻马店','15')

INSERT INTO Province(ProvinceID,Name)VALUES('16','山东')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('72','济南','16')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('73','青岛','16')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('74','烟台','16')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('229','淄博','16')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('230','枣庄','16')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('231','东营','16')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('232','潍坊','16')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('233','威海','16')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('234','济宁','16')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('235','泰安','16')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('236','日照','16')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('237','莱芜','16')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('238','德州','16')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('239','临沂','16')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('240','聊城','16')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('241','滨州','16')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('242','菏泽','16')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('474','高密','16')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('475','荷泽','16')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('476','淮坊','16')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('477','即墨','16')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('478','胶南','16')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('479','莱州','16')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('480','林沂','16')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('481','临忻','16')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('482','龙口','16')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('483','蓬莱','16')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('484','青州','16')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('485','乳山','16')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('486','寿光','16')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('487','滕州','16')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('488','文登','16')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('489','招远','16')
INSERT INTO Province(ProvinceID,Name)VALUES('17','山西')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('75','太原','17')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('76','大同','17')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('243','朔州','17')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('244','阳泉','17')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('245','长治','17')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('246','晋城','17')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('247','忻州','17')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('248','晋中','17')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('249','临汾','17')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('250','运城','17')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('251','吕梁地区','17')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('491','河津','17')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('492','侯马','17')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('494','孝义','17')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('495','榆次','17')
INSERT INTO Province(ProvinceID,Name)VALUES('18','湖北')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('77','武汉','18')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('252','黄石','18')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('253','襄樊','18')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('254','十堰','18')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('255','荆州','18')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('256','宜昌','18')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('257','荆门','18')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('258','鄂州','18')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('259','孝感','18')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('260','黄冈','18')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('261','咸宁','18')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('262','随州','18')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('263','恩施土家族苗族自治州','18')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('440','安陆','18')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('441','恩施','18')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('442','汉口','18')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('443','汉阳','18')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('444','潜江','18')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('445','仙桃','18')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('446','株州','18')
INSERT INTO Province(ProvinceID,Name)VALUES('19','湖南')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('78','长沙','19')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('264','株洲','19')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('265','湘潭','19')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('266','衡阳','19')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('267','邵阳','19')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('268','岳阳','19')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('269','常德','19')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('270','张家界','19')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('271','益阳','19')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('272','郴州','19')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('273','永州','19')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('274','怀化','19')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('275','娄底','19')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('276','湘西土家族苗族自治州','19')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('447','株州','19')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('448','邵东','19')
INSERT INTO Province(ProvinceID,Name)VALUES('20','安徽')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('79','合肥','20')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('80','芜湖','20')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('277','蚌埠','20')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('278','淮南','20')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('279','马鞍山','20')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('280','淮北','20')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('281','铜陵','20')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('282','安庆','20')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('283','黄山','20')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('284','滁州','20')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('285','阜阳','20')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('286','宿州','20')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('287','巢湖','20')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('288','六安','20')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('289','亳州','20')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('290','池州','20')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('291','宣城','20')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('412','蒙城','20')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('413','宁国','20')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('414','桐城','20')
INSERT INTO Province(ProvinceID,Name)VALUES('21','江苏')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('81','南京','21')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('292','徐州','21')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('293','连云港','21')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('294','淮安','21')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('295','宿迁','21')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('296','盐城','21')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('297','扬州','21')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('298','泰州','21')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('299','南通','21')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('300','镇江','21')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('301','常州','21')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('302','无锡','21')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('303','苏州','21')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('452','常熟','21')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('453','丹阳','21')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('454','海门','21')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('455','江都','21')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('456','江阴','21')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('457','靖江','21')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('458','昆山','21')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('459','溧阳','21')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('460','太仓','21')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('461','泰州华','21')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('462','吴江','21')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('463','吴县','21')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('464','宜兴','21')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('465','张家港','21')
INSERT INTO Province(ProvinceID,Name)VALUES('22',' 浙江')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('82','杭州','22')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('304','宁波','22')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('305','温州','22')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('306','嘉兴','22')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('307','湖州','22')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('308','绍兴','22')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('309','金华','22')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('310','衢州','22')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('311','舟山','22')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('312','台州','22')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('313','丽水','22')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('514','慈溪','22')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('515','东阳','22')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('516','奉化','22')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('517','乐清','22')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('518','临安','22')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('519','临海','22')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('520','平湖','22')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('521','瑞安','22')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('522','上虞','22')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('523','嵊州','22')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('524','温岭','22')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('525','义乌','22')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('526','永康','22')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('527','余姚','22')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('528','诸暨','22')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('529','新昌','22')
INSERT INTO Province(ProvinceID,Name)VALUES('23','江西')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('83','南昌','23')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('314','景德镇','23')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('315','萍乡','23')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('316','新余','23')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('317','九江','23')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('318','鹰潭','23')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('319','赣州','23')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('320','吉安','23')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('321','宜春','23')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('322','抚州','23')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('323','上饶','23')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('466','高安','23')
INSERT INTO Province(ProvinceID,Name)VALUES('24','广东')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('84','广州','24')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('85','深圳','24')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('324','珠海','24')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('325','汕头','24')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('326','韶关','24')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('327','河源','24')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('328','梅州','24')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('329','惠州','24')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('330','汕尾','24')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('331','东莞','24')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('332','中山','24')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('333','江门','24')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('334','佛山','24')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('335','阳江','24')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('336','湛江','24')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('337','茂名','24')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('338','肇庆','24')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('339','清远','24')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('340','潮州','24')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('341','揭阳','24')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('342','云浮','24')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('424','花都','24')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('425','开平','24')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('426','南海','24')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('427','顺德','24')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('428','台山','24')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('429','增城','24')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('431','市梅','24')
INSERT INTO Province(ProvinceID,Name)VALUES('25','广西')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('86','南宁','25')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('343','柳州','25')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('344','桂林','25')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('345','梧州','25')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('346','北海','25')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('347','防城港','25')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('348','钦州','25')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('349','贵港','25')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('350','玉林','25')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('351','百色','25')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('352','贺州','25')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('353','河池','25')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('354','来宾','25')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('355','崇左','25')
INSERT INTO Province(ProvinceID,Name)VALUES('26','福建')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('87','福州','26')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('88','厦门','26')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('356','三明','26')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('357','莆田','26')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('358','泉州','26')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('359','漳州','26')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('360','南平','26')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('361','龙岩','26')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('362','宁德','26')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('415','福清','26')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('416','建瓯','26')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('417','晋江','26')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('418','南安','26')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('419','邵武','26')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('420','石狮','26')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('421','仙游','26')
INSERT INTO Province(ProvinceID,Name)VALUES('27','四川')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('89','成都','27')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('363','自贡','27')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('364','攀枝花','27')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('365','泸州','27')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('366','德阳','27')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('367','绵阳','27')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('368','广元','27')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('369','遂宁','27')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('370','内江','27')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('371','乐山','27')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('372','南充','27')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('373','宜宾','27')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('374','广安','27')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('375','达州','27')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('376','巴中','27')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('377','雅安','27')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('378','眉山','27')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('379','资阳','27')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('380','阿坝藏族羌族自治州','27')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('381','甘孜藏族自治州','27')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('382','凉山彝族自治州','27')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('497','广汉','27')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('498','锦阳','27')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('499','西昌','27')
INSERT INTO Province(ProvinceID,Name)VALUES('28','云南')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('90','昆明','28')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('383','曲靖','28')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('384','玉溪','28')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('385','保山','28')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('386','昭通','28')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('387','思茅地区','28')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('388','临沧地区','28')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('389','丽江','28')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('390',' 文山壮族苗族自治州','28')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('391','红河哈尼族彝族自治州','28')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('392','西双版纳傣族自治州','28')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('393','楚雄彝族自治州','28')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('394','大理白族自治州','28')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('395','德宏傣族景颇族自治州','28')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('396','怒江傈傈族自治州','28')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('397','迪庆藏族自治州','28')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('513','大理','28')
INSERT INTO Province(ProvinceID,Name)VALUES('29','贵州')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('91','贵阳','29')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('398','六盘水','29')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('399','遵义','29')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('400','安顺','29')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('401','铜仁地区','29')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('402','毕节地区','29')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('403','黔西南布依族苗族自治州','29')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('404','黔东南苗族侗族自治州','29')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('405','黔南布依族苗族自治州','29')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('432','都匀','29')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('433','贵恙','29')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('434','凯里','29')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('435','铜仁','29')
INSERT INTO Province(ProvinceID,Name)VALUES('30','西藏')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('92','拉萨','30')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('406','那曲地区','30')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('407','昌都地区','30')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('408','山南地区','30')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('409','日喀则地区','30')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('410','阿里地区','30')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('411','林芝地区','30')
INSERT INTO Province(ProvinceID,Name)VALUES('31','海南')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('93','海口','31')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('94','三亚','31')
INSERT INTO Province(ProvinceID,Name)VALUES('32','香港')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('95','香港','32')
INSERT INTO Province(ProvinceID,Name)VALUES('33','澳门')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('96','澳门','33')
INSERT INTO Province(ProvinceID,Name)VALUES('34','台湾')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('97','台北','34')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('98','高雄','34')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('99','台中','34')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('100','台南','34')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('101','基隆','34')
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('102','新竹','34')