update  t_bd_admindivisionpre set fareacode =  '340209' where fareacode = '340203';
update  t_bd_admindivisionpre set fareacode =  '320613' where fareacode = '320602';
delete from t_bd_admindivisionpre  where fnumber in('001975','001980','002087','002174','002487','002570','002574','0016','0017','0018','00728','001141','001146','001147','001656','002948','00354');
DELETE FROM t_bd_admindivisionpre WHERE fid = 11571;
INSERT INTO t_bd_admindivisionpre(fmasterid,fid,fdisabledate,fcitynumber,fareacode,fstatus,fmodifierid,fnumber,fisleaf,fcreatetime,ffullspell,fadmindivisionlvid,fdescription,fiscity,fsimplespell,flevel,fparentid,fissystem,fname,fenable,fcreatorid,flongnumber,fdisablerid,ffullname,fmodifytime,fcountryid) VALUES (0,11571,NULL,' ','130505','C',0,'11571','1',{ts'2021-07-13  00:00:00'},'Renze District',3,'任泽','0','RZQ',3,1140,'1','任泽区','1',1,'1073.001140.11571',0,'河北省_邢台市_任泽区',{ts'2021-07-13  00:00:00'},1000001); 
DELETE FROM t_bd_admindivisionpre WHERE fid = 11572;
INSERT INTO t_bd_admindivisionpre(fmasterid,fid,fdisabledate,fcitynumber,fareacode,fstatus,fmodifierid,fnumber,fisleaf,fcreatetime,ffullspell,fadmindivisionlvid,fdescription,fiscity,fsimplespell,flevel,fparentid,fissystem,fname,fenable,fcreatorid,flongnumber,fdisablerid,ffullname,fmodifytime,fcountryid) VALUES (0,11572,NULL,' ','130506','C',0,'11572','1',{ts'2021-07-13  00:00:00'},'Nanhe District',3,'南和','0','NHQ',3,1140,'1','南和区','1',1,'1073.001140.11572',0,'河北省_邢台市_南和区',{ts'2021-07-13  00:00:00'},1000001); 
DELETE FROM t_bd_admindivisionpre WHERE fid = 21591;
INSERT INTO t_bd_admindivisionpre(fmasterid,fid,fdisabledate,fcitynumber,fareacode,fstatus,fmodifierid,fnumber,fisleaf,fcreatetime,ffullspell,fadmindivisionlvid,fdescription,fiscity,fsimplespell,flevel,fparentid,fissystem,fname,fenable,fcreatorid,flongnumber,fdisablerid,ffullname,fmodifytime,fcountryid) VALUES (0,21591,NULL,' ','220184','C',0,'21591','1',{ts'2021-07-13  00:00:00'},'Gongzuling City',3,'公主岭','1','GZL ',3,2148,'1','公主岭市','1',1,'2147.2148.21591',0,'吉林省_长春市_公主岭市',{ts'2021-07-13  00:00:00'},1000001); 
DELETE FROM t_bd_admindivisionpre WHERE fid = 19811;
INSERT INTO t_bd_admindivisionpre(fmasterid,fid,fdisabledate,fcitynumber,fareacode,fstatus,fmodifierid,fnumber,fisleaf,fcreatetime,ffullspell,fadmindivisionlvid,fdescription,fiscity,fsimplespell,flevel,fparentid,fissystem,fname,fenable,fcreatorid,flongnumber,fdisablerid,ffullname,fmodifytime,fcountryid) VALUES (0,19811,NULL,' ','320614','C',0,'19811','1',{ts'2021-07-13  00:00:00'},'Haimen District',3,'海门','0','HMQ',3,1973,'1','海门区','1',1,'1916.1973.19811',0,'江苏省_南通市_海门区',{ts'2021-07-13  00:00:00'},1000001); 
DELETE FROM t_bd_admindivisionpre WHERE fid = 35571;
INSERT INTO t_bd_admindivisionpre(fmasterid,fid,fdisabledate,fcitynumber,fareacode,fstatus,fmodifierid,fnumber,fisleaf,fcreatetime,ffullspell,fadmindivisionlvid,fdescription,fiscity,fsimplespell,flevel,fparentid,fissystem,fname,fenable,fcreatorid,flongnumber,fdisablerid,ffullname,fmodifytime,fcountryid) VALUES (0,35571,NULL,' ','330225','C',0,'35571','1',{ts'2021-07-13  00:00:00'},'Xiangshan County ',3,'象山','0','XSX',3,3547,'1','象山县','1',1,'3533.3547.35571',0,'浙江省_宁波市_象山县',{ts'2021-07-13  00:00:00'},1000001); 
DELETE FROM t_bd_admindivisionpre WHERE fid = 12001;
INSERT INTO t_bd_admindivisionpre(fmasterid,fid,fdisabledate,fcitynumber,fareacode,fstatus,fmodifierid,fnumber,fisleaf,fcreatetime,ffullspell,fadmindivisionlvid,fdescription,fiscity,fsimplespell,flevel,fparentid,fissystem,fname,fenable,fcreatorid,flongnumber,fdisablerid,ffullname,fmodifytime,fcountryid) VALUES (0,12001,NULL,' ','340210','C',0,'12001','1',{ts'2021-07-13  00:00:00'},'Wanzhi District ',3,'湾沚','0','WZQ',3,12,'1','湾沚区','1',1,'1.12.12001',0,'安徽省_芜湖市_湾沚区',{ts'2021-07-13  00:00:00'},1000001); 
DELETE FROM t_bd_admindivisionpre WHERE fid = 12002;
INSERT INTO t_bd_admindivisionpre(fmasterid,fid,fdisabledate,fcitynumber,fareacode,fstatus,fmodifierid,fnumber,fisleaf,fcreatetime,ffullspell,fadmindivisionlvid,fdescription,fiscity,fsimplespell,flevel,fparentid,fissystem,fname,fenable,fcreatorid,flongnumber,fdisablerid,ffullname,fmodifytime,fcountryid) VALUES (0,12002,NULL,' ','340212','C',0,'12002','1',{ts'2021-07-13  00:00:00'},'Fanchang District',3,'繁昌','0','FCQ',3,12,'1','繁昌区','1',1,'1.12.12002',0,'安徽省_芜湖市_繁昌区',{ts'2021-07-13  00:00:00'},1000001); 
DELETE FROM t_bd_admindivisionpre WHERE fid = 25761;
INSERT INTO t_bd_admindivisionpre(fmasterid,fid,fdisabledate,fcitynumber,fareacode,fstatus,fmodifierid,fnumber,fisleaf,fcreatetime,ffullspell,fadmindivisionlvid,fdescription,fiscity,fsimplespell,flevel,fparentid,fissystem,fname,fenable,fcreatorid,flongnumber,fdisablerid,ffullname,fmodifytime,fcountryid) VALUES (0,25761,NULL,' ','370614','C',0,'25761','1',{ts'2021-07-13  00:00:00'},'Penglai District',3,'蓬莱','0','PLQ',3,2565,'1','蓬莱区','1',1,'2517.2565.25761',0,'山东省_烟台市_蓬莱区',{ts'2021-07-13  00:00:00'},1000001); 
DELETE FROM t_bd_admindivisionpre WHERE fid = 16541;
INSERT INTO t_bd_admindivisionpre(fmasterid,fid,fdisabledate,fcitynumber,fareacode,fstatus,fmodifierid,fnumber,fisleaf,fcreatetime,ffullspell,fadmindivisionlvid,fdescription,fiscity,fsimplespell,flevel,fparentid,fissystem,fname,fenable,fcreatorid,flongnumber,fdisablerid,ffullname,fmodifytime,fcountryid) VALUES (0,16541,NULL,' ','421088','C',0,'16541','1',{ts'2021-07-13  00:00:00'},'Jianli City',3,'监利','1','JLS',3,1652,'1','监利市','1',1,'1579.1652.16541',0,'湖北省_荆州市_监利市',{ts'2021-07-13  00:00:00'},1000001); 
DELETE FROM t_bd_admindivisionpre WHERE fid = 83001;
INSERT INTO t_bd_admindivisionpre(fmasterid,fid,fdisabledate,fcitynumber,fareacode,fstatus,fmodifierid,fnumber,fisleaf,fcreatetime,ffullspell,fadmindivisionlvid,fdescription,fiscity,fsimplespell,flevel,fparentid,fissystem,fname,fenable,fcreatorid,flongnumber,fdisablerid,ffullname,fmodifytime,fcountryid) VALUES (0,83001,NULL,' ',' ','C',0,'83001','1',{ts'2021-07-13  00:00:00'},'Xisha District',3,'西沙','0','XSQ',3,828,'1','西沙区','1',1,'809.828.83001',0,'海南省_三沙市_西沙区',{ts'2021-07-13  00:00:00'},1000001); 
DELETE FROM t_bd_admindivisionpre WHERE fid = 83002;
INSERT INTO t_bd_admindivisionpre(fmasterid,fid,fdisabledate,fcitynumber,fareacode,fstatus,fmodifierid,fnumber,fisleaf,fcreatetime,ffullspell,fadmindivisionlvid,fdescription,fiscity,fsimplespell,flevel,fparentid,fissystem,fname,fenable,fcreatorid,flongnumber,fdisablerid,ffullname,fmodifytime,fcountryid) VALUES (0,83002,NULL,' ',' ','C',0,'83002','1',{ts'2021-07-13  00:00:00'},'Nansha District',3,'南沙','0','NSQ',3,828,'1','南沙区','1',1,'809.828.83002',0,'海南省_三沙市_南沙区',{ts'2021-07-13  00:00:00'},1000001); 
DELETE FROM t_bd_admindivisionpre WHERE fid = 29541;
INSERT INTO t_bd_admindivisionpre(fmasterid,fid,fdisabledate,fcitynumber,fareacode,fstatus,fmodifierid,fnumber,fisleaf,fcreatetime,ffullspell,fadmindivisionlvid,fdescription,fiscity,fsimplespell,flevel,fparentid,fissystem,fname,fenable,fcreatorid,flongnumber,fdisablerid,ffullname,fmodifytime,fcountryid) VALUES (0,29541,NULL,' ','510118','C',0,'29541','1',{ts'2021-07-13  00:00:00'},'Xinjin District ',3,'新津','0','XJQ',3,2933,'1','新津区','1',1,'2932.2933.29541',0,'四川省_成都市_新津区',{ts'2021-07-13  00:00:00'},1000001); 
DELETE FROM t_bd_admindivisionpre WHERE fid = 72911;
INSERT INTO t_bd_admindivisionpre(fmasterid,fid,fdisabledate,fcitynumber,fareacode,fstatus,fmodifierid,fnumber,fisleaf,fcreatetime,ffullspell,fadmindivisionlvid,fdescription,fiscity,fsimplespell,flevel,fparentid,fissystem,fname,fenable,fcreatorid,flongnumber,fdisablerid,ffullname,fmodifytime,fcountryid) VALUES (0,72911,NULL,' ','520204','C',0,'72911','1',{ts'2021-07-13  00:00:00'},'Shuicheng District',3,'水城','0','SCQ',3,726,'1','水城区','1',1,'715.726.72911',0,'贵州省_六盘水市_水城区',{ts'2021-07-13  00:00:00'},1000001); 
DELETE FROM t_bd_admindivisionpre WHERE fid = 24901;
INSERT INTO t_bd_admindivisionpre(fmasterid,fid,fdisabledate,fcitynumber,fareacode,fstatus,fmodifierid,fnumber,fisleaf,fcreatetime,ffullspell,fadmindivisionlvid,fdescription,fiscity,fsimplespell,flevel,fparentid,fissystem,fname,fenable,fcreatorid,flongnumber,fdisablerid,ffullname,fmodifytime,fcountryid) VALUES (0,24901,NULL,' ','632301','C',0,'24901','1',{ts'2021-07-13  00:00:00'},'Tongren City ',3,'同仁','0','TRS',3,2486,'1','同仁市','1',1,'2467.2486.24901',0,'青海省_黄南藏族自治州_同仁市',{ts'2021-07-13  00:00:00'},1000001); 
DELETE FROM t_bd_admindivisionpre_l WHERE fpkid = '40000';
INSERT INTO t_bd_admindivisionpre_l(fid,fpkid,fname,fsimplename,ffullname,fdescription,flocaleid) VALUES (11571,'40000','任泽区',' ','河北省_邢台市_任泽区','任泽','zh_CN'); 
DELETE FROM t_bd_admindivisionpre_l WHERE fpkid = '40001';
INSERT INTO t_bd_admindivisionpre_l(fid,fpkid,fname,fsimplename,ffullname,fdescription,flocaleid) VALUES (11572,'40001','南和区',' ','河北省_邢台市_南和区','南和','zh_CN'); 
DELETE FROM t_bd_admindivisionpre_l WHERE fpkid = '40002';
INSERT INTO t_bd_admindivisionpre_l(fid,fpkid,fname,fsimplename,ffullname,fdescription,flocaleid) VALUES (21591,'40002','公主岭市',' ','吉林省_长春市_公主岭市','公主岭','zh_CN'); 
DELETE FROM t_bd_admindivisionpre_l WHERE fpkid = '40003';
INSERT INTO t_bd_admindivisionpre_l(fid,fpkid,fname,fsimplename,ffullname,fdescription,flocaleid) VALUES (19811,'40003','海门区',' ','江苏省_南通市_海门区','海门','zh_CN'); 
DELETE FROM t_bd_admindivisionpre_l WHERE fpkid = '40004';
INSERT INTO t_bd_admindivisionpre_l(fid,fpkid,fname,fsimplename,ffullname,fdescription,flocaleid) VALUES (35571,'40004','象山县',' ','浙江省_宁波市_象山县','象山','zh_CN'); 
DELETE FROM t_bd_admindivisionpre_l WHERE fpkid = '40005';
INSERT INTO t_bd_admindivisionpre_l(fid,fpkid,fname,fsimplename,ffullname,fdescription,flocaleid) VALUES (12001,'40005','湾沚区',' ','安徽省_芜湖市_湾沚区','湾沚','zh_CN'); 
DELETE FROM t_bd_admindivisionpre_l WHERE fpkid = '40006';
INSERT INTO t_bd_admindivisionpre_l(fid,fpkid,fname,fsimplename,ffullname,fdescription,flocaleid) VALUES (12002,'40006','繁昌区',' ','安徽省_芜湖市_繁昌区','繁昌','zh_CN'); 
DELETE FROM t_bd_admindivisionpre_l WHERE fpkid = '40007';
INSERT INTO t_bd_admindivisionpre_l(fid,fpkid,fname,fsimplename,ffullname,fdescription,flocaleid) VALUES (25761,'40007','蓬莱区',' ','山东省_烟台市_蓬莱区','蓬莱','zh_CN'); 
DELETE FROM t_bd_admindivisionpre_l WHERE fpkid = '40008';
INSERT INTO t_bd_admindivisionpre_l(fid,fpkid,fname,fsimplename,ffullname,fdescription,flocaleid) VALUES (16541,'40008','监利市',' ','湖北省_荆州市_监利市','监利','zh_CN'); 
DELETE FROM t_bd_admindivisionpre_l WHERE fpkid = '40009';
INSERT INTO t_bd_admindivisionpre_l(fid,fpkid,fname,fsimplename,ffullname,fdescription,flocaleid) VALUES (83001,'40009','西沙区',' ','海南省_三沙市_西沙区','西沙','zh_CN'); 
DELETE FROM t_bd_admindivisionpre_l WHERE fpkid = '40010';
INSERT INTO t_bd_admindivisionpre_l(fid,fpkid,fname,fsimplename,ffullname,fdescription,flocaleid) VALUES (83002,'40010','南沙区',' ','海南省_三沙市_南沙区','南沙','zh_CN'); 
DELETE FROM t_bd_admindivisionpre_l WHERE fpkid = '40011';
INSERT INTO t_bd_admindivisionpre_l(fid,fpkid,fname,fsimplename,ffullname,fdescription,flocaleid) VALUES (29541,'40011','新津区',' ','四川省_成都市_新津区','新津','zh_CN'); 
DELETE FROM t_bd_admindivisionpre_l WHERE fpkid = '40012';
INSERT INTO t_bd_admindivisionpre_l(fid,fpkid,fname,fsimplename,ffullname,fdescription,flocaleid) VALUES (72911,'40012','水城区',' ','贵州省_六盘水市_水城区','水城','zh_CN'); 
DELETE FROM t_bd_admindivisionpre_l WHERE fpkid = '40013';
INSERT INTO t_bd_admindivisionpre_l(fid,fpkid,fname,fsimplename,ffullname,fdescription,flocaleid) VALUES (24901,'40013','同仁市',' ','青海省_黄南藏族自治州_同仁市','同仁','zh_CN'); 
DELETE FROM t_bd_preset_version WHERE fid = 1073001332698305538;
INSERT INTO t_bd_preset_version(fid,fcreatetime,fsource,fisupdate,fissendtoadmin,fversionnum,fcreatorid) VALUES (1073001332698305538,{ts'2021-07-15  00:00:00'},'bd_admindivision','0','1','admindivision-202107-15',1); 
DELETE FROM t_bd_preset_version_l WHERE fpkid = '1BSMOBEUE9SC';
INSERT INTO t_bd_preset_version_l(fguideinfo,fid,flocaleid,fpkid) VALUES ('<p>本更新基于中华人民共和国民政部于2020年12月31日发布的行政区划数据（县级及以上）。较之前版本，更新内容主要如下：
<p style="text-indent: 2em">1. 禁用16条行政区划，包括已撤销的行政区划（7条），如邢台市的“邢台县”；
<p style="text-indent: 2em">2. 修正部分更名的行政区划（9条），如：南通的“海门市”更名为“海门区”；
<p style="text-indent: 2em">3. 补充若干新增的行政区划（5条），如：三沙市的“西沙区”、“南沙区”;</p>  请根据您的实际使用情况和当前数据，使用本向导查阅更新内容并自主选择要更新的数据执行操作。',1073001332698305538,'zh_CN','1BSMOBEUE9SC'); 
