DELETE FROM t_bas_programtemplate WHERE FID = 1154272797837493248;
INSERT INTO t_bas_programtemplate(FID,FMULCOLUMS,FVALUE,FTITLE,FMASTERID,FSTATUS,FIMAGE,FGROUPID,FNUMBER,FJSON_TAG,FCREATETIME,FMODIFIERID,FENABLE,FSMALLIMG,FMODIFYTIME,FORDER,FCREATORID) VALUES (1154272797837493248,'0',0,'其他标签',1154272797837493248,'C','private/bos/controlsprogram/evaluate/bos_wfpj_240_64.png',1154259933345088512,'rate_temp8','{
        "formMeta": {
            "AlignSelf": "default",
            "Zindex": "0",
            "Grow": 0,
            "Shrink": 0,
            "ShowTextType": 0,
            "StarsNum": 5,
            "Name": "评分",
            "RateType": "survey",
            "Type": "RateAp",
            "BackColor": "#ffffff",
            "LightStarsNum":4
        }
    }',{ts'2021-05-12  00:00:00'},13466739,'1','0',{ts'2021-05-19  00:00:00'},8,13466739);

--含有xml的数据不能通过删除再新增的方式，会丢掉xml内容对应的字段内容
UPDATE t_bas_programtemplate SET FIMAGE = 'private/bos/controlsprogram/list/bos_dczlb2_240_141.png' WHERE FID = 1154352693137904640;
