全国省市数据放送(直接实施SQL)

全国省市数据放送(直接执行SQL)

 
CREATE TABLE Province(ID INT Primary Key ,Name nvarchar(50))
CREATE TABLE City(ID INT Primary Key ,Name nvarchar(50))
INSERT INTO Province(ID,Name)VALUES('1','北京')
  INSERT INTO City(ID,Name)VALUES('1','东城区')
  INSERT INTO City(ID,Name)VALUES('2','西城区')
  INSERT INTO City(ID,Name)VALUES('3','宣武区')
  INSERT INTO City(ID,Name)VALUES('4','崇文区')
  INSERT INTO City(ID,Name)VALUES('5','朝阳区')
  INSERT INTO City(ID,Name)VALUES('6','海淀区')
  INSERT INTO City(ID,Name)VALUES('7','丰台区')
  INSERT INTO City(ID,Name)VALUES('8','石景山区')
  INSERT INTO City(ID,Name)VALUES('9','门头沟区')
  INSERT INTO City(ID,Name)VALUES('10','昌平区')
  INSERT INTO City(ID,Name)VALUES('11','大兴区')
  INSERT INTO City(ID,Name)VALUES('12','怀柔区')
  INSERT INTO City(ID,Name)VALUES('13','密云县')
  INSERT INTO City(ID,Name)VALUES('14','平谷区')
  INSERT INTO City(ID,Name)VALUES('15','顺义区')
  INSERT INTO City(ID,Name)VALUES('16','通州区')
  INSERT INTO City(ID,Name)VALUES('17','延庆县')
  INSERT INTO City(ID,Name)VALUES('103','房山区')
INSERT INTO Province(ID,Name)VALUES('2','上海')
  INSERT INTO City(ID,Name)VALUES('18','黄浦区')
  INSERT INTO City(ID,Name)VALUES('19','南市区')
  INSERT INTO City(ID,Name)VALUES('20','卢湾区')
  INSERT INTO City(ID,Name)VALUES('21','徐汇区')
  INSERT INTO City(ID,Name)VALUES('22','长宁区')
  INSERT INTO City(ID,Name)VALUES('23','静安区')
  INSERT INTO City(ID,Name)VALUES('24','普陀区')
  INSERT INTO City(ID,Name)VALUES('25','金山区')
  INSERT INTO City(ID,Name)VALUES('26','闸北区')
  INSERT INTO City(ID,Name)VALUES('27','虹口区')
  INSERT INTO City(ID,Name)VALUES('28','杨浦区')
  INSERT INTO City(ID,Name)VALUES('29','宝山区')
  INSERT INTO City(ID,Name)VALUES('30','闵行区')
  INSERT INTO City(ID,Name)VALUES('31','嘉定区')
  INSERT INTO City(ID,Name)VALUES('32','松江区')
  INSERT INTO City(ID,Name)VALUES('33','浦东新区')
  INSERT INTO City(ID,Name)VALUES('34','青浦县')
  INSERT INTO City(ID,Name)VALUES('35','奉贤县')
  INSERT INTO City(ID,Name)VALUES('36','南汇县')
  INSERT INTO City(ID,Name)VALUES('37','崇明县')
INSERT INTO Province(ID,Name)VALUES('3','天津')
  INSERT INTO City(ID,Name)VALUES('38','和平区')
  INSERT INTO City(ID,Name)VALUES('39','河东区')
  INSERT INTO City(ID,Name)VALUES('40','河西区')
  INSERT INTO City(ID,Name)VALUES('41','河北区')
  INSERT INTO City(ID,Name)VALUES('42','南开区')
  INSERT INTO City(ID,Name)VALUES('43','红桥区')
  INSERT INTO City(ID,Name)VALUES('44','塘沽区')
  INSERT INTO City(ID,Name)VALUES('45','汉沽区')
  INSERT INTO City(ID,Name)VALUES('105','大港区')
  INSERT INTO City(ID,Name)VALUES('106','东丽区')
  INSERT INTO City(ID,Name)VALUES('107','西青区')
  INSERT INTO City(ID,Name)VALUES('108','津南区')
  INSERT INTO City(ID,Name)VALUES('109','北辰区') 
 
  INSERT INTO City(ID,Name)VALUES('110',' 武清区')
  INSERT INTO City(ID,Name)VALUES('111','宝坻区')
  INSERT INTO City(ID,Name)VALUES('112','蓟 县')
  INSERT INTO City(ID,Name)VALUES('113','宁河县')
  INSERT INTO City(ID,Name)VALUES('114','静海县')
