全国省市区县数据库-市(全)
接上一篇,上一篇
********创建市级表********/ INSERT T_City(CityName,ProID,CitySort) Values('菏泽市','15','124') INSERT T_City(CityName,ProID,CitySort) Values('济南市','15','125') INSERT T_City(CityName,ProID,CitySort) Values('青岛市','15','126') INSERT T_City(CityName,ProID,CitySort) Values('淄博市','15','127') INSERT T_City(CityName,ProID,CitySort) Values('德州市','15','128') INSERT T_City(CityName,ProID,CitySort) Values('烟台市','15','129') INSERT T_City(CityName,ProID,CitySort) Values('潍坊市','15','130') INSERT T_City(CityName,ProID,CitySort) Values('济宁市','15','131') INSERT T_City(CityName,ProID,CitySort) Values('泰安市','15','132') INSERT T_City(CityName,ProID,CitySort) Values('临沂市','15','133') INSERT T_City(CityName,ProID,CitySort) Values('滨州市','15','134') INSERT T_City(CityName,ProID,CitySort) Values('东营市','15','135') INSERT T_City(CityName,ProID,CitySort) Values('威海市','15','136') INSERT T_City(CityName,ProID,CitySort) Values('枣庄市','15','137') INSERT T_City(CityName,ProID,CitySort) Values('日照市','15','138') INSERT T_City(CityName,ProID,CitySort) Values('莱芜市','15','139') INSERT T_City(CityName,ProID,CitySort) Values('聊城市','15','140') INSERT T_City(CityName,ProID,CitySort) Values('商丘市','16','141') INSERT T_City(CityName,ProID,CitySort) Values('郑州市','16','142') INSERT T_City(CityName,ProID,CitySort) Values('安阳市','16','143') INSERT T_City(CityName,ProID,CitySort) Values('新乡市','16','144') INSERT T_City(CityName,ProID,CitySort) Values('许昌市','16','145') INSERT T_City(CityName,ProID,CitySort) Values('平顶山市','16','146') INSERT T_City(CityName,ProID,CitySort) Values('信阳市','16','147') INSERT T_City(CityName,ProID,CitySort) Values('南阳市','16','148') INSERT T_City(CityName,ProID,CitySort) Values('开封市','16','149') INSERT T_City(CityName,ProID,CitySort) Values('洛阳市','16','150') INSERT T_City(CityName,ProID,CitySort) Values('济源市','16','151') INSERT T_City(CityName,ProID,CitySort) Values('焦作市','16','152') INSERT T_City(CityName,ProID,CitySort) Values('鹤壁市','16','153') INSERT T_City(CityName,ProID,CitySort) Values('濮阳市','16','154') INSERT T_City(CityName,ProID,CitySort) Values('周口市','16','155') INSERT T_City(CityName,ProID,CitySort) Values('漯河市','16','156') INSERT T_City(CityName,ProID,CitySort) Values('驻马店市','16','157') INSERT T_City(CityName,ProID,CitySort) Values('三门峡市','16','158') INSERT T_City(CityName,ProID,CitySort) Values('武汉市','17','159') INSERT T_City(CityName,ProID,CitySort) Values('襄樊市','17','160') INSERT T_City(CityName,ProID,CitySort) Values('鄂州市','17','161') INSERT T_City(CityName,ProID,CitySort) Values('孝感市','17','162') INSERT T_City(CityName,ProID,CitySort) Values('黄冈市','17','163') INSERT T_City(CityName,ProID,CitySort) Values('黄石市','17','164') INSERT T_City(CityName,ProID,CitySort) Values('咸宁市','17','165') INSERT T_City(CityName,ProID,CitySort) Values('荆州市','17','166') INSERT T_City(CityName,ProID,CitySort) Values('宜昌市','17','167') INSERT T_City(CityName,ProID,CitySort) Values('恩施土家族苗族自治州','17','168') INSERT T_City(CityName,ProID,CitySort) Values('神农架林区','17','169') INSERT T_City(CityName,ProID,CitySort) Values('十堰市','17','170') INSERT T_City(CityName,ProID,CitySort) Values('随州市','17','171') INSERT T_City(CityName,ProID,CitySort) Values('荆门市','17','172') INSERT T_City(CityName,ProID,CitySort) Values('仙桃市','17','173') INSERT T_City(CityName,ProID,CitySort) Values('天门市','17','174') INSERT T_City(CityName,ProID,CitySort) Values('潜江市','17','175') INSERT T_City(CityName,ProID,CitySort) Values('岳阳市','18','176') INSERT T_City(CityName,ProID,CitySort) Values('长沙市','18','177') INSERT T_City(CityName,ProID,CitySort) Values('湘潭市','18','178') INSERT T_City(CityName,ProID,CitySort) Values('株洲市','18','179') INSERT T_City(CityName,ProID,CitySort) Values('衡阳市','18','180') INSERT T_City(CityName,ProID,CitySort) Values('郴州市','18','181') INSERT T_City(CityName,ProID,CitySort) Values('常德市','18','182') INSERT T_City(CityName,ProID,CitySort) Values('益阳市','18','183') INSERT T_City(CityName,ProID,CitySort) Values('娄底市','18','184') INSERT T_City(CityName,ProID,CitySort) Values('邵阳市','18','185') INSERT T_City(CityName,ProID,CitySort) Values('湘西土家族苗族自治州','18','186') INSERT T_City(CityName,ProID,CitySort) Values('张家界市','18','187') INSERT T_City(CityName,ProID,CitySort) Values('怀化市','18','188') INSERT T_City(CityName,ProID,CitySort) Values('永州市','18','189') INSERT T_City(CityName,ProID,CitySort) Values('广州市','19','190') INSERT T_City(CityName,ProID,CitySort) Values('汕尾市','19','191') INSERT T_City(CityName,ProID,CitySort) Values('阳江市','19','192') INSERT T_City(CityName,ProID,CitySort) Values('揭阳市','19','193') INSERT T_City(CityName,ProID,CitySort) Values('茂名市','19','194') INSERT T_City(CityName,ProID,CitySort) Values('惠州市','19','195') INSERT T_City(CityName,ProID,CitySort) Values('江门市','19','196') INSERT T_City(CityName,ProID,CitySort) Values('韶关市','19','197') INSERT T_City(CityName,ProID,CitySort) Values('梅州市','19','198') INSERT T_City(CityName,ProID,CitySort) Values('汕头市','19','199') INSERT T_City(CityName,ProID,CitySort) Values('深圳市','19','200') INSERT T_City(CityName,ProID,CitySort) Values('珠海市','19','201') INSERT T_City(CityName,ProID,CitySort) Values('佛山市','19','202') INSERT T_City(CityName,ProID,CitySort) Values('肇庆市','19','203') INSERT T_City(CityName,ProID,CitySort) Values('湛江市','19','204') INSERT T_City(CityName,ProID,CitySort) Values('中山市','19','205') INSERT T_City(CityName,ProID,CitySort) Values('河源市','19','206') INSERT T_City(CityName,ProID,CitySort) Values('清远市','19','207') INSERT T_City(CityName,ProID,CitySort) Values('云浮市','19','208') INSERT T_City(CityName,ProID,CitySort) Values('潮州市','19','209') INSERT T_City(CityName,ProID,CitySort) Values('东莞市','19','210') INSERT T_City(CityName,ProID,CitySort) Values('兰州市','22','211') INSERT T_City(CityName,ProID,CitySort) Values('金昌市','22','212') INSERT T_City(CityName,ProID,CitySort) Values('白银市','22','213') INSERT T_City(CityName,ProID,CitySort) Values('天水市','22','214') INSERT T_City(CityName,ProID,CitySort) Values('嘉峪关市','22','215') INSERT T_City(CityName,ProID,CitySort) Values('武威市','22','216') INSERT T_City(CityName,ProID,CitySort) Values('张掖市','22','217') INSERT T_City(CityName,ProID,CitySort) Values('平凉市','22','218') INSERT T_City(CityName,ProID,CitySort) Values('酒泉市','22','219') INSERT T_City(CityName,ProID,CitySort) Values('庆阳市','22','220') INSERT T_City(CityName,ProID,CitySort) Values('定西市','22','221') INSERT T_City(CityName,ProID,CitySort) Values('陇南市','22','222') INSERT T_City(CityName,ProID,CitySort) Values('临夏回族自治州','22','223') INSERT T_City(CityName,ProID,CitySort) Values('甘南藏族自治州','22','224') INSERT T_City(CityName,ProID,CitySort) Values('成都市','28','225') INSERT T_City(CityName,ProID,CitySort) Values('攀枝花市','28','226') INSERT T_City(CityName,ProID,CitySort) Values('自贡市','28','227') INSERT T_City(CityName,ProID,CitySort) Values('绵阳市','28','228') INSERT T_City(CityName,ProID,CitySort) Values('南充市','28','229') INSERT T_City(CityName,ProID,CitySort) Values('达州市','28','230') INSERT T_City(CityName,ProID,CitySort) Values('遂宁市','28','231') INSERT T_City(CityName,ProID,CitySort) Values('广安市','28','232') INSERT T_City(CityName,ProID,CitySort) Values('巴中市','28','233') INSERT T_City(CityName,ProID,CitySort) Values('泸州市','28','234') INSERT T_City(CityName,ProID,CitySort) Values('宜宾市','28','235') INSERT T_City(CityName,ProID,CitySort) Values('资阳市','28','236') INSERT T_City(CityName,ProID,CitySort) Values('内江市','28','237') INSERT T_City(CityName,ProID,CitySort) Values('乐山市','28','238') INSERT T_City(CityName,ProID,CitySort) Values('眉山市','28','239') INSERT T_City(CityName,ProID,CitySort) Values('凉山彝族自治州','28','240') INSERT T_City(CityName,ProID,CitySort) Values('雅安市','28','241') INSERT T_City(CityName,ProID,CitySort) Values('甘孜藏族自治州','28','242') INSERT T_City(CityName,ProID,CitySort) Values('阿坝藏族羌族自治州','28','243') INSERT T_City(CityName,ProID,CitySort) Values('德阳市','28','244') INSERT T_City(CityName,ProID,CitySort) Values('广元市','28','245')