UPDATE T_BAS_SYSPARAMETER SET FDATA = '{"encrptypath":true}' WHERE FDATA IS NULL and fparamid = (select fid from t_bas_sysparaconsole where fformid = 'bos_publicparametertpl') and EXISTS(SELECT fenable,count(*) from T_SEC_USER where fenable = '1' group by fenable HAVING count(*) < 10);

UPDATE T_BAS_SYSPARAMETER SET FDATA = CONCAT('{"encrptypath":true,',SUBSTRING(FDATA,2,100000)) WHERE (FDATA IS NOT NULL AND FDATA NOT LIKE '%"encrptypath"%') and fparamid = (select fid from t_bas_sysparaconsole where fformid = 'bos_publicparametertpl') and EXISTS(SELECT fenable,count(*) from T_SEC_USER where fenable = '1' group by fenable HAVING count(*) < 10);