INSERT INTO Province(ID,Name)VALUES('4',' 重庆')
  INSERT INTO City(ID,Name)VALUES('46','永川市')
  INSERT INTO City(ID,Name)VALUES('47','黔江区')
  INSERT INTO City(ID,Name)VALUES('48','涪陵区')
  INSERT INTO City(ID,Name)VALUES('49','万洲区')
  INSERT INTO City(ID,Name)VALUES('115','渝中区')
  INSERT INTO City(ID,Name)VALUES('116','大渡口区')
  INSERT INTO City(ID,Name)VALUES('117','江北区')
  INSERT INTO City(ID,Name)VALUES('118','沙坪坝区')
  INSERT INTO City(ID,Name)VALUES('119','九龙坡区')
  INSERT INTO City(ID,Name)VALUES('120','南岸区')
  INSERT INTO City(ID,Name)VALUES('121','北碚区')
  INSERT INTO City(ID,Name)VALUES('122',' 万盛区')
  INSERT INTO City(ID,Name)VALUES('123','双桥区')
  INSERT INTO City(ID,Name)VALUES('124','渝北区')
  INSERT INTO City(ID,Name)VALUES('125','巴南区')
  INSERT INTO City(ID,Name)VALUES('126','长寿区')
INSERT INTO Province(ID,Name)VALUES('5',' 黑龙江')
  INSERT INTO City(ID,Name)VALUES('50','哈尔滨')
  INSERT INTO City(ID,Name)VALUES('51','齐齐哈尔')
  INSERT INTO City(ID,Name)VALUES('52','牡丹江')
  INSERT INTO City(ID,Name)VALUES('127','鹤岗')
  INSERT INTO City(ID,Name)VALUES('128','双鸭山')
  INSERT INTO City(ID,Name)VALUES('129','鸡西')
  INSERT INTO City(ID,Name)VALUES('130','大庆')
  INSERT INTO City(ID,Name)VALUES('131','伊春')
  INSERT INTO City(ID,Name)VALUES('132','佳木斯')
  INSERT INTO City(ID,Name)VALUES('133','七台河')
  INSERT INTO City(ID,Name)VALUES('134','黑河')
  INSERT INTO City(ID,Name)VALUES('135','绥化')
  INSERT INTO City(ID,Name)VALUES('136','大兴安岭地区')
INSERT INTO Province(ID,Name)VALUES('6','吉林')
  INSERT INTO City(ID,Name)VALUES('53','长春')
  INSERT INTO City(ID,Name)VALUES('54','吉林')
  INSERT INTO City(ID,Name)VALUES('137','四平')
  INSERT INTO City(ID,Name)VALUES('138','辽源')
  INSERT INTO City(ID,Name)VALUES('139','通化')
  INSERT INTO City(ID,Name)VALUES('140','白山')
  INSERT INTO City(ID,Name)VALUES('141','松原')
  INSERT INTO City(ID,Name)VALUES('142','白城')
  INSERT INTO City(ID,Name)VALUES('143','延边朝鲜族自治州')
  INSERT INTO City(ID,Name)VALUES('449','高新')
  INSERT INTO City(ID,Name)VALUES('450','延吉')
  INSERT INTO City(ID,Name)VALUES('451','梅河口')
