當前位置：首頁 > 运维知识 > 数据库 >内容正文

数据库

mysql省市县数据库

發布時間：2024/3/24 数据库 33 豆豆

生活随笔收集整理的這篇文章主要介紹了 mysql省市县数据库小編覺得挺不錯的,現在分享給大家,幫大家做個參考.

CREATE TABLE `base_area` (
? `id` mediumint(12) unsigned NOT NULL auto_increment COMMENT 'id',
? `pid` int(12) NOT NULL COMMENT '父id',
? `name` varchar(60) NOT NULL COMMENT '名稱',
? `display` tinyint(1) NOT NULL COMMENT '顯示屬性',
? PRIMARY KEY? (`id`)
) ENGINE=MyISAM? DEFAULT CHARSET=gbk COMMENT='省市縣數據表'; 數據： #省級
INSERT INTO `base_area` SET `id`='1',`pid`='0',`name`='安徽';
#省級
INSERT INTO `base_area` SET `id`='2',`pid`='0',`name`='北京';
#省級
INSERT INTO `base_area` SET `id`='3',`pid`='0',`name`='福建';
#省級
INSERT INTO `base_area` SET `id`='4',`pid`='0',`name`='甘肅';
#省級
INSERT INTO `base_area` SET `id`='5',`pid`='0',`name`='廣東';
#省級
INSERT INTO `base_area` SET `id`='6',`pid`='0',`name`='廣西';
#省級
INSERT INTO `base_area` SET `id`='7',`pid`='0',`name`='貴州';
#省級
INSERT INTO `base_area` SET `id`='8',`pid`='0',`name`='海南';
#省級
INSERT INTO `base_area` SET `id`='9',`pid`='0',`name`='河北';
#省級
INSERT INTO `base_area` SET `id`='10',`pid`='0',`name`='河南';
#省級
INSERT INTO `base_area` SET `id`='11',`pid`='0',`name`='黑龍江';
#省級
INSERT INTO `base_area` SET `id`='12',`pid`='0',`name`='湖北';
#省級
INSERT INTO `base_area` SET `id`='13',`pid`='0',`name`='湖南';
#省級
INSERT INTO `base_area` SET `id`='14',`pid`='0',`name`='吉林';
#省級
INSERT INTO `base_area` SET `id`='15',`pid`='0',`name`='江蘇';
#省級
INSERT INTO `base_area` SET `id`='16',`pid`='0',`name`='江西';
#省級
INSERT INTO `base_area` SET `id`='17',`pid`='0',`name`='遼寧';
#省級
INSERT INTO `base_area` SET `id`='18',`pid`='0',`name`='內蒙古';
#省級
INSERT INTO `base_area` SET `id`='19',`pid`='0',`name`='寧夏';
#省級
INSERT INTO `base_area` SET `id`='20',`pid`='0',`name`='青海';
#省級
INSERT INTO `base_area` SET `id`='21',`pid`='0',`name`='山東';
#省級
INSERT INTO `base_area` SET `id`='22',`pid`='0',`name`='山西';
#省級
INSERT INTO `base_area` SET `id`='23',`pid`='0',`name`='陜西';
#省級
INSERT INTO `base_area` SET `id`='24',`pid`='0',`name`='上海';
#省級
INSERT INTO `base_area` SET `id`='25',`pid`='0',`name`='四川';
#省級
INSERT INTO `base_area` SET `id`='26',`pid`='0',`name`='天津';
#省級
INSERT INTO `base_area` SET `id`='27',`pid`='0',`name`='西藏';
#省級
INSERT INTO `base_area` SET `id`='28',`pid`='0',`name`='新疆';
#省級
INSERT INTO `base_area` SET `id`='29',`pid`='0',`name`='云南';
#省級
INSERT INTO `base_area` SET `id`='30',`pid`='0',`name`='浙江';
#省級
INSERT INTO `base_area` SET `id`='31',`pid`='0',`name`='重慶';
#市級1
INSERT INTO `base_area` SET `id`='10000',`pid`='1',`name`='安慶';
INSERT INTO `base_area` SET `id`='10001',`pid`='2',`name`='蚌埠';
INSERT INTO `base_area` SET `id`='10002',`pid`='3',`name`='巢湖';
INSERT INTO `base_area` SET `id`='10003',`pid`='4',`name`='池州';
INSERT INTO `base_area` SET `id`='10004',`pid`='5',`name`='滁州';
INSERT INTO `base_area` SET `id`='10005',`pid`='6',`name`='阜陽';
INSERT INTO `base_area` SET `id`='10006',`pid`='7',`name`='合肥';
INSERT INTO `base_area` SET `id`='10007',`pid`='8',`name`='淮北';
INSERT INTO `base_area` SET `id`='10008',`pid`='9',`name`='淮南';
INSERT INTO `base_area` SET `id`='10009',`pid`='10',`name`='黃山';
INSERT INTO `base_area` SET `id`='10010',`pid`='11',`name`='六安';
INSERT INTO `base_area` SET `id`='10011',`pid`='12',`name`='馬鞍山';
INSERT INTO `base_area` SET `id`='10012',`pid`='13',`name`='宿州';
INSERT INTO `base_area` SET `id`='10013',`pid`='14',`name`='銅陵';
INSERT INTO `base_area` SET `id`='10014',`pid`='15',`name`='蕪湖';
INSERT INTO `base_area` SET `id`='10015',`pid`='16',`name`='宣城';
INSERT INTO `base_area` SET `id`='10016',`pid`='17',`name`='亳州';
#縣級10000
INSERT INTO `base_area` SET `id`='100010',`pid`='10000',`name`='安慶市';
INSERT INTO `base_area` SET `id`='100011',`pid`='10000',`name`='懷寧縣';
INSERT INTO `base_area` SET `id`='100012',`pid`='10000',`name`='潛山縣';
INSERT INTO `base_area` SET `id`='100013',`pid`='10000',`name`='宿松縣';
INSERT INTO `base_area` SET `id`='100014',`pid`='10000',`name`='太湖縣';
INSERT INTO `base_area` SET `id`='100015',`pid`='10000',`name`='桐城市';
INSERT INTO `base_area` SET `id`='100016',`pid`='10000',`name`='望江縣';
INSERT INTO `base_area` SET `id`='100017',`pid`='10000',`name`='岳西縣';
INSERT INTO `base_area` SET `id`='100018',`pid`='10000',`name`='樅陽縣';
#縣級10001
INSERT INTO `base_area` SET `id`='100020',`pid`='10001',`name`='蚌埠市';
INSERT INTO `base_area` SET `id`='100021',`pid`='10001',`name`='固鎮縣';
INSERT INTO `base_area` SET `id`='100022',`pid`='10001',`name`='懷遠縣';
INSERT INTO `base_area` SET `id`='100023',`pid`='10001',`name`='五河縣';
#縣級10002
INSERT INTO `base_area` SET `id`='100030',`pid`='10002',`name`='巢湖市';
INSERT INTO `base_area` SET `id`='100031',`pid`='10002',`name`='含山縣';
INSERT INTO `base_area` SET `id`='100032',`pid`='10002',`name`='和縣';
INSERT INTO `base_area` SET `id`='100033',`pid`='10002',`name`='廬江縣';
INSERT INTO `base_area` SET `id`='100034',`pid`='10002',`name`='無為縣';
#縣級10003
INSERT INTO `base_area` SET `id`='100040',`pid`='10003',`name`='池州市';
INSERT INTO `base_area` SET `id`='100041',`pid`='10003',`name`='東至縣';
INSERT INTO `base_area` SET `id`='100042',`pid`='10003',`name`='青陽縣';
INSERT INTO `base_area` SET `id`='100043',`pid`='10003',`name`='石臺縣';
#縣級10004
INSERT INTO `base_area` SET `id`='100050',`pid`='10004',`name`='滁州市';
INSERT INTO `base_area` SET `id`='100051',`pid`='10004',`name`='定遠縣';
INSERT INTO `base_area` SET `id`='100052',`pid`='10004',`name`='鳳陽縣';
INSERT INTO `base_area` SET `id`='100053',`pid`='10004',`name`='來安縣';
INSERT INTO `base_area` SET `id`='100054',`pid`='10004',`name`='明光市';
INSERT INTO `base_area` SET `id`='100055',`pid`='10004',`name`='全椒縣';
INSERT INTO `base_area` SET `id`='100056',`pid`='10004',`name`='天長市';
#縣級10005
INSERT INTO `base_area` SET `id`='100060',`pid`='10005',`name`='阜南縣';
INSERT INTO `base_area` SET `id`='100061',`pid`='10005',`name`='阜陽市';
INSERT INTO `base_area` SET `id`='100062',`pid`='10005',`name`='界首市';
INSERT INTO `base_area` SET `id`='100063',`pid`='10005',`name`='臨泉縣';
INSERT INTO `base_area` SET `id`='100064',`pid`='10005',`name`='太和縣';
INSERT INTO `base_area` SET `id`='100065',`pid`='10005',`name`='穎上縣';
#縣級10006
INSERT INTO `base_area` SET `id`='100070',`pid`='10006',`name`='長豐縣';
INSERT INTO `base_area` SET `id`='100071',`pid`='10006',`name`='肥東縣';
INSERT INTO `base_area` SET `id`='100072',`pid`='10006',`name`='肥西縣';
#縣級10007
INSERT INTO `base_area` SET `id`='100080',`pid`='10007',`name`='淮北市';
INSERT INTO `base_area` SET `id`='100081',`pid`='10007',`name`='濉溪縣';
#縣級10008
INSERT INTO `base_area` SET `id`='100090',`pid`='10008',`name`='鳳臺縣';
INSERT INTO `base_area` SET `id`='100091',`pid`='10008',`name`='淮南市';
#縣級10009
INSERT INTO `base_area` SET `id`='100100',`pid`='10009',`name`='黃山市';
INSERT INTO `base_area` SET `id`='100101',`pid`='10009',`name`='祁門縣';
INSERT INTO `base_area` SET `id`='100102',`pid`='10009',`name`='休寧縣';
INSERT INTO `base_area` SET `id`='100103',`pid`='10009',`name`='歙縣';
INSERT INTO `base_area` SET `id`='100104',`pid`='10009',`name`='黟縣';
#縣級10010
INSERT INTO `base_area` SET `id`='100110',`pid`='10010',`name`='霍邱縣';
INSERT INTO `base_area` SET `id`='100111',`pid`='10010',`name`='霍山縣';
INSERT INTO `base_area` SET `id`='100112',`pid`='10010',`name`='金寨縣';
INSERT INTO `base_area` SET `id`='100113',`pid`='10010',`name`='六安市';
INSERT INTO `base_area` SET `id`='100114',`pid`='10010',`name`='壽縣';
INSERT INTO `base_area` SET `id`='100115',`pid`='10010',`name`='舒城縣';
#縣級10011
INSERT INTO `base_area` SET `id`='100120',`pid`='10011',`name`='當涂縣';
INSERT INTO `base_area` SET `id`='100121',`pid`='10011',`name`='馬鞍山市';
#縣級10012
INSERT INTO `base_area` SET `id`='100130',`pid`='10012',`name`='靈璧縣';
INSERT INTO `base_area` SET `id`='100131',`pid`='10012',`name`='宿州市';
INSERT INTO `base_area` SET `id`='100132',`pid`='10012',`name`='蕭縣';
INSERT INTO `base_area` SET `id`='100133',`pid`='10012',`name`='泗縣';
INSERT INTO `base_area` SET `id`='100134',`pid`='10012',`name`='碭山縣';
#縣級10013
INSERT INTO `base_area` SET `id`='100140',`pid`='10013',`name`='銅陵市';
INSERT INTO `base_area` SET `id`='100141',`pid`='10013',`name`='銅陵縣';
#縣級10014
INSERT INTO `base_area` SET `id`='100150',`pid`='10014',`name`='繁昌縣';
INSERT INTO `base_area` SET `id`='100151',`pid`='10014',`name`='南陵縣';
INSERT INTO `base_area` SET `id`='100152',`pid`='10014',`name`='蕪湖市';
INSERT INTO `base_area` SET `id`='100153',`pid`='10014',`name`='蕪湖縣';
#縣級10015
INSERT INTO `base_area` SET `id`='100160',`pid`='10015',`name`='廣德縣';
INSERT INTO `base_area` SET `id`='100161',`pid`='10015',`name`='績溪縣';
INSERT INTO `base_area` SET `id`='100162',`pid`='10015',`name`='郎溪縣';
INSERT INTO `base_area` SET `id`='100163',`pid`='10015',`name`='寧國市';
INSERT INTO `base_area` SET `id`='100164',`pid`='10015',`name`='宣城市';
INSERT INTO `base_area` SET `id`='100165',`pid`='10015',`name`='涇縣';
INSERT INTO `base_area` SET `id`='100166',`pid`='10015',`name`='旌德縣';
#縣級10016
INSERT INTO `base_area` SET `id`='100170',`pid`='10016',`name`='利辛縣';
INSERT INTO `base_area` SET `id`='100171',`pid`='10016',`name`='蒙城縣';
INSERT INTO `base_area` SET `id`='100172',`pid`='10016',`name`='渦陽縣';
INSERT INTO `base_area` SET `id`='100173',`pid`='10016',`name`='亳州市';
#市級2
INSERT INTO `base_area` SET `id`='20000',`pid`='2',`name`='北京';
#縣級20000
INSERT INTO `base_area` SET `id`='200010',`pid`='20000',`name`='北京市';
INSERT INTO `base_area` SET `id`='200011',`pid`='20000',`name`='密云縣';
INSERT INTO `base_area` SET `id`='200012',`pid`='20000',`name`='延慶縣';
#市級3
INSERT INTO `base_area` SET `id`='30000',`pid`='3',`name`='福州';
INSERT INTO `base_area` SET `id`='30001',`pid`='4',`name`='龍巖';
INSERT INTO `base_area` SET `id`='30002',`pid`='5',`name`='南平';
INSERT INTO `base_area` SET `id`='30003',`pid`='6',`name`='寧德';
INSERT INTO `base_area` SET `id`='30004',`pid`='7',`name`='莆田';
INSERT INTO `base_area` SET `id`='30005',`pid`='8',`name`='泉州';
INSERT INTO `base_area` SET `id`='30006',`pid`='9',`name`='三明';
INSERT INTO `base_area` SET `id`='30007',`pid`='10',`name`='廈門';
INSERT INTO `base_area` SET `id`='30008',`pid`='11',`name`='漳州';
#縣級30000
INSERT INTO `base_area` SET `id`='300010',`pid`='30000',`name`='長樂市';
INSERT INTO `base_area` SET `id`='300011',`pid`='30000',`name`='福清市';
INSERT INTO `base_area` SET `id`='300012',`pid`='30000',`name`='福州市';
INSERT INTO `base_area` SET `id`='300013',`pid`='30000',`name`='連江縣';
INSERT INTO `base_area` SET `id`='300014',`pid`='30000',`name`='羅源縣';
INSERT INTO `base_area` SET `id`='300015',`pid`='30000',`name`='閩侯縣';
INSERT INTO `base_area` SET `id`='300016',`pid`='30000',`name`='閩清縣';
INSERT INTO `base_area` SET `id`='300017',`pid`='30000',`name`='平潭縣';
INSERT INTO `base_area` SET `id`='300018',`pid`='30000',`name`='永泰縣';
#縣級30001
INSERT INTO `base_area` SET `id`='300020',`pid`='30001',`name`='長汀縣';
INSERT INTO `base_area` SET `id`='300021',`pid`='30001',`name`='連城縣';
INSERT INTO `base_area` SET `id`='300022',`pid`='30001',`name`='龍巖市';
INSERT INTO `base_area` SET `id`='300023',`pid`='30001',`name`='上杭縣';
INSERT INTO `base_area` SET `id`='300024',`pid`='30001',`name`='武平縣';
INSERT INTO `base_area` SET `id`='300025',`pid`='30001',`name`='永定縣';
INSERT INTO `base_area` SET `id`='300026',`pid`='30001',`name`='漳平市';
#縣級30002
INSERT INTO `base_area` SET `id`='300030',`pid`='30002',`name`='光澤縣';
INSERT INTO `base_area` SET `id`='300031',`pid`='30002',`name`='建陽市';
INSERT INTO `base_area` SET `id`='300032',`pid`='30002',`name`='建甌市';
INSERT INTO `base_area` SET `id`='300033',`pid`='30002',`name`='南平市';
INSERT INTO `base_area` SET `id`='300034',`pid`='30002',`name`='浦城縣';
INSERT INTO `base_area` SET `id`='300035',`pid`='30002',`name`='邵武市';
INSERT INTO `base_area` SET `id`='300036',`pid`='30002',`name`='順昌縣';
INSERT INTO `base_area` SET `id`='300037',`pid`='30002',`name`='松溪縣';
INSERT INTO `base_area` SET `id`='300038',`pid`='30002',`name`='武夷山市';
INSERT INTO `base_area` SET `id`='300039',`pid`='30002',`name`='政和縣';
#縣級30003
INSERT INTO `base_area` SET `id`='300040',`pid`='30003',`name`='福安市';
INSERT INTO `base_area` SET `id`='300041',`pid`='30003',`name`='福鼎市';
INSERT INTO `base_area` SET `id`='300042',`pid`='30003',`name`='古田縣';
INSERT INTO `base_area` SET `id`='300043',`pid`='30003',`name`='寧德市';
INSERT INTO `base_area` SET `id`='300044',`pid`='30003',`name`='屏南縣';
INSERT INTO `base_area` SET `id`='300045',`pid`='30003',`name`='壽寧縣';
INSERT INTO `base_area` SET `id`='300046',`pid`='30003',`name`='霞浦縣';
INSERT INTO `base_area` SET `id`='300047',`pid`='30003',`name`='周寧縣';
INSERT INTO `base_area` SET `id`='300048',`pid`='30003',`name`='柘榮縣';
#縣級30004
INSERT INTO `base_area` SET `id`='300050',`pid`='30004',`name`='莆田市';
INSERT INTO `base_area` SET `id`='300051',`pid`='30004',`name`='仙游縣';
#縣級30005
INSERT INTO `base_area` SET `id`='300060',`pid`='30005',`name`='安溪縣';
INSERT INTO `base_area` SET `id`='300061',`pid`='30005',`name`='德化縣';
INSERT INTO `base_area` SET `id`='300062',`pid`='30005',`name`='惠安縣';
INSERT INTO `base_area` SET `id`='300063',`pid`='30005',`name`='金門縣';
INSERT INTO `base_area` SET `id`='300064',`pid`='30005',`name`='晉江市';
INSERT INTO `base_area` SET `id`='300065',`pid`='30005',`name`='南安市';
INSERT INTO `base_area` SET `id`='300066',`pid`='30005',`name`='泉州市';
INSERT INTO `base_area` SET `id`='300067',`pid`='30005',`name`='石獅市';
INSERT INTO `base_area` SET `id`='300068',`pid`='30005',`name`='永春縣';
#縣級30006
INSERT INTO `base_area` SET `id`='300070',`pid`='30006',`name`='大田縣';
INSERT INTO `base_area` SET `id`='300071',`pid`='30006',`name`='建寧縣';
INSERT INTO `base_area` SET `id`='300072',`pid`='30006',`name`='將樂縣';
INSERT INTO `base_area` SET `id`='300073',`pid`='30006',`name`='明溪縣';
INSERT INTO `base_area` SET `id`='300074',`pid`='30006',`name`='寧化縣';
INSERT INTO `base_area` SET `id`='300075',`pid`='30006',`name`='清流縣';
INSERT INTO `base_area` SET `id`='300076',`pid`='30006',`name`='三明市';
INSERT INTO `base_area` SET `id`='300077',`pid`='30006',`name`='沙縣';
INSERT INTO `base_area` SET `id`='300078',`pid`='30006',`name`='泰寧縣';
INSERT INTO `base_area` SET `id`='300079',`pid`='30006',`name`='永安市';
INSERT INTO `base_area` SET `id`='300080',`pid`='30006',`name`='尤溪縣';
#縣級30007
INSERT INTO `base_area` SET `id`='300081',`pid`='30007',`name`='廈門市';
#縣級30008
INSERT INTO `base_area` SET `id`='300090',`pid`='30008',`name`='長泰縣';
INSERT INTO `base_area` SET `id`='300091',`pid`='30008',`name`='東山縣';
INSERT INTO `base_area` SET `id`='300092',`pid`='30008',`name`='華安縣';
INSERT INTO `base_area` SET `id`='300093',`pid`='30008',`name`='龍海市';
INSERT INTO `base_area` SET `id`='300094',`pid`='30008',`name`='南靖縣';
INSERT INTO `base_area` SET `id`='300095',`pid`='30008',`name`='平和縣';
INSERT INTO `base_area` SET `id`='300096',`pid`='30008',`name`='云霄縣';
INSERT INTO `base_area` SET `id`='300097',`pid`='30008',`name`='漳浦縣';
INSERT INTO `base_area` SET `id`='300098',`pid`='30008',`name`='漳州市';
INSERT INTO `base_area` SET `id`='300099',`pid`='30008',`name`='詔安縣';
#市級4
INSERT INTO `base_area` SET `id`='40000',`pid`='4',`name`='白銀';
INSERT INTO `base_area` SET `id`='40001',`pid`='5',`name`='定西';
INSERT INTO `base_area` SET `id`='40002',`pid`='6',`name`='甘南藏族自治州';
INSERT INTO `base_area` SET `id`='40003',`pid`='7',`name`='嘉峪關';
INSERT INTO `base_area` SET `id`='40004',`pid`='8',`name`='金昌';
INSERT INTO `base_area` SET `id`='40005',`pid`='9',`name`='酒泉';
INSERT INTO `base_area` SET `id`='40006',`pid`='10',`name`='蘭州';
INSERT INTO `base_area` SET `id`='40007',`pid`='11',`name`='臨夏回族自治州';
INSERT INTO `base_area` SET `id`='40008',`pid`='12',`name`='隴南';
INSERT INTO `base_area` SET `id`='40009',`pid`='13',`name`='平涼';
INSERT INTO `base_area` SET `id`='40010',`pid`='14',`name`='慶陽';
INSERT INTO `base_area` SET `id`='40011',`pid`='15',`name`='天水';
INSERT INTO `base_area` SET `id`='40012',`pid`='16',`name`='武威';
INSERT INTO `base_area` SET `id`='40013',`pid`='17',`name`='張掖';
#縣級40000
INSERT INTO `base_area` SET `id`='400010',`pid`='40000',`name`='白銀市';
INSERT INTO `base_area` SET `id`='400011',`pid`='40000',`name`='會寧縣';
INSERT INTO `base_area` SET `id`='400012',`pid`='40000',`name`='景泰縣';
INSERT INTO `base_area` SET `id`='400013',`pid`='40000',`name`='靖遠縣';
#縣級40001
INSERT INTO `base_area` SET `id`='400020',`pid`='40001',`name`='定西縣';
INSERT INTO `base_area` SET `id`='400021',`pid`='40001',`name`='臨洮縣';
INSERT INTO `base_area` SET `id`='400022',`pid`='40001',`name`='隴西縣';
INSERT INTO `base_area` SET `id`='400023',`pid`='40001',`name`='通渭縣';
INSERT INTO `base_area` SET `id`='400024',`pid`='40001',`name`='渭源縣';
INSERT INTO `base_area` SET `id`='400025',`pid`='40001',`name`='漳縣';
INSERT INTO `base_area` SET `id`='400026',`pid`='40001',`name`='岷縣';
#縣級40002
INSERT INTO `base_area` SET `id`='400030',`pid`='40002',`name`='迭部縣';
INSERT INTO `base_area` SET `id`='400031',`pid`='40002',`name`='合作市';
INSERT INTO `base_area` SET `id`='400032',`pid`='40002',`name`='臨潭縣';
INSERT INTO `base_area` SET `id`='400033',`pid`='40002',`name`='碌曲縣';
INSERT INTO `base_area` SET `id`='400034',`pid`='40002',`name`='瑪曲縣';
INSERT INTO `base_area` SET `id`='400035',`pid`='40002',`name`='夏河縣';
INSERT INTO `base_area` SET `id`='400036',`pid`='40002',`name`='舟曲縣';
INSERT INTO `base_area` SET `id`='400037',`pid`='40002',`name`='卓尼縣';
#縣級40003
INSERT INTO `base_area` SET `id`='400040',`pid`='40003',`name`='嘉峪關市';
#縣級40004
INSERT INTO `base_area` SET `id`='400050',`pid`='40004',`name`='金昌市';
INSERT INTO `base_area` SET `id`='400051',`pid`='40004',`name`='永昌縣';
#縣級40005
INSERT INTO `base_area` SET `id`='400060',`pid`='40005',`name`='阿克塞哈薩克族自治縣';
INSERT INTO `base_area` SET `id`='400061',`pid`='40005',`name`='安西縣';
INSERT INTO `base_area` SET `id`='400062',`pid`='40005',`name`='敦煌市';
INSERT INTO `base_area` SET `id`='400063',`pid`='40005',`name`='金塔縣';
INSERT INTO `base_area` SET `id`='400064',`pid`='40005',`name`='酒泉市';
INSERT INTO `base_area` SET `id`='400065',`pid`='40005',`name`='肅北蒙古族自治縣';
INSERT INTO `base_area` SET `id`='400066',`pid`='40005',`name`='玉門市';
#縣級40006
INSERT INTO `base_area` SET `id`='400070',`pid`='40006',`name`='皋蘭縣';
INSERT INTO `base_area` SET `id`='400071',`pid`='40006',`name`='蘭州市';
INSERT INTO `base_area` SET `id`='400072',`pid`='40006',`name`='永登縣';
INSERT INTO `base_area` SET `id`='400073',`pid`='40006',`name`='榆中縣';
#縣級40007
INSERT INTO `base_area` SET `id`='400080',`pid`='40007',`name`='東鄉族自治縣';
INSERT INTO `base_area` SET `id`='400081',`pid`='40007',`name`='廣河縣';
INSERT INTO `base_area` SET `id`='400082',`pid`='40007',`name`='和政縣';
INSERT INTO `base_area` SET `id`='400083',`pid`='40007',`name`='積石山保安族東鄉族撒拉族自治縣';
INSERT INTO `base_area` SET `id`='400084',`pid`='40007',`name`='康樂縣';
INSERT INTO `base_area` SET `id`='400085',`pid`='40007',`name`='臨夏市';
INSERT INTO `base_area` SET `id`='400086',`pid`='40007',`name`='臨夏縣';
INSERT INTO `base_area` SET `id`='400087',`pid`='40007',`name`='永靖縣';
#縣級40008
INSERT INTO `base_area` SET `id`='400090',`pid`='40008',`name`='成縣';
INSERT INTO `base_area` SET `id`='400091',`pid`='40008',`name`='徽縣';
INSERT INTO `base_area` SET `id`='400092',`pid`='40008',`name`='康縣';
INSERT INTO `base_area` SET `id`='400093',`pid`='40008',`name`='禮縣';
INSERT INTO `base_area` SET `id`='400094',`pid`='40008',`name`='兩當縣';
INSERT INTO `base_area` SET `id`='400095',`pid`='40008',`name`='文縣';
INSERT INTO `base_area` SET `id`='400096',`pid`='40008',`name`='武都縣';
INSERT INTO `base_area` SET `id`='400097',`pid`='40008',`name`='西和縣';
INSERT INTO `base_area` SET `id`='400098',`pid`='40008',`name`='宕昌縣';
#縣級40009
INSERT INTO `base_area` SET `id`='400100',`pid`='40009',`name`='崇信縣';
INSERT INTO `base_area` SET `id`='400101',`pid`='40009',`name`='華亭縣';
INSERT INTO `base_area` SET `id`='400102',`pid`='40009',`name`='靜寧縣';
INSERT INTO `base_area` SET `id`='400103',`pid`='40009',`name`='靈臺縣';
INSERT INTO `base_area` SET `id`='400104',`pid`='40009',`name`='平涼市';
INSERT INTO `base_area` SET `id`='400105',`pid`='40009',`name`='莊浪縣';
INSERT INTO `base_area` SET `id`='400106',`pid`='40009',`name`='涇川縣';
#縣級40010
INSERT INTO `base_area` SET `id`='400110',`pid`='40010',`name`='合水縣';
INSERT INTO `base_area` SET `id`='400111',`pid`='40010',`name`='華池縣';
INSERT INTO `base_area` SET `id`='400112',`pid`='40010',`name`='環縣';
INSERT INTO `base_area` SET `id`='400113',`pid`='40010',`name`='寧縣';
INSERT INTO `base_area` SET `id`='400114',`pid`='40010',`name`='慶城縣';
INSERT INTO `base_area` SET `id`='400115',`pid`='40010',`name`='慶陽市';
INSERT INTO `base_area` SET `id`='400116',`pid`='40010',`name`='鎮原縣';
INSERT INTO `base_area` SET `id`='400117',`pid`='40010',`name`='正寧縣';
#縣級40011
INSERT INTO `base_area` SET `id`='400120',`pid`='40011',`name`='甘谷縣';
INSERT INTO `base_area` SET `id`='400121',`pid`='40011',`name`='秦安縣';
INSERT INTO `base_area` SET `id`='400122',`pid`='40011',`name`='清水縣';
INSERT INTO `base_area` SET `id`='400123',`pid`='40011',`name`='天水市';
INSERT INTO `base_area` SET `id`='400124',`pid`='40011',`name`='武山縣';
INSERT INTO `base_area` SET `id`='400125',`pid`='40011',`name`='張家川回族自治縣';
#縣級40012
INSERT INTO `base_area` SET `id`='400130',`pid`='40012',`name`='古浪縣';
INSERT INTO `base_area` SET `id`='400131',`pid`='40012',`name`='民勤縣';
INSERT INTO `base_area` SET `id`='400132',`pid`='40012',`name`='天祝藏族自治縣';
INSERT INTO `base_area` SET `id`='400133',`pid`='40012',`name`='武威市';
#縣級40013
INSERT INTO `base_area` SET `id`='400140',`pid`='40013',`name`='高臺縣';
INSERT INTO `base_area` SET `id`='400141',`pid`='40013',`name`='臨澤縣';
INSERT INTO `base_area` SET `id`='400142',`pid`='40013',`name`='民樂縣';
INSERT INTO `base_area` SET `id`='400143',`pid`='40013',`name`='山丹縣';
INSERT INTO `base_area` SET `id`='400144',`pid`='40013',`name`='肅南裕固族自治縣';
INSERT INTO `base_area` SET `id`='400145',`pid`='40013',`name`='張掖市';
#市級5
INSERT INTO `base_area` SET `id`='50000',`pid`='5',`name`='潮州';
INSERT INTO `base_area` SET `id`='50001',`pid`='6',`name`='東莞';
INSERT INTO `base_area` SET `id`='50002',`pid`='7',`name`='佛山';
INSERT INTO `base_area` SET `id`='50003',`pid`='8',`name`='廣州';
INSERT INTO `base_area` SET `id`='50004',`pid`='9',`name`='河源';
INSERT INTO `base_area` SET `id`='50005',`pid`='10',`name`='惠州';
INSERT INTO `base_area` SET `id`='50006',`pid`='11',`name`='江門';
INSERT INTO `base_area` SET `id`='50007',`pid`='12',`name`='揭陽';
INSERT INTO `base_area` SET `id`='50008',`pid`='13',`name`='茂名';
INSERT INTO `base_area` SET `id`='50009',`pid`='14',`name`='梅州';
INSERT INTO `base_area` SET `id`='50010',`pid`='15',`name`='清遠';
INSERT INTO `base_area` SET `id`='50011',`pid`='16',`name`='汕頭';
INSERT INTO `base_area` SET `id`='50012',`pid`='17',`name`='汕尾';
INSERT INTO `base_area` SET `id`='50013',`pid`='18',`name`='韶關';
INSERT INTO `base_area` SET `id`='50014',`pid`='19',`name`='深圳';
INSERT INTO `base_area` SET `id`='50015',`pid`='20',`name`='陽江';
INSERT INTO `base_area` SET `id`='50016',`pid`='21',`name`='云浮';
INSERT INTO `base_area` SET `id`='50017',`pid`='22',`name`='湛江';
INSERT INTO `base_area` SET `id`='50018',`pid`='23',`name`='肇慶';
INSERT INTO `base_area` SET `id`='50019',`pid`='24',`name`='中山';
INSERT INTO `base_area` SET `id`='50020',`pid`='25',`name`='珠海';
#縣級50000
INSERT INTO `base_area` SET `id`='500010',`pid`='50000',`name`='潮安縣';
INSERT INTO `base_area` SET `id`='500011',`pid`='50000',`name`='潮州市';
INSERT INTO `base_area` SET `id`='500012',`pid`='50000',`name`='饒平縣';
#縣級50001
INSERT INTO `base_area` SET `id`='500020',`pid`='50001',`name`='東莞市';
#縣級50002
INSERT INTO `base_area` SET `id`='500030',`pid`='50002',`name`='佛山市';
#縣級50003
INSERT INTO `base_area` SET `id`='500040',`pid`='50003',`name`='從化市';
INSERT INTO `base_area` SET `id`='500041',`pid`='50003',`name`='廣州市';
INSERT INTO `base_area` SET `id`='500042',`pid`='50003',`name`='增城市';
#縣級50004
INSERT INTO `base_area` SET `id`='500050',`pid`='50004',`name`='東源縣';
INSERT INTO `base_area` SET `id`='500051',`pid`='50004',`name`='和平縣';
INSERT INTO `base_area` SET `id`='500052',`pid`='50004',`name`='河源市';
INSERT INTO `base_area` SET `id`='500053',`pid`='50004',`name`='連平縣';
INSERT INTO `base_area` SET `id`='500054',`pid`='50004',`name`='龍川縣';
INSERT INTO `base_area` SET `id`='500055',`pid`='50004',`name`='紫金縣';
#縣級50005
INSERT INTO `base_area` SET `id`='500060',`pid`='50005',`name`='博羅縣';
INSERT INTO `base_area` SET `id`='500061',`pid`='50005',`name`='惠東縣';
INSERT INTO `base_area` SET `id`='500062',`pid`='50005',`name`='惠陽市';
INSERT INTO `base_area` SET `id`='500063',`pid`='50005',`name`='惠州市';
INSERT INTO `base_area` SET `id`='500064',`pid`='50005',`name`='龍門縣';
#縣級50006
INSERT INTO `base_area` SET `id`='500070',`pid`='50006',`name`='恩平市';
INSERT INTO `base_area` SET `id`='500071',`pid`='50006',`name`='鶴山市';
INSERT INTO `base_area` SET `id`='500072',`pid`='50006',`name`='江門市';
INSERT INTO `base_area` SET `id`='500073',`pid`='50006',`name`='開平市';
INSERT INTO `base_area` SET `id`='500074',`pid`='50006',`name`='臺山市';
#縣級50007
INSERT INTO `base_area` SET `id`='500080',`pid`='50007',`name`='惠來縣';
INSERT INTO `base_area` SET `id`='500081',`pid`='50007',`name`='揭東縣';
INSERT INTO `base_area` SET `id`='500082',`pid`='50007',`name`='揭西縣';
INSERT INTO `base_area` SET `id`='500083',`pid`='50007',`name`='揭陽市';
INSERT INTO `base_area` SET `id`='500084',`pid`='50007',`name`='普寧市';
#縣級50008
INSERT INTO `base_area` SET `id`='500090',`pid`='50008',`name`='電白縣';
INSERT INTO `base_area` SET `id`='500091',`pid`='50008',`name`='高州市';
INSERT INTO `base_area` SET `id`='500092',`pid`='50008',`name`='化州市';
INSERT INTO `base_area` SET `id`='500093',`pid`='50008',`name`='茂名市';
INSERT INTO `base_area` SET `id`='500094',`pid`='50008',`name`='信宜市';
#縣級50009
INSERT INTO `base_area` SET `id`='500100',`pid`='50009',`name`='大埔縣';
INSERT INTO `base_area` SET `id`='500101',`pid`='50009',`name`='豐順縣';
INSERT INTO `base_area` SET `id`='500102',`pid`='50009',`name`='蕉嶺縣';
INSERT INTO `base_area` SET `id`='500103',`pid`='50009',`name`='梅縣';
INSERT INTO `base_area` SET `id`='500104',`pid`='50009',`name`='梅州市';
INSERT INTO `base_area` SET `id`='500105',`pid`='50009',`name`='平遠縣';
INSERT INTO `base_area` SET `id`='500106',`pid`='50009',`name`='五華縣';
INSERT INTO `base_area` SET `id`='500107',`pid`='50009',`name`='興寧市';
#縣級50010
INSERT INTO `base_area` SET `id`='500110',`pid`='50010',`name`='佛岡縣';
INSERT INTO `base_area` SET `id`='500111',`pid`='50010',`name`='連南瑤族自治縣';
INSERT INTO `base_area` SET `id`='500112',`pid`='50010',`name`='連山壯族瑤族自治縣';
INSERT INTO `base_area` SET `id`='500113',`pid`='50010',`name`='連州市';
INSERT INTO `base_area` SET `id`='500114',`pid`='50010',`name`='清新縣';
INSERT INTO `base_area` SET `id`='500115',`pid`='50010',`name`='清遠市';
INSERT INTO `base_area` SET `id`='500116',`pid`='50010',`name`='陽山縣';
INSERT INTO `base_area` SET `id`='500117',`pid`='50010',`name`='英德市';
#縣級50011
INSERT INTO `base_area` SET `id`='500120',`pid`='50011',`name`='潮陽市';
INSERT INTO `base_area` SET `id`='500121',`pid`='50011',`name`='澄海市';
INSERT INTO `base_area` SET `id`='500122',`pid`='50011',`name`='南澳縣';
INSERT INTO `base_area` SET `id`='500123',`pid`='50011',`name`='汕頭市';
#縣級50012
INSERT INTO `base_area` SET `id`='500130',`pid`='50012',`name`='海豐縣';
INSERT INTO `base_area` SET `id`='500131',`pid`='50012',`name`='陸豐市';
INSERT INTO `base_area` SET `id`='500132',`pid`='50012',`name`='陸河縣';
INSERT INTO `base_area` SET `id`='500133',`pid`='50012',`name`='汕尾市';
#縣級50013
INSERT INTO `base_area` SET `id`='500140',`pid`='50013',`name`='樂昌市';
INSERT INTO `base_area` SET `id`='500141',`pid`='50013',`name`='南雄市';
INSERT INTO `base_area` SET `id`='500142',`pid`='50013',`name`='曲江縣';
INSERT INTO `base_area` SET `id`='500143',`pid`='50013',`name`='仁化縣';
INSERT INTO `base_area` SET `id`='500144',`pid`='50013',`name`='乳源瑤族自治縣';
INSERT INTO `base_area` SET `id`='500145',`pid`='50013',`name`='韶關市';
INSERT INTO `base_area` SET `id`='500146',`pid`='50013',`name`='始興縣';
INSERT INTO `base_area` SET `id`='500147',`pid`='50013',`name`='翁源縣';
INSERT INTO `base_area` SET `id`='500148',`pid`='50013',`name`='新豐縣';
#縣級50014
INSERT INTO `base_area` SET `id`='500150',`pid`='50014',`name`='深圳市';
#縣級50015
INSERT INTO `base_area` SET `id`='500160',`pid`='50015',`name`='陽春市';
INSERT INTO `base_area` SET `id`='500161',`pid`='50015',`name`='陽東縣';
INSERT INTO `base_area` SET `id`='500162',`pid`='50015',`name`='陽江市';
INSERT INTO `base_area` SET `id`='500163',`pid`='50015',`name`='陽西縣';
#縣級50016
INSERT INTO `base_area` SET `id`='500170',`pid`='50016',`name`='羅定市';
INSERT INTO `base_area` SET `id`='500171',`pid`='50016',`name`='新興縣';
INSERT INTO `base_area` SET `id`='500172',`pid`='50016',`name`='郁南縣';
INSERT INTO `base_area` SET `id`='500173',`pid`='50016',`name`='云安縣';
INSERT INTO `base_area` SET `id`='500174',`pid`='50016',`name`='云浮市';
#縣級50017
INSERT INTO `base_area` SET `id`='500180',`pid`='50017',`name`='雷州市';
INSERT INTO `base_area` SET `id`='500181',`pid`='50017',`name`='廉江市';
INSERT INTO `base_area` SET `id`='500182',`pid`='50017',`name`='遂溪縣';
INSERT INTO `base_area` SET `id`='500183',`pid`='50017',`name`='吳川市';
INSERT INTO `base_area` SET `id`='500184',`pid`='50017',`name`='徐聞縣';
INSERT INTO `base_area` SET `id`='500185',`pid`='50017',`name`='湛江市';
#縣級50018
INSERT INTO `base_area` SET `id`='500190',`pid`='50018',`name`='德慶縣';
INSERT INTO `base_area` SET `id`='500191',`pid`='50018',`name`='封開縣';
INSERT INTO `base_area` SET `id`='500192',`pid`='50018',`name`='高要市';
INSERT INTO `base_area` SET `id`='500193',`pid`='50018',`name`='廣寧縣';
INSERT INTO `base_area` SET `id`='500194',`pid`='50018',`name`='懷集縣';
INSERT INTO `base_area` SET `id`='500195',`pid`='50018',`name`='四會市';
INSERT INTO `base_area` SET `id`='500196',`pid`='50018',`name`='肇慶市';
#縣級50019
INSERT INTO `base_area` SET `id`='500200',`pid`='50019',`name`='中山市';
#縣級50020
INSERT INTO `base_area` SET `id`='500210',`pid`='50020',`name`='珠海市';
#市級6
INSERT INTO `base_area` SET `id`='60000',`pid`='6',`name`='百色';
INSERT INTO `base_area` SET `id`='60001',`pid`='7',`name`='北海';
INSERT INTO `base_area` SET `id`='60002',`pid`='8',`name`='崇左';
INSERT INTO `base_area` SET `id`='60003',`pid`='9',`name`='防城港';
INSERT INTO `base_area` SET `id`='60004',`pid`='10',`name`='桂林';
INSERT INTO `base_area` SET `id`='60005',`pid`='11',`name`='貴港';
INSERT INTO `base_area` SET `id`='60006',`pid`='12',`name`='河池';
INSERT INTO `base_area` SET `id`='60007',`pid`='13',`name`='賀州';
INSERT INTO `base_area` SET `id`='60008',`pid`='14',`name`='來賓';
INSERT INTO `base_area` SET `id`='60009',`pid`='15',`name`='柳州';
INSERT INTO `base_area` SET `id`='60010',`pid`='16',`name`='南寧';
INSERT INTO `base_area` SET `id`='60011',`pid`='17',`name`='欽州';
INSERT INTO `base_area` SET `id`='60012',`pid`='18',`name`='梧州';
INSERT INTO `base_area` SET `id`='60013',`pid`='19',`name`='玉林';
#縣級60000
INSERT INTO `base_area` SET `id`='600010',`pid`='60000',`name`='百色市';
INSERT INTO `base_area` SET `id`='600011',`pid`='60000',`name`='德?？h';
INSERT INTO `base_area` SET `id`='600012',`pid`='60000',`name`='靖西縣';
INSERT INTO `base_area` SET `id`='600013',`pid`='60000',`name`='樂業縣';
INSERT INTO `base_area` SET `id`='600014',`pid`='60000',`name`='凌云縣';
INSERT INTO `base_area` SET `id`='600015',`pid`='60000',`name`='隆林各族自治縣';
INSERT INTO `base_area` SET `id`='600016',`pid`='60000',`name`='那坡縣';
INSERT INTO `base_area` SET `id`='600017',`pid`='60000',`name`='平果縣';
INSERT INTO `base_area` SET `id`='600018',`pid`='60000',`name`='田東縣';
INSERT INTO `base_area` SET `id`='600019',`pid`='60000',`name`='田林縣';
INSERT INTO `base_area` SET `id`='600020',`pid`='60000',`name`='田陽縣';
INSERT INTO `base_area` SET `id`='600021',`pid`='60000',`name`='西林縣';
#縣級60001
INSERT INTO `base_area` SET `id`='600025',`pid`='60001',`name`='北海市';
INSERT INTO `base_area` SET `id`='600026',`pid`='60001',`name`='合浦縣';
#縣級60002
INSERT INTO `base_area` SET `id`='600030',`pid`='60002',`name`='崇左市';
INSERT INTO `base_area` SET `id`='600031',`pid`='60002',`name`='大新縣';
INSERT INTO `base_area` SET `id`='600032',`pid`='60002',`name`='扶綏縣';
INSERT INTO `base_area` SET `id`='600033',`pid`='60002',`name`='龍州縣';
INSERT INTO `base_area` SET `id`='600034',`pid`='60002',`name`='寧明縣';
INSERT INTO `base_area` SET `id`='600035',`pid`='60002',`name`='憑祥市';
INSERT INTO `base_area` SET `id`='600036',`pid`='60002',`name`='天等縣';
#縣級60003
INSERT INTO `base_area` SET `id`='600040',`pid`='60003',`name`='東興市';
INSERT INTO `base_area` SET `id`='600041',`pid`='60003',`name`='防城港市';
INSERT INTO `base_area` SET `id`='600042',`pid`='60003',`name`='上思縣';
#縣級60004
INSERT INTO `base_area` SET `id`='600050',`pid`='60004',`name`='恭城瑤族自治縣';
INSERT INTO `base_area` SET `id`='600051',`pid`='60004',`name`='灌陽縣';
INSERT INTO `base_area` SET `id`='600052',`pid`='60004',`name`='桂林市';
INSERT INTO `base_area` SET `id`='600053',`pid`='60004',`name`='荔浦縣';
INSERT INTO `base_area` SET `id`='600054',`pid`='60004',`name`='臨桂縣';
INSERT INTO `base_area` SET `id`='600055',`pid`='60004',`name`='靈川縣';
INSERT INTO `base_area` SET `id`='600056',`pid`='60004',`name`='龍勝各族自治縣';
INSERT INTO `base_area` SET `id`='600057',`pid`='60004',`name`='平樂縣';
INSERT INTO `base_area` SET `id`='600058',`pid`='60004',`name`='全州縣';
INSERT INTO `base_area` SET `id`='600059',`pid`='60004',`name`='興安縣';
INSERT INTO `base_area` SET `id`='600060',`pid`='60004',`name`='陽朔縣';
INSERT INTO `base_area` SET `id`='600061',`pid`='60004',`name`='永?？h';
INSERT INTO `base_area` SET `id`='600062',`pid`='60004',`name`='資源縣';
#縣級60005
INSERT INTO `base_area` SET `id`='600066',`pid`='60005',`name`='桂平市';
INSERT INTO `base_area` SET `id`='600067',`pid`='60005',`name`='貴港市';
INSERT INTO `base_area` SET `id`='600068',`pid`='60005',`name`='平南縣';
#縣級60006
INSERT INTO `base_area` SET `id`='600070',`pid`='60006',`name`='巴馬瑤族自治縣';
INSERT INTO `base_area` SET `id`='600071',`pid`='60006',`name`='大化瑤族自治縣';
INSERT INTO `base_area` SET `id`='600072',`pid`='60006',`name`='東蘭縣';
INSERT INTO `base_area` SET `id`='600073',`pid`='60006',`name`='都安瑤族自治縣';
INSERT INTO `base_area` SET `id`='600074',`pid`='60006',`name`='鳳山縣';
INSERT INTO `base_area` SET `id`='600075',`pid`='60006',`name`='河池市';
INSERT INTO `base_area` SET `id`='600076',`pid`='60006',`name`='環江毛南族自治縣';
INSERT INTO `base_area` SET `id`='600077',`pid`='60006',`name`='羅城仡佬族自治縣';
INSERT INTO `base_area` SET `id`='600078',`pid`='60006',`name`='南丹縣';
INSERT INTO `base_area` SET `id`='600079',`pid`='60006',`name`='天峨縣';
INSERT INTO `base_area` SET `id`='600080',`pid`='60006',`name`='宜州市';
#縣級60007
INSERT INTO `base_area` SET `id`='600081',`pid`='60007',`name`='富川瑤族自治縣';
INSERT INTO `base_area` SET `id`='600082',`pid`='60007',`name`='賀州市';
INSERT INTO `base_area` SET `id`='600083',`pid`='60007',`name`='昭平縣';
INSERT INTO `base_area` SET `id`='600084',`pid`='60007',`name`='鐘山縣';
#縣級60008
INSERT INTO `base_area` SET `id`='600090',`pid`='60008',`name`='合山市';
INSERT INTO `base_area` SET `id`='600091',`pid`='60008',`name`='金秀瑤族自治縣';
INSERT INTO `base_area` SET `id`='600092',`pid`='60008',`name`='來賓市';
INSERT INTO `base_area` SET `id`='600093',`pid`='60008',`name`='武宣縣';
INSERT INTO `base_area` SET `id`='600094',`pid`='60008',`name`='象州縣';
INSERT INTO `base_area` SET `id`='600095',`pid`='60008',`name`='忻城縣';
#縣級60009
INSERT INTO `base_area` SET `id`='600100',`pid`='60009',`name`='柳城縣';
INSERT INTO `base_area` SET `id`='600101',`pid`='60009',`name`='柳江縣';
INSERT INTO `base_area` SET `id`='600102',`pid`='60009',`name`='柳州市';
INSERT INTO `base_area` SET `id`='600103',`pid`='60009',`name`='鹿寨縣';
INSERT INTO `base_area` SET `id`='600104',`pid`='60009',`name`='融安縣';
INSERT INTO `base_area` SET `id`='600105',`pid`='60009',`name`='融水苗族自治縣';
INSERT INTO `base_area` SET `id`='600106',`pid`='60009',`name`='三江侗族自治縣';
#縣級60010
INSERT INTO `base_area` SET `id`='600110',`pid`='60010',`name`='賓陽縣';
INSERT INTO `base_area` SET `id`='600111',`pid`='60010',`name`='橫縣';
INSERT INTO `base_area` SET `id`='600112',`pid`='60010',`name`='隆安縣';
INSERT INTO `base_area` SET `id`='600113',`pid`='60010',`name`='馬山縣';
INSERT INTO `base_area` SET `id`='600114',`pid`='60010',`name`='南寧市';
INSERT INTO `base_area` SET `id`='600115',`pid`='60010',`name`='上林縣';
INSERT INTO `base_area` SET `id`='600116',`pid`='60010',`name`='武鳴縣';
INSERT INTO `base_area` SET `id`='600117',`pid`='60010',`name`='邕寧縣';
#縣級60011
INSERT INTO `base_area` SET `id`='600120',`pid`='60011',`name`='靈山縣';
INSERT INTO `base_area` SET `id`='600121',`pid`='60011',`name`='浦北縣';
INSERT INTO `base_area` SET `id`='600122',`pid`='60011',`name`='欽州市';
#縣級60012
INSERT INTO `base_area` SET `id`='600130',`pid`='60012',`name`='蒼梧縣';
INSERT INTO `base_area` SET `id`='600131',`pid`='60012',`name`='蒙山縣';
INSERT INTO `base_area` SET `id`='600132',`pid`='60012',`name`='藤縣';
INSERT INTO `base_area` SET `id`='600133',`pid`='60012',`name`='梧州市';
INSERT INTO `base_area` SET `id`='600134',`pid`='60012',`name`='岑溪市';
#縣級60013
INSERT INTO `base_area` SET `id`='600140',`pid`='60013',`name`='北流市';
INSERT INTO `base_area` SET `id`='600141',`pid`='60013',`name`='博白縣';
INSERT INTO `base_area` SET `id`='600142',`pid`='60013',`name`='陸川縣';
INSERT INTO `base_area` SET `id`='600143',`pid`='60013',`name`='容縣';
INSERT INTO `base_area` SET `id`='600144',`pid`='60013',`name`='興業縣';
INSERT INTO `base_area` SET `id`='600145',`pid`='60013',`name`='玉林市';
#市級7
INSERT INTO `base_area` SET `id`='70000',`pid`='7',`name`='安順';
INSERT INTO `base_area` SET `id`='70001',`pid`='8',`name`='畢節';
INSERT INTO `base_area` SET `id`='70002',`pid`='9',`name`='貴陽';
INSERT INTO `base_area` SET `id`='70003',`pid`='10',`name`='六盤水';
INSERT INTO `base_area` SET `id`='70004',`pid`='11',`name`='黔東南苗族侗族自治州';
INSERT INTO `base_area` SET `id`='70005',`pid`='12',`name`='黔南布依族苗族自治州';
INSERT INTO `base_area` SET `id`='70006',`pid`='13',`name`='黔西南布依族苗族自治州';
INSERT INTO `base_area` SET `id`='70007',`pid`='14',`name`='銅仁';
INSERT INTO `base_area` SET `id`='70008',`pid`='15',`name`='遵義';
#縣級70000
INSERT INTO `base_area` SET `id`='700010',`pid`='70000',`name`='安順市';
INSERT INTO `base_area` SET `id`='700011',`pid`='70000',`name`='關嶺布依族苗族自治縣';
INSERT INTO `base_area` SET `id`='700012',`pid`='70000',`name`='平壩縣';
INSERT INTO `base_area` SET `id`='700013',`pid`='70000',`name`='普定縣';
INSERT INTO `base_area` SET `id`='700014',`pid`='70000',`name`='鎮寧布依族苗族自治縣';
INSERT INTO `base_area` SET `id`='700015',`pid`='70000',`name`='紫云苗族布依族自治縣';
#縣級70001
INSERT INTO `base_area` SET `id`='700020',`pid`='70001',`name`='畢節市';
INSERT INTO `base_area` SET `id`='700021',`pid`='70001',`name`='大方縣';
INSERT INTO `base_area` SET `id`='700022',`pid`='70001',`name`='赫章縣';
INSERT INTO `base_area` SET `id`='700023',`pid`='70001',`name`='金沙縣';
INSERT INTO `base_area` SET `id`='700024',`pid`='70001',`name`='納雍縣';
INSERT INTO `base_area` SET `id`='700025',`pid`='70001',`name`='黔西縣';
INSERT INTO `base_area` SET `id`='700026',`pid`='70001',`name`='威寧彝族回族苗族自治縣';
INSERT INTO `base_area` SET `id`='700027',`pid`='70001',`name`='織金縣';
#縣級70002
INSERT INTO `base_area` SET `id`='700030',`pid`='70002',`name`='貴陽市';
INSERT INTO `base_area` SET `id`='700031',`pid`='70002',`name`='開陽縣';
INSERT INTO `base_area` SET `id`='700032',`pid`='70002',`name`='清鎮市';
INSERT INTO `base_area` SET `id`='700033',`pid`='70002',`name`='息烽縣';
INSERT INTO `base_area` SET `id`='700034',`pid`='70002',`name`='修文縣';
#縣級70003
INSERT INTO `base_area` SET `id`='700040',`pid`='70003',`name`='六盤水市';
INSERT INTO `base_area` SET `id`='700041',`pid`='70003',`name`='六枝特區';
INSERT INTO `base_area` SET `id`='700042',`pid`='70003',`name`='盤縣';
INSERT INTO `base_area` SET `id`='700043',`pid`='70003',`name`='水城縣';
#縣級70004
INSERT INTO `base_area` SET `id`='700044',`pid`='70004',`name`='從江縣';
INSERT INTO `base_area` SET `id`='700045',`pid`='70004',`name`='丹寨縣';
INSERT INTO `base_area` SET `id`='700052',`pid`='70004',`name`='黃平縣';
INSERT INTO `base_area` SET `id`='700053',`pid`='70004',`name`='劍河縣';
INSERT INTO `base_area` SET `id`='700054',`pid`='70004',`name`='錦屏縣';
INSERT INTO `base_area` SET `id`='700055',`pid`='70004',`name`='凱里市';
INSERT INTO `base_area` SET `id`='700056',`pid`='70004',`name`='雷山縣';
INSERT INTO `base_area` SET `id`='700057',`pid`='70004',`name`='黎平縣';
INSERT INTO `base_area` SET `id`='700058',`pid`='70004',`name`='麻江縣';
INSERT INTO `base_area` SET `id`='700059',`pid`='70004',`name`='三穗縣';
INSERT INTO `base_area` SET `id`='700060',`pid`='70004',`name`='施秉縣';
INSERT INTO `base_area` SET `id`='700061',`pid`='70004',`name`='臺江縣';
INSERT INTO `base_area` SET `id`='700062',`pid`='70004',`name`='天柱縣';
INSERT INTO `base_area` SET `id`='700063',`pid`='70004',`name`='鎮遠縣';
INSERT INTO `base_area` SET `id`='700064',`pid`='70004',`name`='岑鞏縣';
INSERT INTO `base_area` SET `id`='700065',`pid`='70004',`name`='榕江縣';
#縣級70005
INSERT INTO `base_area` SET `id`='700060',`pid`='70005',`name`='長順縣';
INSERT INTO `base_area` SET `id`='700061',`pid`='70005',`name`='都勻市';
INSERT INTO `base_area` SET `id`='700062',`pid`='70005',`name`='獨山縣';
INSERT INTO `base_area` SET `id`='700063',`pid`='70005',`name`='福泉市';
INSERT INTO `base_area` SET `id`='700064',`pid`='70005',`name`='貴定縣';
INSERT INTO `base_area` SET `id`='700065',`pid`='70005',`name`='惠水縣';
INSERT INTO `base_area` SET `id`='700066',`pid`='70005',`name`='荔波縣';
INSERT INTO `base_area` SET `id`='700067',`pid`='70005',`name`='龍里縣';
INSERT INTO `base_area` SET `id`='700068',`pid`='70005',`name`='羅甸縣';
INSERT INTO `base_area` SET `id`='700069',`pid`='70005',`name`='平塘縣';
INSERT INTO `base_area` SET `id`='700070',`pid`='70005',`name`='三都水族自治縣';
INSERT INTO `base_area` SET `id`='700071',`pid`='70005',`name`='甕安縣';
#縣級70006
INSERT INTO `base_area` SET `id`='700070',`pid`='70006',`name`='安龍縣';
INSERT INTO `base_area` SET `id`='700071',`pid`='70006',`name`='冊亨縣';
INSERT INTO `base_area` SET `id`='700072',`pid`='70006',`name`='普安縣';
INSERT INTO `base_area` SET `id`='700073',`pid`='70006',`name`='晴隆縣';
INSERT INTO `base_area` SET `id`='700074',`pid`='70006',`name`='望謨縣';
INSERT INTO `base_area` SET `id`='700075',`pid`='70006',`name`='興仁縣';
INSERT INTO `base_area` SET `id`='700076',`pid`='70006',`name`='興義市';
INSERT INTO `base_area` SET `id`='700077',`pid`='70006',`name`='貞豐縣';
#縣級70007
INSERT INTO `base_area` SET `id`='700080',`pid`='70007',`name`='德江縣';
INSERT INTO `base_area` SET `id`='700081',`pid`='70007',`name`='江口縣';
INSERT INTO `base_area` SET `id`='700082',`pid`='70007',`name`='石阡縣';
INSERT INTO `base_area` SET `id`='700083',`pid`='70007',`name`='思南縣';
INSERT INTO `base_area` SET `id`='700084',`pid`='70007',`name`='松桃苗族自治縣';
INSERT INTO `base_area` SET `id`='700085',`pid`='70007',`name`='銅仁市';
INSERT INTO `base_area` SET `id`='700086',`pid`='70007',`name`='萬山特區';
INSERT INTO `base_area` SET `id`='700087',`pid`='70007',`name`='沿河土家族自治縣';
INSERT INTO `base_area` SET `id`='700088',`pid`='70007',`name`='印江土家族苗族自治縣';
INSERT INTO `base_area` SET `id`='700089',`pid`='70007',`name`='玉屏侗族自治縣';
#縣級70008
INSERT INTO `base_area` SET `id`='700090',`pid`='70008',`name`='赤水市';
INSERT INTO `base_area` SET `id`='700091',`pid`='70008',`name`='道真仡佬族苗族自治縣';
INSERT INTO `base_area` SET `id`='700092',`pid`='70008',`name`='鳳岡縣';
INSERT INTO `base_area` SET `id`='700093',`pid`='70008',`name`='仁懷市';
INSERT INTO `base_area` SET `id`='700094',`pid`='70008',`name`='綏陽縣';
INSERT INTO `base_area` SET `id`='700095',`pid`='70008',`name`='桐梓縣';
INSERT INTO `base_area` SET `id`='700096',`pid`='70008',`name`='務川仡佬族苗族自治縣';
INSERT INTO `base_area` SET `id`='700097',`pid`='70008',`name`='習水縣';
INSERT INTO `base_area` SET `id`='700098',`pid`='70008',`name`='余慶縣';
INSERT INTO `base_area` SET `id`='700099',`pid`='70008',`name`='正安縣';
INSERT INTO `base_area` SET `id`='700100',`pid`='70008',`name`='遵義市';
INSERT INTO `base_area` SET `id`='700101',`pid`='70008',`name`='遵義縣';
INSERT INTO `base_area` SET `id`='700102',`pid`='70008',`name`='湄潭縣';
#市級8
INSERT INTO `base_area` SET `id`='80000',`pid`='8',`name`='白沙黎族自治縣';
INSERT INTO `base_area` SET `id`='80001',`pid`='9',`name`='保亭黎族苗族自治縣';
INSERT INTO `base_area` SET `id`='80002',`pid`='10',`name`='昌江黎族自治縣';
INSERT INTO `base_area` SET `id`='80003',`pid`='11',`name`='澄邁縣';
INSERT INTO `base_area` SET `id`='80004',`pid`='12',`name`='定安縣';
INSERT INTO `base_area` SET `id`='80005',`pid`='13',`name`='東方';
INSERT INTO `base_area` SET `id`='80006',`pid`='14',`name`='?？?#39;;
INSERT INTO `base_area` SET `id`='80007',`pid`='15',`name`='樂東黎族自治縣';
INSERT INTO `base_area` SET `id`='80008',`pid`='16',`name`='臨高縣';
INSERT INTO `base_area` SET `id`='80009',`pid`='17',`name`='陵水黎族自治縣';
INSERT INTO `base_area` SET `id`='80010',`pid`='18',`name`='瓊海';
INSERT INTO `base_area` SET `id`='80011',`pid`='19',`name`='瓊中黎族苗族自治縣';
INSERT INTO `base_area` SET `id`='80012',`pid`='20',`name`='三亞';
INSERT INTO `base_area` SET `id`='80013',`pid`='21',`name`='屯昌縣';
INSERT INTO `base_area` SET `id`='80014',`pid`='22',`name`='萬寧';
INSERT INTO `base_area` SET `id`='80015',`pid`='23',`name`='文昌';
INSERT INTO `base_area` SET `id`='80016',`pid`='24',`name`='五指山';
INSERT INTO `base_area` SET `id`='80017',`pid`='25',`name`='儋州';
#縣級80000
INSERT INTO `base_area` SET `id`='800010',`pid`='80000',`name`='白沙黎族自治縣';
#縣級80001
INSERT INTO `base_area` SET `id`='800020',`pid`='80001',`name`='保亭黎族苗族自治縣';
#縣級80002
INSERT INTO `base_area` SET `id`='800030',`pid`='80002',`name`='昌江黎族自治縣';
#縣級80003
INSERT INTO `base_area` SET `id`='800040',`pid`='80003',`name`='澄邁縣';
#縣級80004
INSERT INTO `base_area` SET `id`='800050',`pid`='80004',`name`='定安縣';
#縣級80005
INSERT INTO `base_area` SET `id`='800060',`pid`='80005',`name`='東方市';
#縣級80006
INSERT INTO `base_area` SET `id`='800070',`pid`='80006',`name`='?？谑?#39;;
#縣級80007
INSERT INTO `base_area` SET `id`='800080',`pid`='80007',`name`='樂東黎族自治縣';
#縣級80008
INSERT INTO `base_area` SET `id`='800090',`pid`='80008',`name`='臨高縣';
#縣級80009
INSERT INTO `base_area` SET `id`='800100',`pid`='80009',`name`='陵水黎族自治縣';
#縣級80010
INSERT INTO `base_area` SET `id`='800110',`pid`='80010',`name`='瓊海市';
#縣級80011
INSERT INTO `base_area` SET `id`='800120',`pid`='80011',`name`='瓊中黎族苗族自治縣';
#縣級80012
INSERT INTO `base_area` SET `id`='800130',`pid`='80012',`name`='三亞市';
#縣級80013
INSERT INTO `base_area` SET `id`='800140',`pid`='80013',`name`='屯昌縣';
#縣級80014
INSERT INTO `base_area` SET `id`='800150',`pid`='80014',`name`='萬寧市';
#縣級80015
INSERT INTO `base_area` SET `id`='800160',`pid`='80015',`name`='文昌市';
#縣級80016
INSERT INTO `base_area` SET `id`='800170',`pid`='80016',`name`='五指山市';
#縣級80017
INSERT INTO `base_area` SET `id`='800180',`pid`='80017',`name`='儋州市';
#市級9
INSERT INTO `base_area` SET `id`='90000',`pid`='9',`name`='保定';
INSERT INTO `base_area` SET `id`='90001',`pid`='10',`name`='滄州';
INSERT INTO `base_area` SET `id`='90002',`pid`='11',`name`='承德';
INSERT INTO `base_area` SET `id`='90003',`pid`='12',`name`='邯鄲';
INSERT INTO `base_area` SET `id`='90004',`pid`='13',`name`='衡水';
INSERT INTO `base_area` SET `id`='90005',`pid`='14',`name`='廊坊';
INSERT INTO `base_area` SET `id`='90006',`pid`='15',`name`='秦皇島';
INSERT INTO `base_area` SET `id`='90007',`pid`='16',`name`='石家莊';
INSERT INTO `base_area` SET `id`='90008',`pid`='17',`name`='唐山';
INSERT INTO `base_area` SET `id`='90009',`pid`='18',`name`='邢臺';
INSERT INTO `base_area` SET `id`='90010',`pid`='19',`name`='張家口';
#縣級90000
INSERT INTO `base_area` SET `id`='900010',`pid`='90000',`name`='安國市';
INSERT INTO `base_area` SET `id`='900011',`pid`='90000',`name`='安新縣';
INSERT INTO `base_area` SET `id`='900012',`pid`='90000',`name`='保定市';
INSERT INTO `base_area` SET `id`='900013',`pid`='90000',`name`='博野縣';
INSERT INTO `base_area` SET `id`='900014',`pid`='90000',`name`='定興縣';
INSERT INTO `base_area` SET `id`='900015',`pid`='90000',`name`='定州市';
INSERT INTO `base_area` SET `id`='900016',`pid`='90000',`name`='阜平縣';
INSERT INTO `base_area` SET `id`='900017',`pid`='90000',`name`='高碑店市';
INSERT INTO `base_area` SET `id`='900018',`pid`='90000',`name`='高陽縣';
INSERT INTO `base_area` SET `id`='900019',`pid`='90000',`name`='滿城縣';
INSERT INTO `base_area` SET `id`='900020',`pid`='90000',`name`='清苑縣';
INSERT INTO `base_area` SET `id`='900021',`pid`='90000',`name`='曲陽縣';
INSERT INTO `base_area` SET `id`='900022',`pid`='90000',`name`='容城縣';
INSERT INTO `base_area` SET `id`='900023',`pid`='90000',`name`='順平縣';
INSERT INTO `base_area` SET `id`='900024',`pid`='90000',`name`='唐縣';
INSERT INTO `base_area` SET `id`='900025',`pid`='90000',`name`='望都縣';
INSERT INTO `base_area` SET `id`='900026',`pid`='90000',`name`='雄縣';
INSERT INTO `base_area` SET `id`='900027',`pid`='90000',`name`='徐水縣';
INSERT INTO `base_area` SET `id`='900028',`pid`='90000',`name`='易縣';
INSERT INTO `base_area` SET `id`='900029',`pid`='90000',`name`='淶水縣';
INSERT INTO `base_area` SET `id`='900030',`pid`='90000',`name`='淶源縣';
INSERT INTO `base_area` SET `id`='900031',`pid`='90000',`name`='涿州市';
INSERT INTO `base_area` SET `id`='900032',`pid`='90000',`name`='蠡縣';
#縣級90001
INSERT INTO `base_area` SET `id`='900020',`pid`='90001',`name`='泊頭市';
INSERT INTO `base_area` SET `id`='900021',`pid`='90001',`name`='滄縣';
INSERT INTO `base_area` SET `id`='900022',`pid`='90001',`name`='滄州市';
INSERT INTO `base_area` SET `id`='900023',`pid`='90001',`name`='東光縣';
INSERT INTO `base_area` SET `id`='900024',`pid`='90001',`name`='海興縣';
INSERT INTO `base_area` SET `id`='900025',`pid`='90001',`name`='河間市';
INSERT INTO `base_area` SET `id`='900026',`pid`='90001',`name`='黃驊市';
INSERT INTO `base_area` SET `id`='900027',`pid`='90001',`name`='孟村回族自治縣';
INSERT INTO `base_area` SET `id`='900028',`pid`='90001',`name`='南皮縣';
INSERT INTO `base_area` SET `id`='900029',`pid`='90001',`name`='青縣';
INSERT INTO `base_area` SET `id`='900030',`pid`='90001',`name`='任丘市';
INSERT INTO `base_area` SET `id`='900031',`pid`='90001',`name`='肅寧縣';
INSERT INTO `base_area` SET `id`='900032',`pid`='90001',`name`='吳橋縣';
INSERT INTO `base_area` SET `id`='900033',`pid`='90001',`name`='獻縣';
INSERT INTO `base_area` SET `id`='900034',`pid`='90001',`name`='鹽山縣';
#縣級90002
INSERT INTO `base_area` SET `id`='900030',`pid`='90002',`name`='承德市';
INSERT INTO `base_area` SET `id`='900031',`pid`='90002',`name`='承德縣';
INSERT INTO `base_area` SET `id`='900032',`pid`='90002',`name`='豐寧滿族自治縣';
INSERT INTO `base_area` SET `id`='900033',`pid`='90002',`name`='寬城滿族自治縣';
INSERT INTO `base_area` SET `id`='900034',`pid`='90002',`name`='隆化縣';
INSERT INTO `base_area` SET `id`='900035',`pid`='90002',`name`='灤平縣';
INSERT INTO `base_area` SET `id`='900036',`pid`='90002',`name`='平泉縣';
INSERT INTO `base_area` SET `id`='900037',`pid`='90002',`name`='圍場滿族蒙古族自治縣';
INSERT INTO `base_area` SET `id`='900038',`pid`='90002',`name`='興隆縣';
#縣級90003
INSERT INTO `base_area` SET `id`='900040',`pid`='90003',`name`='成安縣';
INSERT INTO `base_area` SET `id`='900041',`pid`='90003',`name`='磁縣';
INSERT INTO `base_area` SET `id`='900042',`pid`='90003',`name`='大名縣';
INSERT INTO `base_area` SET `id`='900043',`pid`='90003',`name`='肥鄉縣';
INSERT INTO `base_area` SET `id`='900044',`pid`='90003',`name`='館陶縣';
INSERT INTO `base_area` SET `id`='900045',`pid`='90003',`name`='廣平縣';
INSERT INTO `base_area` SET `id`='900046',`pid`='90003',`name`='邯鄲市';
INSERT INTO `base_area` SET `id`='900047',`pid`='90003',`name`='邯鄲縣';
INSERT INTO `base_area` SET `id`='900048',`pid`='90003',`name`='雞澤縣';
INSERT INTO `base_area` SET `id`='900049',`pid`='90003',`name`='臨漳縣';
INSERT INTO `base_area` SET `id`='900050',`pid`='90003',`name`='邱縣';
INSERT INTO `base_area` SET `id`='900051',`pid`='90003',`name`='曲周縣';
INSERT INTO `base_area` SET `id`='900052',`pid`='90003',`name`='涉縣';
INSERT INTO `base_area` SET `id`='900053',`pid`='90003',`name`='魏縣';
INSERT INTO `base_area` SET `id`='900054',`pid`='90003',`name`='武安市';
INSERT INTO `base_area` SET `id`='900055',`pid`='90003',`name`='永年縣';
#縣級90004
INSERT INTO `base_area` SET `id`='900050',`pid`='90004',`name`='安平縣';
INSERT INTO `base_area` SET `id`='900051',`pid`='90004',`name`='阜城縣';
INSERT INTO `base_area` SET `id`='900052',`pid`='90004',`name`='故城縣';
INSERT INTO `base_area` SET `id`='900053',`pid`='90004',`name`='衡水市';
INSERT INTO `base_area` SET `id`='900054',`pid`='90004',`name`='冀州市';
INSERT INTO `base_area` SET `id`='900055',`pid`='90004',`name`='景縣';
INSERT INTO `base_area` SET `id`='900056',`pid`='90004',`name`='饒陽縣';
INSERT INTO `base_area` SET `id`='900057',`pid`='90004',`name`='深州市';
INSERT INTO `base_area` SET `id`='900058',`pid`='90004',`name`='武強縣';
INSERT INTO `base_area` SET `id`='900059',`pid`='90004',`name`='武邑縣';
INSERT INTO `base_area` SET `id`='900060',`pid`='90004',`name`='棗強縣';
#縣級90005
INSERT INTO `base_area` SET `id`='900060',`pid`='90005',`name`='霸州市';
INSERT INTO `base_area` SET `id`='900061',`pid`='90005',`name`='大廠回族自治縣';
INSERT INTO `base_area` SET `id`='900062',`pid`='90005',`name`='大城縣';
INSERT INTO `base_area` SET `id`='900063',`pid`='90005',`name`='固安縣';
INSERT INTO `base_area` SET `id`='900064',`pid`='90005',`name`='廊坊市';
INSERT INTO `base_area` SET `id`='900065',`pid`='90005',`name`='三河市';
INSERT INTO `base_area` SET `id`='900066',`pid`='90005',`name`='文安縣';
INSERT INTO `base_area` SET `id`='900067',`pid`='90005',`name`='香河縣';
INSERT INTO `base_area` SET `id`='900068',`pid`='90005',`name`='永清縣';
#縣級90006
INSERT INTO `base_area` SET `id`='900070',`pid`='90006',`name`='昌黎縣';
INSERT INTO `base_area` SET `id`='900071',`pid`='90006',`name`='撫寧縣';
INSERT INTO `base_area` SET `id`='900072',`pid`='90006',`name`='盧龍縣';
INSERT INTO `base_area` SET `id`='900073',`pid`='90006',`name`='秦皇島市';
INSERT INTO `base_area` SET `id`='900074',`pid`='90006',`name`='青龍滿族自治縣';
#縣級90007
INSERT INTO `base_area` SET `id`='900080',`pid`='90007',`name`='高邑縣';
INSERT INTO `base_area` SET `id`='900081',`pid`='90007',`name`='晉州市';
INSERT INTO `base_area` SET `id`='900082',`pid`='90007',`name`='井陘縣';
INSERT INTO `base_area` SET `id`='900083',`pid`='90007',`name`='靈壽縣';
INSERT INTO `base_area` SET `id`='900084',`pid`='90007',`name`='鹿泉市';
INSERT INTO `base_area` SET `id`='900085',`pid`='90007',`name`='平山縣';
INSERT INTO `base_area` SET `id`='900086',`pid`='90007',`name`='深澤縣';
INSERT INTO `base_area` SET `id`='900087',`pid`='90007',`name`='石家莊市';
INSERT INTO `base_area` SET `id`='900088',`pid`='90007',`name`='無極縣';
INSERT INTO `base_area` SET `id`='900089',`pid`='90007',`name`='辛集市';
INSERT INTO `base_area` SET `id`='900090',`pid`='90007',`name`='新樂市';
INSERT INTO `base_area` SET `id`='900091',`pid`='90007',`name`='行唐縣';
INSERT INTO `base_area` SET `id`='900092',`pid`='90007',`name`='元氏縣';
INSERT INTO `base_area` SET `id`='900093',`pid`='90007',`name`='贊皇縣';
INSERT INTO `base_area` SET `id`='900094',`pid`='90007',`name`='趙縣';
INSERT INTO `base_area` SET `id`='900095',`pid`='90007',`name`='正定縣';
INSERT INTO `base_area` SET `id`='900096',`pid`='90007',`name`='藁城市';
INSERT INTO `base_area` SET `id`='900097',`pid`='90007',`name`='欒城縣';
#縣級90008
INSERT INTO `base_area` SET `id`='900090',`pid`='90008',`name`='樂亭縣';
INSERT INTO `base_area` SET `id`='900091',`pid`='90008',`name`='灤南縣';
INSERT INTO `base_area` SET `id`='900092',`pid`='90008',`name`='灤縣';
INSERT INTO `base_area` SET `id`='900093',`pid`='90008',`name`='遷安市';
INSERT INTO `base_area` SET `id`='900094',`pid`='90008',`name`='遷西縣';
INSERT INTO `base_area` SET `id`='900095',`pid`='90008',`name`='唐?？h';
INSERT INTO `base_area` SET `id`='900096',`pid`='90008',`name`='唐山市';
INSERT INTO `base_area` SET `id`='900097',`pid`='90008',`name`='玉田縣';
INSERT INTO `base_area` SET `id`='900098',`pid`='90008',`name`='遵化市';
#縣級90009
INSERT INTO `base_area` SET `id`='900100',`pid`='90009',`name`='柏鄉縣';
INSERT INTO `base_area` SET `id`='900101',`pid`='90009',`name`='廣宗縣';
INSERT INTO `base_area` SET `id`='900102',`pid`='90009',`name`='巨鹿縣';
INSERT INTO `base_area` SET `id`='900103',`pid`='90009',`name`='臨城縣';
INSERT INTO `base_area` SET `id`='900104',`pid`='90009',`name`='臨西縣';
INSERT INTO `base_area` SET `id`='900105',`pid`='90009',`name`='隆堯縣';
INSERT INTO `base_area` SET `id`='900106',`pid`='90009',`name`='南宮市';
INSERT INTO `base_area` SET `id`='900107',`pid`='90009',`name`='南和縣';
INSERT INTO `base_area` SET `id`='900108',`pid`='90009',`name`='內丘縣';
INSERT INTO `base_area` SET `id`='900109',`pid`='90009',`name`='寧晉縣';
INSERT INTO `base_area` SET `id`='900110',`pid`='90009',`name`='平鄉縣';
INSERT INTO `base_area` SET `id`='900111',`pid`='90009',`name`='清河縣';
INSERT INTO `base_area` SET `id`='900112',`pid`='90009',`name`='任縣';
INSERT INTO `base_area` SET `id`='900113',`pid`='90009',`name`='沙河市';
INSERT INTO `base_area` SET `id`='900114',`pid`='90009',`name`='威縣';
INSERT INTO `base_area` SET `id`='900115',`pid`='90009',`name`='新河縣';
INSERT INTO `base_area` SET `id`='900116',`pid`='90009',`name`='邢臺市';
INSERT INTO `base_area` SET `id`='900117',`pid`='90009',`name`='邢臺縣';
#縣級90010
INSERT INTO `base_area` SET `id`='900110',`pid`='90010',`name`='赤城縣';
INSERT INTO `base_area` SET `id`='900111',`pid`='90010',`name`='崇禮縣';
INSERT INTO `base_area` SET `id`='900112',`pid`='90010',`name`='沽源縣';
INSERT INTO `base_area` SET `id`='900113',`pid`='90010',`name`='懷安縣';
INSERT INTO `base_area` SET `id`='900114',`pid`='90010',`name`='懷來縣';
INSERT INTO `base_area` SET `id`='900115',`pid`='90010',`name`='康?？h';
INSERT INTO `base_area` SET `id`='900116',`pid`='90010',`name`='尚義縣';
INSERT INTO `base_area` SET `id`='900117',`pid`='90010',`name`='萬全縣';
INSERT INTO `base_area` SET `id`='900118',`pid`='90010',`name`='蔚縣';
INSERT INTO `base_area` SET `id`='900119',`pid`='90010',`name`='宣化縣';
INSERT INTO `base_area` SET `id`='900120',`pid`='90010',`name`='陽原縣';
INSERT INTO `base_area` SET `id`='900121',`pid`='90010',`name`='張北縣';
INSERT INTO `base_area` SET `id`='900122',`pid`='90010',`name`='張家口市';
INSERT INTO `base_area` SET `id`='900123',`pid`='90010',`name`='涿鹿縣';
#市級10
INSERT INTO `base_area` SET `id`='100000',`pid`='10',`name`='安陽';
INSERT INTO `base_area` SET `id`='100001',`pid`='11',`name`='鶴壁';
INSERT INTO `base_area` SET `id`='100002',`pid`='12',`name`='濟源';
INSERT INTO `base_area` SET `id`='100003',`pid`='13',`name`='焦作';
INSERT INTO `base_area` SET `id`='100004',`pid`='14',`name`='開封';
INSERT INTO `base_area` SET `id`='100005',`pid`='15',`name`='洛陽';
INSERT INTO `base_area` SET `id`='100006',`pid`='16',`name`='南陽';
INSERT INTO `base_area` SET `id`='100007',`pid`='17',`name`='平頂山';
INSERT INTO `base_area` SET `id`='100008',`pid`='18',`name`='三門峽';
INSERT INTO `base_area` SET `id`='100009',`pid`='19',`name`='商丘';
INSERT INTO `base_area` SET `id`='100010',`pid`='20',`name`='新鄉';
INSERT INTO `base_area` SET `id`='100011',`pid`='21',`name`='信陽';
INSERT INTO `base_area` SET `id`='100012',`pid`='22',`name`='許昌';
INSERT INTO `base_area` SET `id`='100013',`pid`='23',`name`='鄭州';
INSERT INTO `base_area` SET `id`='100014',`pid`='24',`name`='周口';
INSERT INTO `base_area` SET `id`='100015',`pid`='25',`name`='駐馬店';
INSERT INTO `base_area` SET `id`='100016',`pid`='26',`name`='漯河';
INSERT INTO `base_area` SET `id`='100017',`pid`='27',`name`='濮陽';
#縣級100000
INSERT INTO `base_area` SET `id`='1000010',`pid`='100000',`name`='安陽市';
INSERT INTO `base_area` SET `id`='1000011',`pid`='100000',`name`='安陽縣';
INSERT INTO `base_area` SET `id`='1000012',`pid`='100000',`name`='滑縣';
INSERT INTO `base_area` SET `id`='1000013',`pid`='100000',`name`='林州市';
INSERT INTO `base_area` SET `id`='1000014',`pid`='100000',`name`='內黃縣';
INSERT INTO `base_area` SET `id`='1000015',`pid`='100000',`name`='湯陰縣';
#縣級100001
INSERT INTO `base_area` SET `id`='1000020',`pid`='100001',`name`='';
INSERT INTO `base_area` SET `id`='1000021',`pid`='100001',`name`='鶴壁市';
INSERT INTO `base_area` SET `id`='1000022',`pid`='100001',`name`='?？h';
INSERT INTO `base_area` SET `id`='1000023',`pid`='100001',`name`='淇縣';
#縣級100002
INSERT INTO `base_area` SET `id`='1000030',`pid`='100002',`name`='濟源市';
#縣級100003
INSERT INTO `base_area` SET `id`='1000040',`pid`='100003',`name`='博愛縣';
INSERT INTO `base_area` SET `id`='1000041',`pid`='100003',`name`='焦作市';
INSERT INTO `base_area` SET `id`='1000042',`pid`='100003',`name`='孟州市';
INSERT INTO `base_area` SET `id`='1000043',`pid`='100003',`name`='沁陽市';
INSERT INTO `base_area` SET `id`='1000044',`pid`='100003',`name`='溫縣';
INSERT INTO `base_area` SET `id`='1000045',`pid`='100003',`name`='武陟縣';
INSERT INTO `base_area` SET `id`='1000046',`pid`='100003',`name`='修武縣';
#縣級100004
INSERT INTO `base_area` SET `id`='1000050',`pid`='100004',`name`='開封市';
INSERT INTO `base_area` SET `id`='1000051',`pid`='100004',`name`='開封縣';
INSERT INTO `base_area` SET `id`='1000052',`pid`='100004',`name`='蘭考縣';
INSERT INTO `base_area` SET `id`='1000053',`pid`='100004',`name`='通許縣';
INSERT INTO `base_area` SET `id`='1000054',`pid`='100004',`name`='尉氏縣';
INSERT INTO `base_area` SET `id`='1000055',`pid`='100004',`name`='杞縣';
#縣級100005
INSERT INTO `base_area` SET `id`='1000060',`pid`='100005',`name`='洛寧縣';
INSERT INTO `base_area` SET `id`='1000061',`pid`='100005',`name`='洛陽市';
INSERT INTO `base_area` SET `id`='1000062',`pid`='100005',`name`='孟津縣';
INSERT INTO `base_area` SET `id`='1000063',`pid`='100005',`name`='汝陽縣';
INSERT INTO `base_area` SET `id`='1000064',`pid`='100005',`name`='新安縣';
INSERT INTO `base_area` SET `id`='1000065',`pid`='100005',`name`='伊川縣';
INSERT INTO `base_area` SET `id`='1000066',`pid`='100005',`name`='宜陽縣';
INSERT INTO `base_area` SET `id`='1000067',`pid`='100005',`name`='偃師市';
INSERT INTO `base_area` SET `id`='1000068',`pid`='100005',`name`='嵩縣';
INSERT INTO `base_area` SET `id`='1000069',`pid`='100005',`name`='欒川縣';
#縣級100006
INSERT INTO `base_area` SET `id`='1000070',`pid`='100006',`name`='鄧州市';
INSERT INTO `base_area` SET `id`='1000071',`pid`='100006',`name`='方城縣';
INSERT INTO `base_area` SET `id`='1000072',`pid`='100006',`name`='南陽市';
INSERT INTO `base_area` SET `id`='1000073',`pid`='100006',`name`='南召縣';
INSERT INTO `base_area` SET `id`='1000074',`pid`='100006',`name`='內鄉縣';
INSERT INTO `base_area` SET `id`='1000075',`pid`='100006',`name`='社旗縣';
INSERT INTO `base_area` SET `id`='1000076',`pid`='100006',`name`='唐河縣';
INSERT INTO `base_area` SET `id`='1000077',`pid`='100006',`name`='桐柏縣';
INSERT INTO `base_area` SET `id`='1000078',`pid`='100006',`name`='西峽縣';
INSERT INTO `base_area` SET `id`='1000079',`pid`='100006',`name`='新野縣';
INSERT INTO `base_area` SET `id`='1000080',`pid`='100006',`name`='鎮平縣';
INSERT INTO `base_area` SET `id`='1000081',`pid`='100006',`name`='淅川縣';
#縣級100007
INSERT INTO `base_area` SET `id`='1000080',`pid`='100007',`name`='寶豐縣';
INSERT INTO `base_area` SET `id`='1000081',`pid`='100007',`name`='魯山縣';
INSERT INTO `base_area` SET `id`='1000082',`pid`='100007',`name`='平頂山市';
INSERT INTO `base_area` SET `id`='1000083',`pid`='100007',`name`='汝州市';
INSERT INTO `base_area` SET `id`='1000084',`pid`='100007',`name`='舞鋼市';
INSERT INTO `base_area` SET `id`='1000085',`pid`='100007',`name`='葉縣';
INSERT INTO `base_area` SET `id`='1000086',`pid`='100007',`name`='郟縣';
#縣級100008
INSERT INTO `base_area` SET `id`='1000090',`pid`='100008',`name`='靈寶市';
INSERT INTO `base_area` SET `id`='1000091',`pid`='100008',`name`='盧氏縣';
INSERT INTO `base_area` SET `id`='1000092',`pid`='100008',`name`='三門峽市';
INSERT INTO `base_area` SET `id`='1000093',`pid`='100008',`name`='陜縣';
INSERT INTO `base_area` SET `id`='1000094',`pid`='100008',`name`='義馬市';
INSERT INTO `base_area` SET `id`='1000095',`pid`='100008',`name`='澠池縣';
#縣級100009
INSERT INTO `base_area` SET `id`='1000100',`pid`='100009',`name`='民權縣';
INSERT INTO `base_area` SET `id`='1000101',`pid`='100009',`name`='寧陵縣';
INSERT INTO `base_area` SET `id`='1000102',`pid`='100009',`name`='商丘市';
INSERT INTO `base_area` SET `id`='1000103',`pid`='100009',`name`='夏邑縣';
INSERT INTO `base_area` SET `id`='1000104',`pid`='100009',`name`='永城市';
INSERT INTO `base_area` SET `id`='1000105',`pid`='100009',`name`='虞城縣';
INSERT INTO `base_area` SET `id`='1000106',`pid`='100009',`name`='柘城縣';
INSERT INTO `base_area` SET `id`='1000107',`pid`='100009',`name`='睢縣';
#縣級100010
INSERT INTO `base_area` SET `id`='1000110',`pid`='100010',`name`='長垣縣';
INSERT INTO `base_area` SET `id`='1000111',`pid`='100010',`name`='封丘縣';
INSERT INTO `base_area` SET `id`='1000112',`pid`='100010',`name`='輝縣市';
INSERT INTO `base_area` SET `id`='1000113',`pid`='100010',`name`='獲嘉縣';
INSERT INTO `base_area` SET `id`='1000114',`pid`='100010',`name`='衛輝市';
INSERT INTO `base_area` SET `id`='1000115',`pid`='100010',`name`='新鄉市';
INSERT INTO `base_area` SET `id`='1000116',`pid`='100010',`name`='新鄉縣';
INSERT INTO `base_area` SET `id`='1000117',`pid`='100010',`name`='延津縣';
INSERT INTO `base_area` SET `id`='1000118',`pid`='100010',`name`='原陽縣';
#縣級100011
INSERT INTO `base_area` SET `id`='1000120',`pid`='100011',`name`='固始縣';
INSERT INTO `base_area` SET `id`='1000121',`pid`='100011',`name`='光山縣';
INSERT INTO `base_area` SET `id`='1000122',`pid`='100011',`name`='淮濱縣';
INSERT INTO `base_area` SET `id`='1000123',`pid`='100011',`name`='羅山縣';
INSERT INTO `base_area` SET `id`='1000124',`pid`='100011',`name`='商城縣';
INSERT INTO `base_area` SET `id`='1000125',`pid`='100011',`name`='息縣';
INSERT INTO `base_area` SET `id`='1000126',`pid`='100011',`name`='新縣';
INSERT INTO `base_area` SET `id`='1000127',`pid`='100011',`name`='信陽市';
INSERT INTO `base_area` SET `id`='1000128',`pid`='100011',`name`='潢川縣';
#縣級100012
INSERT INTO `base_area` SET `id`='1000130',`pid`='100012',`name`='長葛市';
INSERT INTO `base_area` SET `id`='1000131',`pid`='100012',`name`='襄城縣';
INSERT INTO `base_area` SET `id`='1000132',`pid`='100012',`name`='許昌市';
INSERT INTO `base_area` SET `id`='1000133',`pid`='100012',`name`='許昌縣';
INSERT INTO `base_area` SET `id`='1000134',`pid`='100012',`name`='禹州市';
INSERT INTO `base_area` SET `id`='1000135',`pid`='100012',`name`='鄢陵縣';
#縣級100013
INSERT INTO `base_area` SET `id`='1000140',`pid`='100013',`name`='登封市';
INSERT INTO `base_area` SET `id`='1000141',`pid`='100013',`name`='鞏義市';
INSERT INTO `base_area` SET `id`='1000142',`pid`='100013',`name`='新密市';
INSERT INTO `base_area` SET `id`='1000143',`pid`='100013',`name`='新鄭市';
INSERT INTO `base_area` SET `id`='1000144',`pid`='100013',`name`='鄭州市';
INSERT INTO `base_area` SET `id`='1000145',`pid`='100013',`name`='中牟縣';
INSERT INTO `base_area` SET `id`='1000146',`pid`='100013',`name`='滎陽市';
#縣級100014
INSERT INTO `base_area` SET `id`='1000150',`pid`='100014',`name`='鄲城縣';
INSERT INTO `base_area` SET `id`='1000151',`pid`='100014',`name`='扶溝縣';
INSERT INTO `base_area` SET `id`='1000152',`pid`='100014',`name`='淮陽縣';
INSERT INTO `base_area` SET `id`='1000153',`pid`='100014',`name`='鹿邑縣';
INSERT INTO `base_area` SET `id`='1000154',`pid`='100014',`name`='商水縣';
INSERT INTO `base_area` SET `id`='1000155',`pid`='100014',`name`='沈丘縣';
INSERT INTO `base_area` SET `id`='1000156',`pid`='100014',`name`='太康縣';
INSERT INTO `base_area` SET `id`='1000157',`pid`='100014',`name`='西華縣';
INSERT INTO `base_area` SET `id`='1000158',`pid`='100014',`name`='項城市';
INSERT INTO `base_area` SET `id`='1000159',`pid`='100014',`name`='周口市';
#縣級100015
INSERT INTO `base_area` SET `id`='1000160',`pid`='100015',`name`='泌陽縣';
INSERT INTO `base_area` SET `id`='1000161',`pid`='100015',`name`='平輿縣';
INSERT INTO `base_area` SET `id`='1000162',`pid`='100015',`name`='確山縣';
INSERT INTO `base_area` SET `id`='1000163',`pid`='100015',`name`='汝南縣';
INSERT INTO `base_area` SET `id`='1000164',`pid`='100015',`name`='上蔡縣';
INSERT INTO `base_area` SET `id`='1000165',`pid`='100015',`name`='遂平縣';
INSERT INTO `base_area` SET `id`='1000166',`pid`='100015',`name`='西平縣';
INSERT INTO `base_area` SET `id`='1000167',`pid`='100015',`name`='新蔡縣';
INSERT INTO `base_area` SET `id`='1000168',`pid`='100015',`name`='正陽縣';
INSERT INTO `base_area` SET `id`='1000169',`pid`='100015',`name`='駐馬店市';
#縣級100016
INSERT INTO `base_area` SET `id`='1000170',`pid`='100016',`name`='臨潁縣';
INSERT INTO `base_area` SET `id`='1000171',`pid`='100016',`name`='舞陽縣';
INSERT INTO `base_area` SET `id`='1000172',`pid`='100016',`name`='郾城縣';
INSERT INTO `base_area` SET `id`='1000173',`pid`='100016',`name`='漯河市';
#縣級100017
INSERT INTO `base_area` SET `id`='1000180',`pid`='100017',`name`='范縣';
INSERT INTO `base_area` SET `id`='1000181',`pid`='100017',`name`='南樂縣';
INSERT INTO `base_area` SET `id`='1000182',`pid`='100017',`name`='清豐縣';
INSERT INTO `base_area` SET `id`='1000183',`pid`='100017',`name`='臺前縣';
INSERT INTO `base_area` SET `id`='1000184',`pid`='100017',`name`='濮陽市';
INSERT INTO `base_area` SET `id`='1000185',`pid`='100017',`name`='濮陽縣';
#市級11
INSERT INTO `base_area` SET `id`='110000',`pid`='11',`name`='大慶';
INSERT INTO `base_area` SET `id`='110001',`pid`='12',`name`='大興安嶺';
INSERT INTO `base_area` SET `id`='110002',`pid`='13',`name`='哈爾濱';
INSERT INTO `base_area` SET `id`='110003',`pid`='14',`name`='鶴崗';
INSERT INTO `base_area` SET `id`='110004',`pid`='15',`name`='黑河';
INSERT INTO `base_area` SET `id`='110005',`pid`='16',`name`='雞西';
INSERT INTO `base_area` SET `id`='110006',`pid`='17',`name`='佳木斯';
INSERT INTO `base_area` SET `id`='110007',`pid`='18',`name`='牡丹江';
INSERT INTO `base_area` SET `id`='110008',`pid`='19',`name`='七臺河';
INSERT INTO `base_area` SET `id`='110009',`pid`='20',`name`='齊齊哈爾';
INSERT INTO `base_area` SET `id`='110010',`pid`='21',`name`='雙鴨山';
INSERT INTO `base_area` SET `id`='110011',`pid`='22',`name`='綏化';
INSERT INTO `base_area` SET `id`='110012',`pid`='23',`name`='伊春';
#縣級110000
INSERT INTO `base_area` SET `id`='1100010',`pid`='110000',`name`='大慶市';
INSERT INTO `base_area` SET `id`='1100011',`pid`='110000',`name`='杜爾伯特蒙古族自治縣';
INSERT INTO `base_area` SET `id`='1100012',`pid`='110000',`name`='林甸縣';
INSERT INTO `base_area` SET `id`='1100013',`pid`='110000',`name`='肇源縣';
INSERT INTO `base_area` SET `id`='1100014',`pid`='110000',`name`='肇州縣';
#縣級110001
INSERT INTO `base_area` SET `id`='1100020',`pid`='110001',`name`='呼瑪縣';
INSERT INTO `base_area` SET `id`='1100021',`pid`='110001',`name`='漠河縣';
INSERT INTO `base_area` SET `id`='1100022',`pid`='110001',`name`='塔河縣';
#縣級110002
INSERT INTO `base_area` SET `id`='1100030',`pid`='110002',`name`='阿城市';
INSERT INTO `base_area` SET `id`='1100031',`pid`='110002',`name`='巴彥縣';
INSERT INTO `base_area` SET `id`='1100032',`pid`='110002',`name`='賓縣';
INSERT INTO `base_area` SET `id`='1100033',`pid`='110002',`name`='方正縣';
INSERT INTO `base_area` SET `id`='1100034',`pid`='110002',`name`='哈爾濱市';
INSERT INTO `base_area` SET `id`='1100035',`pid`='110002',`name`='呼蘭縣';
INSERT INTO `base_area` SET `id`='1100036',`pid`='110002',`name`='木蘭縣';
INSERT INTO `base_area` SET `id`='1100037',`pid`='110002',`name`='尚志市';
INSERT INTO `base_area` SET `id`='1100038',`pid`='110002',`name`='雙城市';
INSERT INTO `base_area` SET `id`='1100039',`pid`='110002',`name`='通河縣';
INSERT INTO `base_area` SET `id`='1100040',`pid`='110002',`name`='五常市';
INSERT INTO `base_area` SET `id`='1100041',`pid`='110002',`name`='延壽縣';
INSERT INTO `base_area` SET `id`='1100042',`pid`='110002',`name`='依蘭縣';
#縣級110003
INSERT INTO `base_area` SET `id`='1100040',`pid`='110003',`name`='鶴崗市';
INSERT INTO `base_area` SET `id`='1100041',`pid`='110003',`name`='蘿北縣';
INSERT INTO `base_area` SET `id`='1100042',`pid`='110003',`name`='綏濱縣';
#縣級110004
INSERT INTO `base_area` SET `id`='1100050',`pid`='110004',`name`='北安市';
INSERT INTO `base_area` SET `id`='1100051',`pid`='110004',`name`='黑河市';
INSERT INTO `base_area` SET `id`='1100052',`pid`='110004',`name`='嫩江縣';
INSERT INTO `base_area` SET `id`='1100053',`pid`='110004',`name`='孫吳縣';
INSERT INTO `base_area` SET `id`='1100054',`pid`='110004',`name`='五大連池市';
INSERT INTO `base_area` SET `id`='1100055',`pid`='110004',`name`='遜克縣';
#縣級110005
INSERT INTO `base_area` SET `id`='1100060',`pid`='110005',`name`='虎林市';
INSERT INTO `base_area` SET `id`='1100061',`pid`='110005',`name`='雞東縣';
INSERT INTO `base_area` SET `id`='1100062',`pid`='110005',`name`='雞西市';
INSERT INTO `base_area` SET `id`='1100063',`pid`='110005',`name`='密山市';
#縣級110006
INSERT INTO `base_area` SET `id`='1100070',`pid`='110006',`name`='撫遠縣';
INSERT INTO `base_area` SET `id`='1100071',`pid`='110006',`name`='富錦市';
INSERT INTO `base_area` SET `id`='1100072',`pid`='110006',`name`='佳木斯市';
INSERT INTO `base_area` SET `id`='1100073',`pid`='110006',`name`='湯原縣';
INSERT INTO `base_area` SET `id`='1100074',`pid`='110006',`name`='同江市';
INSERT INTO `base_area` SET `id`='1100075',`pid`='110006',`name`='樺川縣';
INSERT INTO `base_area` SET `id`='1100076',`pid`='110006',`name`='樺南縣';
#縣級110007
INSERT INTO `base_area` SET `id`='1100080',`pid`='110007',`name`='東寧縣';
INSERT INTO `base_area` SET `id`='1100081',`pid`='110007',`name`='海林市';
INSERT INTO `base_area` SET `id`='1100082',`pid`='110007',`name`='林口縣';
INSERT INTO `base_area` SET `id`='1100083',`pid`='110007',`name`='牡丹江市';
INSERT INTO `base_area` SET `id`='1100084',`pid`='110007',`name`='穆棱市';
INSERT INTO `base_area` SET `id`='1100085',`pid`='110007',`name`='寧安市';
INSERT INTO `base_area` SET `id`='1100086',`pid`='110007',`name`='綏芬河市';
#縣級110008
INSERT INTO `base_area` SET `id`='1100090',`pid`='110008',`name`='勃利縣';
INSERT INTO `base_area` SET `id`='1100091',`pid`='110008',`name`='七臺河市';
#縣級110009
INSERT INTO `base_area` SET `id`='1100100',`pid`='110009',`name`='拜泉縣';
INSERT INTO `base_area` SET `id`='1100101',`pid`='110009',`name`='富裕縣';
INSERT INTO `base_area` SET `id`='1100102',`pid`='110009',`name`='甘南縣';
INSERT INTO `base_area` SET `id`='1100103',`pid`='110009',`name`='克東縣';
INSERT INTO `base_area` SET `id`='1100104',`pid`='110009',`name`='克山縣';
INSERT INTO `base_area` SET `id`='1100105',`pid`='110009',`name`='龍江縣';
INSERT INTO `base_area` SET `id`='1100106',`pid`='110009',`name`='齊齊哈爾市';
INSERT INTO `base_area` SET `id`='1100107',`pid`='110009',`name`='泰來縣';
INSERT INTO `base_area` SET `id`='1100108',`pid`='110009',`name`='依安縣';
INSERT INTO `base_area` SET `id`='1100109',`pid`='110009',`name`='訥河市';
#縣級110010
INSERT INTO `base_area` SET `id`='1100110',`pid`='110010',`name`='寶清縣';
INSERT INTO `base_area` SET `id`='1100111',`pid`='110010',`name`='集賢縣';
INSERT INTO `base_area` SET `id`='1100112',`pid`='110010',`name`='饒河縣';
INSERT INTO `base_area` SET `id`='1100113',`pid`='110010',`name`='雙鴨山市';
INSERT INTO `base_area` SET `id`='1100114',`pid`='110010',`name`='友誼縣';
#縣級110011
INSERT INTO `base_area` SET `id`='1100120',`pid`='110011',`name`='安達市';
INSERT INTO `base_area` SET `id`='1100121',`pid`='110011',`name`='海倫市';
INSERT INTO `base_area` SET `id`='1100122',`pid`='110011',`name`='蘭西縣';
INSERT INTO `base_area` SET `id`='1100123',`pid`='110011',`name`='明水縣';
INSERT INTO `base_area` SET `id`='1100124',`pid`='110011',`name`='青岡縣';
INSERT INTO `base_area` SET `id`='1100125',`pid`='110011',`name`='慶安縣';
INSERT INTO `base_area` SET `id`='1100126',`pid`='110011',`name`='綏化市';
INSERT INTO `base_area` SET `id`='1100127',`pid`='110011',`name`='綏棱縣';
INSERT INTO `base_area` SET `id`='1100128',`pid`='110011',`name`='望奎縣';
INSERT INTO `base_area` SET `id`='1100129',`pid`='110011',`name`='肇東市';
#縣級110012
INSERT INTO `base_area` SET `id`='1100130',`pid`='110012',`name`='嘉蔭縣';
INSERT INTO `base_area` SET `id`='1100131',`pid`='110012',`name`='鐵力市';
INSERT INTO `base_area` SET `id`='1100132',`pid`='110012',`name`='伊春市';
#市級12
INSERT INTO `base_area` SET `id`='120000',`pid`='12',`name`='鄂州';
INSERT INTO `base_area` SET `id`='120001',`pid`='13',`name`='恩施土家族苗族自治州';
INSERT INTO `base_area` SET `id`='120002',`pid`='14',`name`='黃岡';
INSERT INTO `base_area` SET `id`='120003',`pid`='15',`name`='黃石';
INSERT INTO `base_area` SET `id`='120004',`pid`='16',`name`='荊門';
INSERT INTO `base_area` SET `id`='120005',`pid`='17',`name`='荊州';
INSERT INTO `base_area` SET `id`='120006',`pid`='18',`name`='潛江';
INSERT INTO `base_area` SET `id`='120007',`pid`='19',`name`='神農架林區';
INSERT INTO `base_area` SET `id`='120008',`pid`='20',`name`='十堰';
INSERT INTO `base_area` SET `id`='120009',`pid`='21',`name`='隨州';
INSERT INTO `base_area` SET `id`='120010',`pid`='22',`name`='天門';
INSERT INTO `base_area` SET `id`='120011',`pid`='23',`name`='武漢';
INSERT INTO `base_area` SET `id`='120012',`pid`='24',`name`='仙桃';
INSERT INTO `base_area` SET `id`='120013',`pid`='25',`name`='咸寧';
INSERT INTO `base_area` SET `id`='120014',`pid`='26',`name`='襄樊';
INSERT INTO `base_area` SET `id`='120015',`pid`='27',`name`='孝感';
INSERT INTO `base_area` SET `id`='120016',`pid`='28',`name`='宜昌';
#縣級120000
INSERT INTO `base_area` SET `id`='1200010',`pid`='120000',`name`='鄂州市';
#縣級120001
INSERT INTO `base_area` SET `id`='1200020',`pid`='120001',`name`='巴東縣';
INSERT INTO `base_area` SET `id`='1200021',`pid`='120001',`name`='恩施市';
INSERT INTO `base_area` SET `id`='1200022',`pid`='120001',`name`='鶴峰縣';
INSERT INTO `base_area` SET `id`='1200023',`pid`='120001',`name`='建始縣';
INSERT INTO `base_area` SET `id`='1200024',`pid`='120001',`name`='來鳳縣';
INSERT INTO `base_area` SET `id`='1200025',`pid`='120001',`name`='利川市';
INSERT INTO `base_area` SET `id`='1200026',`pid`='120001',`name`='咸豐縣';
INSERT INTO `base_area` SET `id`='1200027',`pid`='120001',`name`='宣恩縣';
#縣級120002
INSERT INTO `base_area` SET `id`='1200030',`pid`='120002',`name`='紅安縣';
INSERT INTO `base_area` SET `id`='1200031',`pid`='120002',`name`='黃岡市';
INSERT INTO `base_area` SET `id`='1200032',`pid`='120002',`name`='黃梅縣';
INSERT INTO `base_area` SET `id`='1200033',`pid`='120002',`name`='羅田縣';
INSERT INTO `base_area` SET `id`='1200034',`pid`='120002',`name`='麻城市';
INSERT INTO `base_area` SET `id`='1200035',`pid`='120002',`name`='團風縣';
INSERT INTO `base_area` SET `id`='1200036',`pid`='120002',`name`='武穴市';
INSERT INTO `base_area` SET `id`='1200037',`pid`='120002',`name`='英山縣';
INSERT INTO `base_area` SET `id`='1200038',`pid`='120002',`name`='蘄春縣';
INSERT INTO `base_area` SET `id`='1200039',`pid`='120002',`name`='浠水縣';
#縣級120003
INSERT INTO `base_area` SET `id`='1200040',`pid`='120003',`name`='大冶市';
INSERT INTO `base_area` SET `id`='1200041',`pid`='120003',`name`='黃石市';
INSERT INTO `base_area` SET `id`='1200042',`pid`='120003',`name`='陽新縣';
#縣級120004
INSERT INTO `base_area` SET `id`='1200050',`pid`='120004',`name`='荊門市';
INSERT INTO `base_area` SET `id`='1200051',`pid`='120004',`name`='京山縣';
INSERT INTO `base_area` SET `id`='1200052',`pid`='120004',`name`='沙洋縣';
INSERT INTO `base_area` SET `id`='1200053',`pid`='120004',`name`='鐘祥市';
#縣級120005
INSERT INTO `base_area` SET `id`='1200060',`pid`='120005',`name`='公安縣';
INSERT INTO `base_area` SET `id`='1200061',`pid`='120005',`name`='洪湖市';
INSERT INTO `base_area` SET `id`='1200062',`pid`='120005',`name`='監利縣';
INSERT INTO `base_area` SET `id`='1200063',`pid`='120005',`name`='江陵縣';
INSERT INTO `base_area` SET `id`='1200064',`pid`='120005',`name`='荊州市';
INSERT INTO `base_area` SET `id`='1200065',`pid`='120005',`name`='石首市';
INSERT INTO `base_area` SET `id`='1200066',`pid`='120005',`name`='松滋市';
#縣級120006
INSERT INTO `base_area` SET `id`='1200070',`pid`='120006',`name`='潛江市';
#縣級120007
INSERT INTO `base_area` SET `id`='1200080',`pid`='120007',`name`='神農架林區';
#縣級120008
INSERT INTO `base_area` SET `id`='1200090',`pid`='120008',`name`='丹江口市';
INSERT INTO `base_area` SET `id`='1200091',`pid`='120008',`name`='房縣';
INSERT INTO `base_area` SET `id`='1200092',`pid`='120008',`name`='十堰市';
INSERT INTO `base_area` SET `id`='1200093',`pid`='120008',`name`='鄖西縣';
INSERT INTO `base_area` SET `id`='1200094',`pid`='120008',`name`='鄖縣';
INSERT INTO `base_area` SET `id`='1200095',`pid`='120008',`name`='竹山縣';
INSERT INTO `base_area` SET `id`='1200096',`pid`='120008',`name`='竹溪縣';
#縣級120009
INSERT INTO `base_area` SET `id`='1200100',`pid`='120009',`name`='廣水市';
INSERT INTO `base_area` SET `id`='1200101',`pid`='120009',`name`='隨州市';
#縣級120010
INSERT INTO `base_area` SET `id`='1200110',`pid`='120010',`name`='天門市';
#縣級120011
INSERT INTO `base_area` SET `id`='1200120',`pid`='120011',`name`='武漢市';
#縣級120012
INSERT INTO `base_area` SET `id`='1200130',`pid`='120012',`name`='仙桃市';

轉載于:https://www.cnblogs.com/mrray/archive/2011/05/03/2035217.html

總結

以上是生活随笔為你收集整理的mysql省市县数据库的全部內容，希望文章能夠幫你解決所遇到的問題。

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

上一篇： R语言回归中的Hosmer-Lemesh
下一篇：揭开瑞星弑毒软件的丑恶嘴脸——中国杀毒第