UPDATE t_aty_dept SET j_ext = CONCAT(SUBSTRING(j_ext,1,length(j_ext)-1),',CSfSpBm:"true"}')
修改前
{"DTUpdatetime":"2020-03-30"}
修改后
{"DTUpdatetime":"2020-03-30",CSfSpBm:"true"}
UPDATE t_aty_dept SET j_ext = CONCAT(SUBSTRING(j_ext,1,length(j_ext)-1),',CSfSpBm:"true"}')
修改前
{"DTUpdatetime":"2020-03-30"}
修改后
{"DTUpdatetime":"2020-03-30",CSfSpBm:"true"}