INSERT INTO Province(ID,Name)VALUES('7','辽宁')
  INSERT INTO City(ID,Name)VALUES('55','沈阳')
  INSERT INTO City(ID,Name)VALUES('56','大连')
  INSERT INTO City(ID,Name)VALUES('57','锦州')
  INSERT INTO City(ID,Name)VALUES('144','鞍山')
  INSERT INTO City(ID,Name)VALUES('145','抚顺')
  INSERT INTO City(ID,Name)VALUES('146','本溪')
  INSERT INTO City(ID,Name)VALUES('147','丹东') 
 
  INSERT INTO City(ID,Name)VALUES('148','葫芦岛')
  INSERT INTO City(ID,Name)VALUES('149','营口')
  INSERT INTO City(ID,Name)VALUES('150','盘锦')
  INSERT INTO City(ID,Name)VALUES('151','阜新')
  INSERT INTO City(ID,Name)VALUES('152','辽阳')
  INSERT INTO City(ID,Name)VALUES('153','铁岭')
  INSERT INTO City(ID,Name)VALUES('154','朝阳')
  INSERT INTO City(ID,Name)VALUES('467','瓦房店')
INSERT INTO Province(ID,Name)VALUES('8','内蒙古')
  INSERT INTO City(ID,Name)VALUES('58','呼和浩特')
  INSERT INTO City(ID,Name)VALUES('59','包头')
  INSERT INTO City(ID,Name)VALUES('155','乌海')
  INSERT INTO City(ID,Name)VALUES('156','赤峰')
  INSERT INTO City(ID,Name)VALUES('157','通辽')
  INSERT INTO City(ID,Name)VALUES('158','鄂尔多斯')
  INSERT INTO City(ID,Name)VALUES('160','乌兰察布盟')
  INSERT INTO City(ID,Name)VALUES('161','锡林郭勒盟')
  INSERT INTO City(ID,Name)VALUES('162','巴彦淖尔盟')
  INSERT INTO City(ID,Name)VALUES('163','阿拉善盟')
  INSERT INTO City(ID,Name)VALUES('164','兴安盟')
  INSERT INTO City(ID,Name)VALUES('468','巴彦淖尔')
  INSERT INTO City(ID,Name)VALUES('469','呼伦贝尔')
  INSERT INTO City(ID,Name)VALUES('470','集宁')
  INSERT INTO City(ID,Name)VALUES('471',' 乌兰浩特')
  INSERT INTO City(ID,Name)VALUES('472','锡林浩特')
INSERT INTO Province(ID,Name)VALUES('9','宁夏')
  INSERT INTO City(ID,Name)VALUES('60','银川')
  INSERT INTO City(ID,Name)VALUES('165','石嘴山')
  INSERT INTO City(ID,Name)VALUES('166','吴忠')
  INSERT INTO City(ID,Name)VALUES('167','固原')

[解决办法]
 

INSERT INTO Province(ID,Name)VALUES('10','新疆')
  INSERT INTO City(ID,Name)VALUES('61','乌鲁木齐')
  INSERT INTO City(ID,Name)VALUES('168','克拉玛依')
  INSERT INTO City(ID,Name)VALUES('169','吐鲁番地区')
  INSERT INTO City(ID,Name)VALUES('170','哈密地区')
  INSERT INTO City(ID,Name)VALUES('171','和田地区')
  INSERT INTO City(ID,Name)VALUES('172','阿克苏地区')
  INSERT INTO City(ID,Name)VALUES('173','喀什地区')
  INSERT INTO City(ID,Name)VALUES('174','克孜勒苏柯尔克孜自治州')
  INSERT INTO City(ID,Name)VALUES('175','巴音郭楞蒙古自治州')
  INSERT INTO City(ID,Name)VALUES('176','昌吉回族自治州')
  INSERT INTO City(ID,Name)VALUES('177','博尔塔拉蒙古自治州')
  INSERT INTO City(ID,Name)VALUES('178','伊犁哈萨克自治州')
  INSERT INTO City(ID,Name)VALUES('500','阿克苏')
  INSERT INTO City(ID,Name)VALUES('501','昌吉')
  INSERT INTO City(ID,Name)VALUES('502','哈密')
  INSERT INTO City(ID,Name)VALUES('503','和田')
  INSERT INTO City(ID,Name)VALUES('504','喀什')
  INSERT INTO City(ID,Name)VALUES('505','克拉马依')
  INSERT INTO City(ID,Name)VALUES('506','库尔勒')
  INSERT INTO City(ID,Name)VALUES('507','石河子')
  INSERT INTO City(ID,Name)VALUES('508','吐鲁番')
  INSERT INTO City(ID,Name)VALUES('509',' 乌市')
  INSERT INTO City(ID,Name)VALUES('510','奎屯') 
 
  INSERT INTO City(ID,Name)VALUES('511','伊犁')
  INSERT INTO City(ID,Name)VALUES('512','伊宁')
