全国省市mysql 全国省市县列表完整版

因为工作项目需求,需要一个城市县区数据表
 
 
 sql 数据方面导入操作
 
 
 
 
 
  /**********创建省级表**********/
 CREATE TABLE T_Province
 (
ProID INT IDENTITY(1,1) PRIMARY KEY,  --省份主键
ProName NVARCHAR(50) NOT NULL,      --省份名称
ProSort INT,       --省份排序
ProRemark NVARCHAR(50)     --说明  
 )
 Go
 insert T_Province(ProName,ProSort,ProRemark) Values('北京市','1','直辖市')
 insert T_Province(ProName,ProSort,ProRemark) Values('天津市','2','直辖市')
 insert T_Province(ProName,ProSort,ProRemark) Values('河北省','5','省份')
 insert T_Province(ProName,ProSort,ProRemark) Values('山西省','6','省份')
 insert T_Province(ProName,ProSort,ProRemark) Values('内蒙古自治区','32','自治区')
 insert T_Province(ProName,ProSort,ProRemark) Values('辽宁省','8','省份')
 insert T_Province(ProName,ProSort,ProRemark) Values('吉林省','9','省份')
 insert T_Province(ProName,ProSort,ProRemark) Values('黑龙江省','10','省份')
 insert T_Province(ProName,ProSort,ProRemark) Values('上海市','3','直辖市')
 insert T_Province(ProName,ProSort,ProRemark) Values('江苏省','11','省份')
 insert T_Province(ProName,ProSort,ProRemark) Values('浙江省','12','省份')
 insert T_Province(ProName,ProSort,ProRemark) Values('安徽省','13','省份')
 insert T_Province(ProName,ProSort,ProRemark) Values('福建省','14','省份')
 insert T_Province(ProName,ProSort,ProRemark) Values('江西省','15','省份')
 insert T_Province(ProName,ProSort,ProRemark) Values('山东省','16','省份')
 insert T_Province(ProName,ProSort,ProRemark) Values('河南省','17','省份')
 insert T_Province(ProName,ProSort,ProRemark) Values('湖北省','18','省份')
 insert T_Province(ProName,ProSort,ProRemark) Values('湖南省','19','省份')
 insert T_Province(ProName,ProSort,ProRemark) Values('广东省','20','省份')
 insert T_Province(ProName,ProSort,ProRemark) Values('海南省','24','省份')
 insert T_Province(ProName,ProSort,ProRemark) Values('广西壮族自治区','28','自治区')
 insert T_Province(ProName,ProSort,ProRemark) Values('甘肃省','21','省份')
 insert T_Province(ProName,ProSort,ProRemark) Values('陕西省','27','省份')
 insert T_Province(ProName,ProSort,ProRemark) Values('新 疆维吾尔自治区','31','自治区')
 insert T_Province(ProName,ProSort,ProRemark) Values('青海省','26','省份')
 insert T_Province(ProName,ProSort,ProRemark) Values('宁夏回族自治区','30','自治区')
 insert T_Province(ProName,ProSort,ProRemark) Values('重庆市','4','直辖市')
 insert T_Province(ProName,ProSort,ProRemark) Values('四川省','22','省份')
 insert T_Province(ProName,ProSort,ProRemark) Values('贵州省','23','省份')
 insert T_Province(ProName,ProSort,ProRemark) Values('云南省','25','省份')
 insert T_Province(ProName,ProSort,ProRemark) Values('西藏自治区','29','自治区')
 insert T_Province(ProName,ProSort,ProRemark) Values('台湾省','7','省份')
 insert T_Province(ProName,ProSort,ProRemark) Values('澳门特别行政区','33','特别行政区')
 insert T_Province(ProName,ProSort,ProRemark) Values('香港特别行政区','34','特别行政区')


 /********创建市级表********/
 CREATE TABLE T_City
 (
CityID INT IDENTITY(1,1) Primary KEY ,         --城市主键
CityName NVARCHAR(50)  NOT NULL,--城市名称
ProID INT,  --所属省份
CitySort INT    --城市排序
 )
 INSERT T_City(CityName,ProID,CitySort) Values('北京市','1','1')
 INSERT T_City(CityName,ProID,CitySort) Values('天津市','2','2')
 INSERT T_City(CityName,ProID,CitySort) Values('上海市','9','3')
 INSERT T_City(CityName,ProID,CitySort) Values('重庆市','27','4')
 INSERT T_City(CityName,ProID,CitySort) Values('邯郸市','3','5')
 INSERT T_City(CityName,ProID,CitySort) Values('石家庄市','3','6')
 INSERT T_City(CityName,ProID,CitySort) Values('保定市','3','7')
 INSERT T_City(CityName,ProID,CitySort) Values('张家口市','3','8')
 INSERT T_City(CityName,ProID,CitySort) Values('承德市','3','9')
 INSERT T_City(CityName,ProID,CitySort) Values('唐山市','3','10')
 INSERT T_City(CityName,ProID,CitySort) Values('廊坊市','3','11')
 INSERT T_City(CityName,ProID,CitySort) Values('沧州市','3','12')
 INSERT T_City(CityName,ProID,CitySort) Values('衡水市','3','13')
 INSERT T_City(CityName,ProID,CitySort) Values('邢台市','3','14')
 INSERT T_City(CityName,ProID,CitySort) Values('秦皇<script type="text/javascript"><!--mce:0--></script><script type="text/javascript"><!--mce:1--></script><script type="text/javascript"><!--mce:2--></script><script type="text/javascript"><!--mce:3--></script><script type="text/javascript"><!--mce:4--></script>岛市','3','15')
 INSERT T_City(CityName,ProID,CitySort) Values('朔州市','4','16')
 INSERT T_City(CityName,ProID,CitySort) Values('忻州市','4','17')
 INSERT T_City(CityName,ProID,CitySort) Values('太原市','4','18')
 INSERT T_City(CityName,ProID,CitySort) Values('大同市','4','19')
 INSERT T_City(CityName,ProID,CitySort) Values('阳泉市','4','20')
 INSERT T_City(CityName,ProID,CitySort) Values('晋中市','4','21')
 INSERT T_City(CityName,ProID,CitySort) Values('长治市','4','22')
 INSERT T_City(CityName,ProID,CitySort) Values('晋城市','4','23')
 INSERT T_City(CityName,ProID,CitySort) Values('临汾市','4','24')
 INSERT T_City(CityName,ProID,CitySort) Values('吕梁市','4','25')
 INSERT T_City(CityName,ProID,CitySort) Values('运城市','4','26')
 INSERT T_City(CityName,ProID,CitySort) Values('沈阳市','6','27')
 INSERT T_City(CityName,ProID,CitySort) Values('铁岭市','6','28')
 INSERT T_City(CityName,ProID,CitySort) Values('大连市','6','29')
 INSERT T_City(CityName,ProID,CitySort) Values('鞍山市','6','30')
 INSERT T_City(CityName,ProID,CitySort) Values('抚顺市','6','31')
 INSERT T_City(CityName,ProID,CitySort) Values('本溪市','6','32')
 INSERT T_City(CityName,ProID,CitySort) Values('丹东市','6','33')
 INSERT T_City(CityName,ProID,CitySort) Values('锦州市','6','34')
 INSERT T_City(CityName,ProID,CitySort) Values('营口市','6','35')
 INSERT T_City(CityName,ProID,CitySort) Values('阜新市','6','36')
 INSERT T_City(CityName,ProID,CitySort) Values('辽阳市','6','37')
 INSERT T_City(CityName,ProID,CitySort) Values('朝阳市','6','38')
 INSERT T_City(CityName,ProID,CitySort) Values('盘锦市','6','39')
 INSERT T_City(CityName,ProID,CitySort) Values('葫芦岛市','6','40')
 INSERT T_City(CityName,ProID,CitySort) Values('长春市','7','41')
 INSERT T_City(CityName,ProID,CitySort) Values('吉林市','7','42')
 INSERT T_City(CityName,ProID,CitySort) Values('延边朝鲜族自治州','7','43')
 INSERT T_City(CityName,ProID,CitySort) Values('四平市','7','44')
 INSERT T_City(CityName,ProID,CitySort) Values('通化市','7','45')
 INSERT T_City(CityName,ProID,CitySort) Values('白城市','7','46')
 INSERT T_City(CityName,ProID,CitySort) Values('辽源市','7','47')
 INSERT T_City(CityName,ProID,CitySort) Values('松原市','7','48')
 INSERT T_City(CityName,ProID,CitySort) Values('白山市','7','49')
 INSERT T_City(CityName,ProID,CitySort) Values('哈尔滨市','8','50')
 INSERT T_City(CityName,ProID,CitySort) Values('齐齐哈尔市','8','51')
 INSERT T_City(CityName,ProID,CitySort) Values('鸡西市','8','52')
 INSERT T_City(CityName,ProID,CitySort) Values('牡丹江市','8','53')
 INSERT T_City(CityName,ProID,CitySort) Values('七台河市','8','54')
 INSERT T_City(CityName,ProID,CitySort) Values('佳木斯市','8','55')
 INSERT T_City(CityName,ProID,CitySort) Values('鹤岗市','8','56')
 INSERT T_City(CityName,ProID,CitySort) Values('双鸭山市','8','57')
 INSERT T_City(CityName,ProID,CitySort) Values('绥化市','8','58')
 INSERT T_City(CityName,ProID,CitySort) Values('黑河市','8','59')
 INSERT T_City(CityName,ProID,CitySort) Values('大兴安岭地区','8','60')
 INSERT T_City(CityName,ProID,CitySort) Values('伊春市','8','61')
 INSERT T_City(CityName,ProID,CitySort) Values('大庆市','8','62')
 INSERT T_City(CityName,ProID,CitySort) Values('南京市','10','63')
 INSERT T_City(CityName,ProID,CitySort) Values('无锡市','10','64')
 INSERT T_City(CityName,ProID,CitySort) Values('镇江市','10','65')
 INSERT T_City(CityName,ProID,CitySort) Values('苏州市','10','66')
 INSERT T_City(CityName,ProID,CitySort) Values('南通市','10','67')
 INSERT T_City(CityName,ProID,CitySort) Values('扬州市','10','68')
 INSERT T_City(CityName,ProID,CitySort) Values('盐城市','10','69')
 INSERT T_City(CityName,ProID,CitySort) Values('徐州市','10','70')
 INSERT T_City(CityName,ProID,CitySort) Values('淮安市','10','71')
 INSERT T_City(CityName,ProID,CitySort) Values('连云港市','10','72')
 INSERT T_City(CityName,ProID,CitySort) Values('常州市','10','73')
 INSERT T_City(CityName,ProID,CitySort) Values('泰州市','10','74')
 INSERT T_City(CityName,ProID,CitySort) Values('宿迁市','10','75')
 INSERT T_City(CityName,ProID,CitySort) Values('舟山市','11','76')
 INSERT T_City(CityName,ProID,CitySort) Values('衢州市','11','77')
 INSERT T_City(CityName,ProID,CitySort) Values('杭州市','11','78')
 INSERT T_City(CityName,ProID,CitySort) Values('湖州市','11','79')
 INSERT T_City(CityName,ProID,CitySort) Values('嘉兴市','11','80')
 INSERT T_City(CityName,ProID,CitySort) Values('宁波市','11','81')
 INSERT T_City(CityName,ProID,CitySort) Values('绍兴市','11','82')
 INSERT T_City(CityName,ProID,CitySort) Values('温州市','11','83')
 INSERT T_City(CityName,ProID,CitySort) Values('丽水市','11','84')
 INSERT T_City(CityName,ProID,CitySort) Values('金华市','11','85')
 INSERT T_City(CityName,ProID,CitySort) Values('台州市','11','86')
 INSERT T_City(CityName,ProID,CitySort) Values('合肥市','12','87')
 INSERT T_City(CityName,ProID,CitySort) Values('芜湖市','12','88')
 INSERT T_City(CityName,ProID,CitySort) Values('蚌埠市','12','89')
 INSERT T_City(CityName,ProID,CitySort) Values('淮南市','12','90')
 INSERT T_City(CityName,ProID,CitySort) Values('马鞍山市','12','91')
 INSERT T_City(CityName,ProID,CitySort) Values('淮北市','12','92')
 INSERT T_City(CityName,ProID,CitySort) Values('铜陵市','12','93')
 INSERT T_City(CityName,ProID,CitySort) Values('安庆市','12','94')
 INSERT T_City(CityName,ProID,CitySort) Values('黄山市','12','95')
 INSERT T_City(CityName,ProID,CitySort) Values('滁州市','12','96')
 INSERT T_City(CityName,ProID,CitySort) Values('阜阳市','12','97')
 INSERT T_City(CityName,ProID,CitySort) Values('宿州市','12','98')
 INSERT T_City(CityName,ProID,CitySort) Values('巢湖市','12','99')
 INSERT T_City(CityName,ProID,CitySort) Values('六安市','12','100')
 INSERT T_City(CityName,ProID,CitySort) Values('亳州市','12','101')
 INSERT T_City(CityName,ProID,CitySort) Values('池州市','12','102')
 INSERT T_City(CityName,ProID,CitySort) Values('宣城市','12','103')
 INSERT T_City(CityName,ProID,CitySort) Values('福州市','13','104')
 INSERT T_City(CityName,ProID,CitySort) Values('厦门市','13','105')
 INSERT T_City(CityName,ProID,CitySort) Values('宁德市','13','106')
 INSERT T_City(CityName,ProID,CitySort) Values('莆田市','13','107')
 INSERT T_City(CityName,ProID,CitySort) Values('泉州市','13','108')
 INSERT T_City(CityName,ProID,CitySort) Values('漳州市','13','109')
 INSERT T_City(CityName,ProID,CitySort) Values('龙岩市','13','110')
 INSERT T_City(CityName,ProID,CitySort) Values('三明市','13','111')
 INSERT T_City(CityName,ProID,CitySort) Values('南平市','13','112')
 INSERT T_City(CityName,ProID,CitySort) Values('鹰潭市','14','113')
 INSERT T_City(CityName,ProID,CitySort) Values('新余市','14','114')
 INSERT T_City(CityName,ProID,CitySort) Values('南昌市','14','115')
 INSERT T_City(CityName,ProID,CitySort) Values('九江市','14','116')
 INSERT T_City(CityName,ProID,CitySort) Values('上饶市','14','117')
 INSERT T_City(CityName,ProID,CitySort) Values('抚州市','14','118')
 INSERT T_City(CityName,ProID,CitySort) Values('宜春市','14','119')
 INSERT T_City(CityName,ProID,CitySort) Values('吉安市','14','120')
 INSERT T_City(CityName,ProID,CitySort) Values('赣州市','14','121')
 INSERT T_City(CityName,ProID,CitySort) Values('景德镇市','14','122')
 INSERT T_City(CityName,ProID,CitySort) Values('萍乡市','14','123')
 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')
 INSERT T_City(CityName,ProID,CitySort) Values('贵阳市','29','246')
 INSERT T_City(CityName,ProID,CitySort) Values('遵义市','29','247')
 INSERT T_City(CityName,ProID,CitySort) Values('安顺市','29','248')
 INSERT T_City(CityName,ProID,CitySort) Values('黔南布依族苗族自治州','29','249')
 INSERT T_City(CityName,ProID,CitySort) Values('黔东南苗族侗族自治州','29','250')
 INSERT T_City(CityName,ProID,CitySort) Values('铜仁地区','29','251')
 INSERT T_City(CityName,ProID,CitySort) Values('毕节地区','29','252')
 INSERT T_City(CityName,ProID,CitySort) Values('六盘水市','29','253')
 INSERT T_City(CityName,ProID,CitySort) Values('黔西南布依族苗族自治州','29','254')
 INSERT T_City(CityName,ProID,CitySort) Values('海口市','20','255')
 INSERT T_City(CityName,ProID,CitySort) Values('三亚市','20','256')
 INSERT T_City(CityName,ProID,CitySort) Values('五指山市','20','257')
 INSERT T_City(CityName,ProID,CitySort) Values('琼海市','20','258')
 INSERT T_City(CityName,ProID,CitySort) Values('儋州市','20','259')
 INSERT T_City(CityName,ProID,CitySort) Values('文昌市','20','260')
 INSERT T_City(CityName,ProID,CitySort) Values('万宁市','20','261')
 INSERT T_City(CityName,ProID,CitySort) Values('东方市','20','262')
 INSERT T_City(CityName,ProID,CitySort) Values('澄迈县','20','263')
 INSERT T_City(CityName,ProID,CitySort) Values('定安县','20','264')
 INSERT T_City(CityName,ProID,CitySort) Values('屯昌县','20','265')
 INSERT T_City(CityName,ProID,CitySort) Values('临高县','20','266')
 INSERT T_City(CityName,ProID,CitySort) Values('白沙黎族自治县','20','267')
 INSERT T_City(CityName,ProID,CitySort) Values('昌江黎族自治县','20','268')
 INSERT T_City(CityName,ProID,CitySort) Values('乐东黎族自治县','20','269')
 INSERT T_City(CityName,ProID,CitySort) Values('陵水黎族自治县','20','270')
 INSERT T_City(CityName,ProID,CitySort) Values('保亭黎族苗族自治县','20','271')
 INSERT T_City(CityName,ProID,CitySort) Values('琼中黎族苗族自治县','20','272')
 INSERT T_City(CityName,ProID,CitySort) Values('西双版纳傣族自治州','30','273')
 INSERT T_City(CityName,ProID,CitySort) Values('德宏傣族景颇族自治州','30','274')
 INSERT T_City(CityName,ProID,CitySort) Values('昭通市','30','275')
 INSERT T_City(CityName,ProID,CitySort) Values('昆明市','30','276')
 INSERT T_City(CityName,ProID,CitySort) Values('大理白族自治州','30','277')
 INSERT T_City(CityName,ProID,CitySort) Values('红河哈尼族彝族自治州','30','278')
 INSERT T_City(CityName,ProID,CitySort) Values('曲靖市','30','279')
 INSERT T_City(CityName,ProID,CitySort) Values('保山市','30','280')
 INSERT T_City(CityName,ProID,CitySort) Values('文山壮族苗族自治州','30','281')
 INSERT T_City(CityName,ProID,CitySort) Values('玉溪市','30','282')
 INSERT T_City(CityName,ProID,CitySort) Values('楚雄彝族自治州','30','283')
 INSERT T_City(CityName,ProID,CitySort) Values('普洱市','30','284')
 INSERT T_City(CityName,ProID,CitySort) Values('临沧市','30','285')
 INSERT T_City(CityName,ProID,CitySort) Values('怒江傈傈族自治州','30','286')
 INSERT T_City(CityName,ProID,CitySort) Values('迪庆藏族自治州','30','287')
 INSERT T_City(CityName,ProID,CitySort) Values('丽江市','30','288')
 INSERT T_City(CityName,ProID,CitySort) Values('海北藏族自治州','25','289')
 INSERT T_City(CityName,ProID,CitySort) Values('西宁市','25','290')
 INSERT T_City(CityName,ProID,CitySort) Values('海东地区','25','291')
 INSERT T_City(CityName,ProID,CitySort) Values('黄南藏族自治州','25','292')
 INSERT T_City(CityName,ProID,CitySort) Values('海南藏族自治州','25','293')
 INSERT T_City(CityName,ProID,CitySort) Values('果洛藏族自治州','25','294')
 INSERT T_City(CityName,ProID,CitySort) Values('玉树藏族自治州','25','295')
 INSERT T_City(CityName,ProID,CitySort) Values('海西蒙古族藏族自治州','25','296')
 INSERT T_City(CityName,ProID,CitySort) Values('西安市','23','297')
 INSERT T_City(CityName,ProID,CitySort) Values('咸阳市','23','298')
 INSERT T_City(CityName,ProID,CitySort) Values('延安市','23','299')
 INSERT T_City(CityName,ProID,CitySort) Values('榆林市','23','300')
 INSERT T_City(CityName,ProID,CitySort) Values('渭南市','23','301')
 INSERT T_City(CityName,ProID,CitySort) Values('商洛市','23','302')
 INSERT T_City(CityName,ProID,CitySort) Values('安康市','23','303')
 INSERT T_City(CityName,ProID,CitySort) Values('汉中市','23','304')
 INSERT T_City(CityName,ProID,CitySort) Values('宝鸡市','23','305')
 INSERT T_City(CityName,ProID,CitySort) Values('铜川市','23','306')
 INSERT T_City(CityName,ProID,CitySort) Values('防城港市','21','307')
 INSERT T_City(CityName,ProID,CitySort) Values('南宁市','21','308')
 INSERT T_City(CityName,ProID,CitySort) Values('崇左市','21','309')
 INSERT T_City(CityName,ProID,CitySort) Values('来宾市','21','310')
 INSERT T_City(CityName,ProID,CitySort) Values('柳州市','21','311')
 INSERT T_City(CityName,ProID,CitySort) Values('桂林市','21','312')
 INSERT T_City(CityName,ProID,CitySort) Values('梧州市','21','313')
 INSERT T_City(CityName,ProID,CitySort) Values('贺州市','21','314')
 INSERT T_City(CityName,ProID,CitySort) Values('贵港市','21','315')
 INSERT T_City(CityName,ProID,CitySort) Values('玉林市','21','316')
 INSERT T_City(CityName,ProID,CitySort) Values('百色市','21','317')
 INSERT T_City(CityName,ProID,CitySort) Values('钦州市','21','318')
 INSERT T_City(CityName,ProID,CitySort) Values('河池市','21','319')
 INSERT T_City(CityName,ProID,CitySort) Values('北海市','21','320')
 INSERT T_City(CityName,ProID,CitySort) Values('拉萨市','31','321')
 INSERT T_City(CityName,ProID,CitySort) Values('日喀则地区','31','322')
 INSERT T_City(CityName,ProID,CitySort) Values('山南地区','31','323')
 INSERT T_City(CityName,ProID,CitySort) Values('林芝地区','31','324')
 INSERT T_City(CityName,ProID,CitySort) Values('昌都地区','31','325')
 INSERT T_City(CityName,ProID,CitySort) Values('那曲地区','31','326')
 INSERT T_City(CityName,ProID,CitySort) Values('阿里地区','31','327')
 INSERT T_City(CityName,ProID,CitySort) Values('银川市','26','328')
 INSERT T_City(CityName,ProID,CitySort) Values('石嘴山市','26','329')
 INSERT T_City(CityName,ProID,CitySort) Values('吴忠市','26','330')
 INSERT T_City(CityName,ProID,CitySort) Values('固原市','26','331')
 INSERT T_City(CityName,ProID,CitySort) Values('中卫市','26','332')
 INSERT T_City(CityName,ProID,CitySort) Values('塔城地区','24','333')
 INSERT T_City(CityName,ProID,CitySort) Values('哈密地区','24','334')
 INSERT T_City(CityName,ProID,CitySort) Values('和田地区','24','335')
 INSERT T_City(CityName,ProID,CitySort) Values('阿勒泰地区','24','336')
 INSERT T_City(CityName,ProID,CitySort) Values('克孜勒苏柯尔克孜自治州','24','337')
 INSERT T_City(CityName,ProID,CitySort) Values('博尔塔拉蒙古自治州','24','338')
 INSERT T_City(CityName,ProID,CitySort) Values('克拉玛依市','24','339')
 INSERT T_City(CityName,ProID,CitySort) Values('乌鲁木齐市','24','340')
 INSERT T_City(CityName,ProID,CitySort) Values('石河子市','24','341')
 INSERT T_City(CityName,ProID,CitySort) Values('昌吉回族自治州','24','342')
 INSERT T_City(CityName,ProID,CitySort) Values('五家渠市','24','343')
 INSERT T_City(CityName,ProID,CitySort) Values('吐鲁番地区','24','344')
 INSERT T_City(CityName,ProID,CitySort) Values('巴音郭楞蒙古自治州','24','345')
 INSERT T_City(CityName,ProID,CitySort) Values('阿克苏地区','24','346')
 INSERT T_City(CityName,ProID,CitySort) Values('阿拉尔市','24','347')
 INSERT T_City(CityName,ProID,CitySort) Values('喀什地区','24','348')
 INSERT T_City(CityName,ProID,CitySort) Values('图木舒克市','24','349')
 INSERT T_City(CityName,ProID,CitySort) Values('伊犁哈萨克自治州','24','350')
 INSERT T_City(CityName,ProID,CitySort) Values('呼伦贝尔市','5','351')
 INSERT T_City(CityName,ProID,CitySort) Values('呼和浩特市','5','352')
 INSERT T_City(CityName,ProID,CitySort) Values('包头市','5','353')
 INSERT T_City(CityName,ProID,CitySort) Values('乌海市','5','354')
 INSERT T_City(CityName,ProID,CitySort) Values('乌兰察布市','5','355')
 INSERT T_City(CityName,ProID,CitySort) Values('通辽市','5','356')
 INSERT T_City(CityName,ProID,CitySort) Values('赤峰市','5','357')
 INSERT T_City(CityName,ProID,CitySort) Values('鄂尔多斯市','5','358')
 INSERT T_City(CityName,ProID,CitySort) Values('巴彦淖尔市','5','359')
 INSERT T_City(CityName,ProID,CitySort) Values('锡林郭勒盟','5','360')
 INSERT T_City(CityName,ProID,CitySort) Values('兴安盟','5','361')
 INSERT T_City(CityName,ProID,CitySort) Values('阿拉善盟','5','362')
 INSERT T_City(CityName,ProID,CitySort) Values('台北市','32','363')
 INSERT T_City(CityName,ProID,CitySort) Values('高雄市','32','364')
 INSERT T_City(CityName,ProID,CitySort) Values('基隆市','32','365')
 INSERT T_City(CityName,ProID,CitySort) Values('台中市','32','366')
 INSERT T_City(CityName,ProID,CitySort) Values('台南市','32','367')
 INSERT T_City(CityName,ProID,CitySort) Values('新竹市','32','368')
 INSERT T_City(CityName,ProID,CitySort) Values('嘉义市','32','369')
 INSERT T_City(CityName,ProID,CitySort) Values('澳门特别行政区','33','370')
 INSERT T_City(CityName,ProID,CitySort) Values('香港特别行政区','34','371')


 /*********城市县区表*********/
 CREATE TABLE  T_District
 (
Id INT IDENTITY(1,1) PRIMARY KEY,
DisName  NVARCHAR(30) NOT NULL, --区县名称
CityID  INT NOT NULL, --所属城市
DisSort INT  --区县排序
 )
 --1 北京
 insert T_District(DisName,CityID) values('东城区','1')
 insert T_District(DisName,CityID) values('西城区','1')
 insert T_District(DisName,CityID) values('崇文区','1')
 insert T_District(DisName,CityID) values('宣武区','1')
 insert T_District(DisName,CityID) values('朝阳区','1')
 insert T_District(DisName,CityID) values('丰台区','1')
 insert T_District(DisName,CityID) values('石景山区','1')
 insert T_District(DisName,CityID) values('海淀区','1')
 insert T_District(DisName,CityID) values('门头沟区','1')
 insert T_District(DisName,CityID) values('房山区','1')
 insert T_District(DisName,CityID) values('通州区','1')
 insert T_District(DisName,CityID) values('顺义区','1')
 insert T_District(DisName,CityID) values('昌平区','1')
 insert T_District(DisName,CityID) values('大兴区','1')
 insert T_District(DisName,CityID) values('怀柔区','1')
 insert T_District(DisName,CityID) values('平谷区','1')
 insert T_District(DisName,CityID) values('密云县','1')
 insert T_District(DisName,CityID) values('延庆县','1')


 --2 天津
 insert T_District(DisName,CityID) values('和平区','2')
 insert T_District(DisName,CityID) values('河东区','2')
 insert T_District(DisName,CityID) values('河西区','2')
 insert T_District(DisName,CityID) values('南开区','2')
 insert T_District(DisName,CityID) values('河北区','2')
 insert T_District(DisName,CityID) values('红桥区','2')
 insert T_District(DisName,CityID) values('塘沽区','2')
 insert T_District(DisName,CityID) values('汉沽区','2')
 insert T_District(DisName,CityID) values('大港区','2')
 insert T_District(DisName,CityID) values('东丽区','2')
 insert T_District(DisName,CityID) values('西青区','2')
 insert T_District(DisName,CityID) values('津南区','2')
 insert T_District(DisName,CityID) values('北辰区','2')
 insert T_District(DisName,CityID) values('武清区','2')
 insert T_District(DisName,CityID) values('宝坻区','2')
 insert T_District(DisName,CityID) values('宁河县','2')
 insert T_District(DisName,CityID) values('静海县','2')
 insert T_District(DisName,CityID) values('蓟县','2')


 --3 上海市
 insert T_District(DisName,CityID) values('黄浦区','3')
 insert T_District(DisName,CityID) values('卢湾区','3')
 insert T_District(DisName,CityID) values('徐汇区','3')
 insert T_District(DisName,CityID) values('长宁区','3')
 insert T_District(DisName,CityID) values('静安区','3')
 insert T_District(DisName,CityID) values('普陀区','3')
 insert T_District(DisName,CityID) values('闸北区','3')
 insert T_District(DisName,CityID) values('虹口区','3')
 insert T_District(DisName,CityID) values('杨浦区','3')
 insert T_District(DisName,CityID) values('闵行区','3')
 insert T_District(DisName,CityID) values('宝山区','3')
 insert T_District(DisName,CityID) values('嘉定区','3')
 insert T_District(DisName,CityID) values('浦东新区','3')
 insert T_District(DisName,CityID) values('金山区','3')
 insert T_District(DisName,CityID) values('松江区','3')
 insert T_District(DisName,CityID) values('青浦区','3')
 insert T_District(DisName,CityID) values('南汇区','3')
 insert T_District(DisName,CityID) values('奉贤区','3')
 insert T_District(DisName,CityID) values('崇明县','3')


 --4 重庆市
 insert T_District(DisName,CityID) values('万州区','4')
 insert T_District(DisName,CityID) values('涪陵区','4')
 insert T_District(DisName,CityID) values('渝中区','4')
 insert T_District(DisName,CityID) values('大渡口区','4')
 insert T_District(DisName,CityID) values('江北区','4')
 insert T_District(DisName,CityID) values('沙坪坝区','4')
 insert T_District(DisName,CityID) values('九龙坡区','4')
 insert T_District(DisName,CityID) values('南岸区','4')
 insert T_District(DisName,CityID) values('北碚区','4')
 insert T_District(DisName,CityID) values('万盛区','4')
 insert T_District(DisName,CityID) values('双桥区','4')
 insert T_District(DisName,CityID) values('渝北区','4')
 insert T_District(DisName,CityID) values('巴南区','4')
 insert T_District(DisName,CityID) values('黔江区','4')
 insert T_District(DisName,CityID) values('长寿区','4')
 insert T_District(DisName,CityID) values('江津区','4')
 insert T_District(DisName,CityID) values('合川区','4')
 insert T_District(DisName,CityID) values('永川区','4')
 insert T_District(DisName,CityID) values('南川区','4')
 insert T_District(DisName,CityID) values('綦江县','4')
 insert T_District(DisName,CityID) values('潼南县','4')
 insert T_District(DisName,CityID) values('铜梁县','4')
 insert T_District(DisName,CityID) values('大足县','4')
 insert T_District(DisName,CityID) values('荣昌县','4')
 insert T_District(DisName,CityID) values('璧山县','4')
 insert T_District(DisName,CityID) values('梁平县','4')
 insert T_District(DisName,CityID) values('城口县','4')
 insert T_District(DisName,CityID) values('丰都县','4')
 insert T_District(DisName,CityID) values('垫江县','4')
 insert T_District(DisName,CityID) values('武隆县','4')
 insert T_District(DisName,CityID) values('忠县','4')
 insert T_District(DisName,CityID) values('开县','4')
 insert T_District(DisName,CityID) values('云阳县','4')
 insert T_District(DisName,CityID) values('奉节县','4')
 insert T_District(DisName,CityID) values('巫山县','4')
 insert T_District(DisName,CityID) values('巫溪县','4')
 insert T_District(DisName,CityID) values('石柱土家族自治县','4')
 insert T_District(DisName,CityID) values('秀山土家族苗族自治县','4')
 insert T_District(DisName,CityID) values('酉阳土家族苗族自治县','4')
 insert T_District(DisName,CityID) values('彭水苗族土家族自治县','4')