在数据库中创建省与市的表格
来源:互联网 发布:阿里云华东1 编辑:程序博客网 时间:2024/04/30 21:12
CREATE TABLE Province(ProvinceID INT Primary Key ,Name varchar(50)); CREATE TABLE City(CityID INT Primary Key ,ProvinceID INT ,Name varchar(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');
阅读全文
0 0
- 在数据库中创建省与市的表格
- 数据库表格的创建与修改
- Mysql --数据库、表格的创建与修改
- 在JavaScript中创建表格
- Java下创建表格与数据库交互的几个要点
- 关于数据库的表格创建
- 数据库中数据库与表的创建
- 表格的创建与修改
- oracle 创建数据库 在新创建的数据库中创建用户 删除创建数据库 链接orcl
- 在NHibernate中创建数据库的源代码
- 在myeclipse中创建新的数据库
- 在ASP.Net中创建动态表格
- 在ASP.Net中创建动态表格
- 在js中动态创建表格
- 在数据库服务端,添加一个表格,然后在MFC中对数据库表格的数据做插入、删除和修改
- 数据库中触发器的创建与注意事项
- hive中数据库的创建与删除
- 数据库SQL语句编写-表格的创建
- 用当型和直到型循环实现1到100的和
- 洛谷P1126-机器人搬重物-BFS/SPFA
- Mysql之存储引擎
- 调试中的一些错误---持续更新
- 2.uC/OS III 内核, 关于临界段
- 在数据库中创建省与市的表格
- FatMouse and Cheese HDU
- AHB总线协议整理
- Android下的Service的基本用法
- javascript深入理解js闭包
- CMake和RPATH
- BZOJ 2938: [Poi2000]病毒 AC自动机
- angularjs和angular4的区别。为什么使用angular4
- minetest源码解析二:GUIEngine初始化、菜单刷新流程以及核心函数介绍