INSERT INTO Province(ID,Name)VALUES('11','青海')
  INSERT INTO City(ID,Name)VALUES('62','西宁')
  INSERT INTO City(ID,Name)VALUES('179','海东地区')
  INSERT INTO City(ID,Name)VALUES('180',' 海北藏族自治州')
  INSERT INTO City(ID,Name)VALUES('181','黄南藏族自治州')
  INSERT INTO City(ID,Name)VALUES('182','海南藏族自治州')
  INSERT INTO City(ID,Name)VALUES('183','果洛藏族自治州')
  INSERT INTO City(ID,Name)VALUES('184','玉树藏族自治州')
  INSERT INTO City(ID,Name)VALUES('185','海西蒙古族藏族自治州')
  INSERT INTO City(ID,Name)VALUES('473','格尔木')
INSERT INTO Province(ID,Name)VALUES('12','甘肃')
  INSERT INTO City(ID,Name)VALUES('63','兰州')
  INSERT INTO City(ID,Name)VALUES('64','天水')
  INSERT INTO City(ID,Name)VALUES('186','金昌')
  INSERT INTO City(ID,Name)VALUES('187','白银')
  INSERT INTO City(ID,Name)VALUES('188','嘉峪关')
  INSERT INTO City(ID,Name)VALUES('189','武 威 ')
  INSERT INTO City(ID,Name)VALUES('190','张掖')
  INSERT INTO City(ID,Name)VALUES('191','平凉')
  INSERT INTO City(ID,Name)VALUES('192','酒泉')
  INSERT INTO City(ID,Name)VALUES('193','庆阳')
  INSERT INTO City(ID,Name)VALUES('194','定西地区')
  INSERT INTO City(ID,Name)VALUES('195','陇南地区')
  INSERT INTO City(ID,Name)VALUES('196','甘南藏族自治州')
  INSERT INTO City(ID,Name)VALUES('197','临夏回族自治州')
  INSERT INTO City(ID,Name)VALUES('422','嘉峪')
  INSERT INTO City(ID,Name)VALUES('423','武威')
INSERT INTO Province(ID,Name)VALUES('13','陕西')
  INSERT INTO City(ID,Name)VALUES('65','西安')
  INSERT INTO City(ID,Name)VALUES('66','宝鸡')
  INSERT INTO City(ID,Name)VALUES('67','延安')
  INSERT INTO City(ID,Name)VALUES('198','铜川')
  INSERT INTO City(ID,Name)VALUES('199','咸阳')
  INSERT INTO City(ID,Name)VALUES('200','渭南')
  INSERT INTO City(ID,Name)VALUES('201','汉中')
  INSERT INTO City(ID,Name)VALUES('202','榆林')
  INSERT INTO City(ID,Name)VALUES('203','安康')
  INSERT INTO City(ID,Name)VALUES('204','商洛')
  INSERT INTO City(ID,Name)VALUES('496','韩城')
INSERT INTO Province(ID,Name)VALUES('14','河北')
  INSERT INTO City(ID,Name)VALUES('68','石家庄')
  INSERT INTO City(ID,Name)VALUES('69','保定')
  INSERT INTO City(ID,Name)VALUES('205','唐山')
  INSERT INTO City(ID,Name)VALUES('206','秦皇岛')
  INSERT INTO City(ID,Name)VALUES('207','邯郸')
  INSERT INTO City(ID,Name)VALUES('208','邢台')
  INSERT INTO City(ID,Name)VALUES('209','张家口')
  INSERT INTO City(ID,Name)VALUES('210','承德')
  INSERT INTO City(ID,Name)VALUES('211','沧州')
  INSERT INTO City(ID,Name)VALUES('212','廊坊')
  INSERT INTO City(ID,Name)VALUES('213','衡水')
  INSERT INTO City(ID,Name)VALUES('436','霸州')
  INSERT INTO City(ID,Name)VALUES('437','青县')
  INSERT INTO City(ID,Name)VALUES('438','任丘')
  INSERT INTO City(ID,Name)VALUES('439','涿州') 
 
