boyue_jnpf/sql_init/SQLServer/Update/Update_SQLServer_0220.sql

update base_module set f_property_json = CONCAT(SUBSTRING(f_property_json,1,len(f_property_json)-1), ',"webType":2}') where  f_type = 3 and f_category = 'Web' and f_property_json is not null and f_property_json not like '%webType%';