當前位置：首頁 > 编程资源 > 编程问答 >内容正文

编程问答

地区省份城市sql信息

發布時間：2025/3/21 编程问答 41 豆豆

生活随笔收集整理的這篇文章主要介紹了地区省份城市sql信息小編覺得挺不錯的,現在分享給大家,幫大家做個參考.

//國家 INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0','country','01','中國','Y','國家');//省份 INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('01','province','001',?'直轄市','Y','省份'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('01','province','005',?'河北省','Y','省份'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('01','province','006',?'山西省','Y','省份'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('01','province','007',?'臺灣省','Y','省份'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('01','province','008',?'遼寧省','Y','省份'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('01','province','009',?'吉林省','Y','省份'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('01','province','0010',?'黑龍江省','Y','省份'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('01','province','0011',?'江蘇省','Y','省份'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('01','province','0012',?'浙江省','Y','省份'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('01','province','0013',?'安徽省','Y','省份'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('01','province','0014',?'福建省','Y','省份'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('01','province','0015',?'江西省','Y','省份'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('01','province','0016',?'山東省','Y','省份'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('01','province','0017',?'河南省','Y','省份'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('01','province','0018',?'湖北省','Y','省份'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('01','province','0019',?'湖南省','Y','省份'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('01','province','0020',?'廣東省','Y','省份'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('01','province','0021',?'甘肅省','Y','省份'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('01','province','0022',?'四川省','Y','省份'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('01','province','0023',?'貴州省','Y','省份'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('01','province','0024',?'海南省','Y','省份'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('01','province','0025',?'云南省','Y','省份'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('01','province','0026',?'青海省','Y','省份'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('01','province','0027',?'陜西省','Y','省份'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('01','province','0028',?'廣西壯族自治區','Y','省份'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('01','province','0029',?'西藏自治區','Y','省份'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('01','province','0030',?'寧夏回族自治區','Y','省份'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('01','province','0031',?'新疆維吾爾自治區','Y','省份'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('01','province','0032',?'內蒙古自治區','Y','省份'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('01','province','0033',?'澳門特別行政區','Y','省份'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('01','province','0034',?'香港特別行政區','Y','省份');//城市 INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('001','city',?'0001',?'北京市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('001','city',?'0002',?'天津市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('001','city',?'0003',?'上海市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('001','city',?'0004',?'重慶市','Y','城市');INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('005','city','0005',??'石家莊市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('005','city','0006',??'唐山市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('005','city','0007',??'秦皇島市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('005','city','0008',??'邯鄲市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('005','city','0009',??'邢臺市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('005','city','00010',?'保定市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('005','city','00011',?'張家口市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('005','city','00012',?'承德市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('005','city','00013',?'滄州市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('005','city','00014',?'廊坊市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('005','city','00015',?'衡水市','Y','城市');INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('006','city','00016',?'太原市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('006','city','00017',?'大同市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('006','city','00018',?'陽泉市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('006','city','00019',?'長治市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('006','city','00020',?'晉城市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('006','city','00021',?'朔州市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('006','city','00022',?'晉中市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('006','city','00023',?'運城市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('006','city','00024',?'忻州市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('006','city','00025',?'臨汾市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('006','city','00026',?'呂梁市','Y','城市');INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('007','city','00027',?'臺北市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('007','city','00028',?'高雄市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('007','city','00029',?'基隆市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('007','city','00030',?'臺中市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('007','city','00031',?'臺南市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('007','city','00032',?'新竹市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('007','city','00033',?'嘉義市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('007','city','00034',?'臺北縣','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('007','city','00035',?'宜蘭縣','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('007','city','00036',?'桃園縣','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('007','city','00037',?'新竹縣','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('007','city','00038',?'苗栗縣','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('007','city','00039',?'臺中縣','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('007','city','00040',?'彰化縣','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('007','city','00041',?'南投縣','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('007','city','00042',?'云林縣','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('007','city','00043',?'嘉義縣','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('007','city','00044',?'臺南縣','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('007','city','00045',?'高雄縣','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('007','city','00046',?'屏東縣','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('007','city','00047',?'澎湖縣','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('007','city','00048',?'臺東縣','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('007','city','00049',?'花蓮縣','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('008','city','00050',?'沈陽市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('008','city','00051',?'大連市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('008','city','00052',?'鞍山市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('008','city','00053',?'撫順市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('008','city','00054',?'本溪市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('008','city','00055',?'丹東市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('008','city','00056',?'錦州市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('008','city','00057',?'營口市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('008','city','00058',?'阜新市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('008','city','00059',?'遼陽市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('008','city','00060',?'盤錦市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('008','city','00061',?'鐵嶺市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('008','city','00062',?'朝陽市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('008','city','00063',?'葫蘆島市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('009','city','00064',?'長春市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('009','city','00065',?'吉林市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('009','city','00066',?'四平市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('009','city','00067',?'遼源市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('009','city','00068',?'通化市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('009','city','00069',?'白山市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('009','city','00070',?'松原市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('009','city','00071',?'白城市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('009','city','00072',?'延邊朝鮮族自治州','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0010','city','00073',?'哈爾濱市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0010','city','00074',?'齊齊哈爾市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0010','city','00075',?'鶴崗市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0010','city','00076',?'雙鴨山市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0010','city','00077',?'雞西市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0010','city','00078',?'大慶市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0010','city','00079',?'伊春市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0010','city','00080',?'牡丹江市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0010','city','00081',?'佳木斯市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0010','city','00082',?'七臺河市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0010','city','00083',?'黑河市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0010','city','00084',?'綏化市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0010','city','00085',?'大興安嶺地區','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0011','city','00086',?'南京市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0011','city','00087',?'無錫市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0011','city','00088',?'徐州市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0011','city','00089',?'常州市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0011','city','00090',?'蘇州市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0011','city','00091',?'南通市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0011','city','00092',?'連云港市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0011','city','00093',?'淮安市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0011','city','00094',?'鹽城市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0011','city','00095',?'揚州市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0011','city','00096',?'鎮江市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0011','city','00097',?'泰州市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0011','city','00098',?'宿遷市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0012','city','00099',?'杭州市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0012','city','000100',?'寧波市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0012','city','000101',?'溫州市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0012','city','000102',?'嘉興市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0012','city','000103',?'湖州市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0012','city','000104',?'紹興市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0012','city','000105',?'金華市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0012','city','000106',?'衢州市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0012','city','000107',?'舟山市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0012','city','000108',?'臺州市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0012','city','000109',?'麗水市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0013','city','000110',?'合肥市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0013','city','000111',?'蕪湖市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0013','city','000112',?'蚌埠市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0013','city','000113',?'淮南市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0013','city','000114',?'馬鞍山市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0013','city','000115',?'淮北市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0013','city','000116',?'銅陵市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0013','city','000117',?'安慶市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0013','city','000118',?'黃山市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0013','city','000119',?'滁州市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0013','city','000120',?'阜陽市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0013','city','000121',?'宿州市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0013','city','000122',?'巢湖市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0013','city','000123',?'六安市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0013','city','000124',?'亳州市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0013','city','000125',?'池州市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0013','city','000126',?'宣城市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0014','city','000127',?'福州市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0014','city','000128',?'廈門市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0014','city','000129',?'莆田市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0014','city','000130',?'三明市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0014','city','000131',?'泉州市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0014','city','000132',?'漳州市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0014','city','000133',?'南平市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0014','city','000134',?'龍巖市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0014','city','000135',?'寧德市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0015','city','000136',?'南昌市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0015','city','000137',?'景德鎮市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0015','city','000138',?'萍鄉市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0015','city','000139',?'九江市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0015','city','000140',?'新余市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0015','city','000141',?'鷹潭市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0015','city','000142',?'贛州市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0015','city','000143',?'吉安市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0015','city','000144',?'宜春市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0015','city','000145',?'撫州市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0015','city','000146',?'上饒市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0016','city','000147',?'濟南市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0016','city','000148',?'青島市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0016','city','000149',?'淄博市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0016','city','000150',?'棗莊市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0016','city','000151',?'東營市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0016','city','000152',?'煙臺市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0016','city','000153',?'濰坊市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0016','city','000154',?'濟寧市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0016','city','000155',?'泰安市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0016','city','000156',?'威海市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0016','city','000157',?'日照市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0016','city','000158',?'萊蕪市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0016','city','000159',?'臨沂市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0016','city','000160',?'德州市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0016','city','000161',?'聊城市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0016','city','000162',?'濱州市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0016','city','000163',?'菏澤市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0017','city','000164',?'鄭州市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0017','city','000165',?'開封市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0017','city','000166',?'洛陽市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0017','city','000167',?'平頂山市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0017','city','000168',?'安陽市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0017','city','000169',?'鶴壁市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0017','city','000170',?'新鄉市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0017','city','000171',?'焦作市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0017','city','000172',?'濮陽市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0017','city','000173',?'許昌市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0017','city','000174',?'漯河市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0017','city','000175',?'三門峽市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0017','city','000176',?'南陽市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0017','city','000177',?'商丘市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0017','city','000178',?'信陽市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0017','city','000179',?'周口市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0017','city','000180',?'駐馬店市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0017','city','000181',?'濟源市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0018','city','000182',?'武漢市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0018','city','000183',?'黃石市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0018','city','000184',?'十堰市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0018','city','000185',?'荊州市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0018','city','000186',?'宜昌市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0018','city','000187',?'襄樊市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0018','city','000188',?'鄂州市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0018','city','000189',?'荊門市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0018','city','000190',?'孝感市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0018','city','000191',?'黃岡市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0018','city','000192',?'咸寧市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0018','city','000193',?'隨州市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0018','city','000194',?'仙桃市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0018','city','000195',?'天門市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0018','city','000196',?'潛江市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0018','city','000197',?'神農架林區','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0018','city','000198',?'恩施土家族苗族自治州','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0019','city','000199',?'長沙市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0019','city','000200',?'株洲市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0019','city','000201',?'湘潭市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0019','city','000202',?'衡陽市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0019','city','000203',?'邵陽市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0019','city','000204',?'岳陽市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0019','city','000205',?'常德市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0019','city','000206',?'張家界市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0019','city','000207',?'益陽市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0019','city','000208',?'郴州市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0019','city','000209',?'永州市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0019','city','000210',?'懷化市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0019','city','000211',?'婁底市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0019','city','000212',?'湘西土家族苗族自治州','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0020','city','000213',?'廣州市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0020','city','000214',?'深圳市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0020','city','000215',?'珠海市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0020','city','000216',?'汕頭市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0020','city','000217',?'韶關市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0020','city','000218',?'佛山市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0020','city','000219',?'江門市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0020','city','000220',?'湛江市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0020','city','000221',?'茂名市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0020','city','000222',?'肇慶市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0020','city','000223',?'惠州市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0020','city','000224',?'梅州市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0020','city','000225',?'汕尾市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0020','city','000226',?'河源市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0020','city','000227',?'陽江市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0020','city','000228',?'清遠市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0020','city','000229',?'東莞市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0020','city','000230',?'中山市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0020','city','000231',?'潮州市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0020','city','000232',?'揭陽市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0020','city','000233',?'云浮市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0021','city','000234',?'蘭州市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0021','city','000235',?'金昌市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0021','city','000236',?'白銀市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0021','city','000237',?'天水市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0021','city','000238',?'嘉峪關市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0021','city','000239',?'武威市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0021','city','000240',?'張掖市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0021','city','000241',?'平涼市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0021','city','000242',?'酒泉市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0021','city','000243',?'慶陽市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0021','city','000244',?'定西市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0021','city','000245',?'隴南市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0021','city','000246',?'臨夏回族自治州','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0021','city','000247',?'甘南藏族自治州','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0022','city','000248',?'成都市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0022','city','000249',?'自貢市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0022','city','000250',?'攀枝花市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0022','city','000251',?'瀘州市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0022','city','000252',?'德陽市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0022','city','000253',?'綿陽市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0022','city','000254',?'廣元市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0022','city','000255',?'遂寧市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0022','city','000256',?'內江市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0022','city','000257',?'樂山市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0022','city','000258',?'南充市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0022','city','000259',?'眉山市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0022','city','000260',?'宜賓市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0022','city','000261',?'廣安市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0022','city','000262',?'達州市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0022','city','000263',?'雅安市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0022','city','000264',?'巴中市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0022','city','000265',?'資陽市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0022','city','000266',?'阿壩藏族羌族自治州','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0022','city','000267',?'甘孜藏族自治州','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0022','city','000268',?'涼山彝族自治州','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0023','city','000269',?'貴陽市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0023','city','000270',?'六盤水市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0023','city','000271',?'遵義市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0023','city','000272',?'安順市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0023','city','000273',?'銅仁地區','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0023','city','000274',?'畢節地區','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0023','city','000275',?'黔西南布依族苗族自治州','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0023','city','000276',?'黔東南苗族侗族自治州','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0023','city','000277',?'黔南布依族苗族自治州','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0024','city','000278',?'海口市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0024','city','000279',?'三亞市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0024','city','000280',?'五指山市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0024','city','000281',?'瓊海市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0024','city','000282',?'儋州市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0024','city','000283',?'文昌市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0024','city','000284',?'萬寧市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0024','city','000285',?'東方市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0024','city','000286',?'澄邁縣','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0024','city','000287',?'定安縣','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0024','city','000288',?'屯昌縣','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0024','city','000289',?'臨高縣','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0024','city','000290',?'白沙黎族自治縣','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0024','city','000291',?'昌江黎族自治縣','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0024','city','000292',?'樂東黎族自治縣','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0024','city','000293',?'陵水黎族自治縣','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0024','city','000294',?'保亭黎族苗族自治縣','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0024','city','000295',?'瓊中黎族苗族自治縣','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0025','city','000296',?'昆明市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0025','city','000297',?'曲靖市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0025','city','000298',?'玉溪市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0025','city','000299',?'保山市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0025','city','000300',?'昭通市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0025','city','000301',?'麗江市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0025','city','000302',?'思茅市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0025','city','000303',?'臨滄市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0025','city','000304',?'文山壯族苗族自治州','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0025','city','000305',?'紅河哈尼族彝族自治州','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0025','city','000306',?'西雙版納傣族自治州','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0025','city','000307',?'楚雄彝族自治州','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0025','city','000308',?'大理白族自治州','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0025','city','000309',?'德宏傣族景頗族自治州','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0025','city','000310',?'怒江傈傈族自治州','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0025','city','000311',?'迪慶藏族自治州','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0026','city','000312',?'西寧市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0026','city','000313',?'海東地區','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0026','city','000314',?'海北藏族自治州','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0026','city','000315',?'黃南藏族自治州','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0026','city','000316',?'海南藏族自治州','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0026','city','000317',?'果洛藏族自治州','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0026','city','000318',?'玉樹藏族自治州','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0026','city','000319',?'海西蒙古族藏族自治州','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0027','city','000320',?'西安市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0027','city','000321',?'銅川市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0027','city','000322',?'寶雞市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0027','city','000323',?'咸陽市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0027','city','000324',?'渭南市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0027','city','000325',?'延安市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0027','city','000326',?'漢中市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0027','city','000327',?'榆林市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0027','city','000328',?'安康市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0027','city','000329',?'商洛市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0028','city','000330',?'南寧市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0028','city','000331',?'柳州市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0028','city','000332',?'桂林市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0028','city','000333',?'梧州市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0028','city','000334',?'北海市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0028','city','000335',?'防城港市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0028','city','000336',?'欽州市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0028','city','000337',?'貴港市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0028','city','000338',?'玉林市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0028','city','000339',?'百色市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0028','city','000340',?'賀州市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0028','city','000341',?'河池市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0028','city','000342',?'來賓市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0028','city','000343',?'崇左市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0029','city','000344',?'拉薩市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0029','city','000345',?'那曲地區','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0029','city','000346',?'昌都地區','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0029','city','000347',?'山南地區','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0029','city','000348',?'日喀則地區','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0029','city','000349',?'阿里地區','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0029','city','000350',?'林芝地區','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0030','city','000351',?'銀川市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0030','city','000352',?'石嘴山市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0030','city','000353',?'吳忠市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0030','city','000354',?'固原市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0030','city','000355',?'中衛市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0031','city','000356',?'烏魯木齊市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0031','city','000357',?'克拉瑪依市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0031','city','000358',?'石河子市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0031','city','000359',?'阿拉爾市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0031','city','000360',?'圖木舒克市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0031','city','000361',?'五家渠市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0031','city','000362',?'吐魯番市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0031','city','000363',?'阿克蘇市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0031','city','000364',?'喀什市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0031','city','000365',?'哈密市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0031','city','000366',?'和田市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0031','city','000367',?'阿圖什市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0031','city','000368',?'庫爾勒市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0031','city','000369',?'昌吉市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0031','city','000370',?'阜康市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0031','city','000371',?'米泉市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0031','city','000372',?'博樂市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0031','city','000373',?'伊寧市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0031','city','000374',?'奎屯市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0031','city','000375',?'塔城市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0031','city','000376',?'烏蘇市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0031','city','000377',?'阿勒泰市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0032','city','000378',?'呼和浩特市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0032','city','000379',?'包頭市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0032','city','000380',?'烏海市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0032','city','000381',?'赤峰市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0032','city','000382',?'通遼市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0032','city','000383',?'鄂爾多斯市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0032','city','000384',?'呼倫貝爾市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0032','city','000385',?'巴彥淖爾市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0032','city','000386',?'烏蘭察布市','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0032','city','000387',?'錫林郭勒盟','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0032','city','000388',?'興安盟','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0032','city','000389',?'阿拉善盟','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0033','city','000390',?'澳門特別行政區','Y','城市'); INSERT?INTO?base_parameter?(parent_code,dtype,code,cname,parameterStatus,remark)?VALUES?('0034','city','000391',?'香港特別行政區','Y','城市');

轉載于:https://blog.51cto.com/alex233/1716712

總結

以上是生活随笔為你收集整理的地区省份城市sql信息的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。

上一篇：用prop还是attr
下一篇： [python]python字典