INSERT INTO Province(ID,Name)VALUES('15','河南')
  INSERT INTO City(ID,Name)VALUES('70','郑州')
  INSERT INTO City(ID,Name)VALUES('71','洛阳')
  INSERT INTO City(ID,Name)VALUES('214','开封')
  INSERT INTO City(ID,Name)VALUES('215','平顶山')
  INSERT INTO City(ID,Name)VALUES('216','焦作')
  INSERT INTO City(ID,Name)VALUES('217','鹤壁')
  INSERT INTO City(ID,Name)VALUES('218','新乡')
  INSERT INTO City(ID,Name)VALUES('219','安阳')
  INSERT INTO City(ID,Name)VALUES('220','濮阳')
  INSERT INTO City(ID,Name)VALUES('221','许昌')
  INSERT INTO City(ID,Name)VALUES('222','漯河')
  INSERT INTO City(ID,Name)VALUES('223','三门峡')
  INSERT INTO City(ID,Name)VALUES('224','南阳')
  INSERT INTO City(ID,Name)VALUES('225','商丘')
  INSERT INTO City(ID,Name)VALUES('226','信阳')
  INSERT INTO City(ID,Name)VALUES('227','周口')
  INSERT INTO City(ID,Name)VALUES('228','驻马店')
INSERT INTO Province(ID,Name)VALUES('16','山东')
  INSERT INTO City(ID,Name)VALUES('72','济南')
  INSERT INTO City(ID,Name)VALUES('73','青岛')
  INSERT INTO City(ID,Name)VALUES('74','烟台')
  INSERT INTO City(ID,Name)VALUES('229','淄博')
  INSERT INTO City(ID,Name)VALUES('230','枣庄')
  INSERT INTO City(ID,Name)VALUES('231','东营')
  INSERT INTO City(ID,Name)VALUES('232','潍坊')
  INSERT INTO City(ID,Name)VALUES('233','威海')
  INSERT INTO City(ID,Name)VALUES('234','济宁')
  INSERT INTO City(ID,Name)VALUES('235','泰安')
  INSERT INTO City(ID,Name)VALUES('236','日照')
  INSERT INTO City(ID,Name)VALUES('237','莱芜')
  INSERT INTO City(ID,Name)VALUES('238','德州')
  INSERT INTO City(ID,Name)VALUES('239','临沂')
  INSERT INTO City(ID,Name)VALUES('240','聊城')
  INSERT INTO City(ID,Name)VALUES('241','滨州')
  INSERT INTO City(ID,Name)VALUES('242','菏泽')
  INSERT INTO City(ID,Name)VALUES('474','高密')
  INSERT INTO City(ID,Name)VALUES('475','荷泽')
  INSERT INTO City(ID,Name)VALUES('476','淮坊')
  INSERT INTO City(ID,Name)VALUES('477','即墨')
  INSERT INTO City(ID,Name)VALUES('478','胶南')
  INSERT INTO City(ID,Name)VALUES('479','莱州')
  INSERT INTO City(ID,Name)VALUES('480','林沂')
  INSERT INTO City(ID,Name)VALUES('481','临忻')
  INSERT INTO City(ID,Name)VALUES('482','龙口')
  INSERT INTO City(ID,Name)VALUES('483','蓬莱')
  INSERT INTO City(ID,Name)VALUES('484','青州')
  INSERT INTO City(ID,Name)VALUES('485','乳山')
  INSERT INTO City(ID,Name)VALUES('486','寿光')
  INSERT INTO City(ID,Name)VALUES('487','滕州')
  INSERT INTO City(ID,Name)VALUES('488','文登')
  INSERT INTO City(ID,Name)VALUES('489','招远')
INSERT INTO Province(ID,Name)VALUES('17','山西')
  INSERT INTO City(ID,Name)VALUES('75','太原')
  INSERT INTO City(ID,Name)VALUES('76','大同')
  INSERT INTO City(ID,Name)VALUES('243','朔州')
  INSERT INTO City(ID,Name)VALUES('244','阳泉')
  INSERT INTO City(ID,Name)VALUES('245','长治') 
 
  INSERT INTO City(ID,Name)VALUES('246','晋城')
  INSERT INTO City(ID,Name)VALUES('247','忻州')
  INSERT INTO City(ID,Name)VALUES('248','晋中')
  INSERT INTO City(ID,Name)VALUES('249','临汾')
  INSERT INTO City(ID,Name)VALUES('250','运城')
  INSERT INTO City(ID,Name)VALUES('251','吕梁地区')
  INSERT INTO City(ID,Name)VALUES('491','河津')
  INSERT INTO City(ID,Name)VALUES('492','侯马')
  INSERT INTO City(ID,Name)VALUES('494','孝义')
  INSERT INTO City(ID,Name)VALUES('495','榆次')

[解决办法]

[解决办法]
建议楼主把数据库打包发到CSDN下载。这个不全吧？
[解决办法]

[解决办法]
没有主外键关联？怎么使用啊
我怎么知道海淀区是北京的呢

还有为什么北京的房山区为什么没有按顺序排呢
[解决办法]
强大..
[解决办法]

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')

[解决办法]
3Q.
[解决办法]
3ku，收下
[解决办法]
ok rec
[解决办法]
dt!~
[解决办法]
收藏一下。
[解决办法]
顶。。。。。。。。。。。。。。。。。。。。。。。。
[解决办法]
MARK
[解决办法]
好强～～～
[解决办法]
这个好东西,上次我找了半天就没有找到,后来弄到个excel自己转了半天 谢谢楼主
[解决办法]
技术贴 
[解决办法]
好东西，谢谢LZ分享！给加点分鼓励一下。
[解决办法]
麻花，花麻
[解决办法]

楼主太辛苦了....
[解决办法]
強。。。。。。。。。。
[解决办法]
mark 
[解决办法]
这个区划编码不是标准的吧
[解决办法]
呵呵，收藏。。。
[解决办法]
这是中国的吧，谁有地球的，发一下。
[解决办法]

[解决办法]
这什么精神啊！

顶！
[解决办法]
mark.
[解决办法]
赞一个！
[解决办法]
非常好的数据

[解决办法]
非常好，留着以后用呢。
[解决办法]
非常好的数据

[解决办法]
收下了....！
[解决办法]
楼主得瑟 哇哈哈 顶起
[解决办法]
很不错，进来谢谢楼主啦
[解决办法]
感谢LZ
[解决办法]
顶。。。
[解决办法]
楼主 很辛苦！！
------解决方案--------------------

好长啊
[解决办法]
整体看起来挺美的
[解决办法]
额。。没我的市
[解决办法]
下载学习，谢谢下载学习，谢谢下载学习，谢谢下载学习，谢谢


[解决办法]
perfect
[解决办法]
dddddddddd
[解决办法]
呵呵~辛苦了!
[解决办法]
辛苦，鼓励一下
[解决办法]
强大啊！！！！！！！！！！！！
[解决办法]
不错！这个数据可以从国家地理信息中心提取下
[解决办法]
dddddddd
[解决办法]
这个得顶
[解决办法]
学习，支持，收藏
[解决办法]
全不全？先收藏了，楼主辛苦了
[解决办法]
up and mark
[解决办法]
up and mark
[解决办法]
楼主还是提供表的结构和
excel数据


好点，这样太多了
[解决办法]
很不错，进来谢谢楼主啦
[解决办法]
听说每天回帖可得10分啊
[解决办法]
辛苦了，记下 ，以留后用
[解决办法]
好强～～～
[解决办法]
不得不佩服楼主的耐心啊
[解决办法]
...

查看更多 下一篇