update dede_arctype set typedir = replace(typedir,'{cmspath}/','/');
update dede_arctype set typedir = concat('{cmspath}/', mid(typedir,2,length(typedir)));
update 表名 set innum = concat('K', mid(innum,2,length(innum)));
innum字段
第一个字符1批量修改成K
update dede_arctype set typedir = replace(typedir,'{cmspath}/','/');
update dede_arctype set typedir = concat('{cmspath}/', mid(typedir,2,length(typedir)));
update 表名 set innum = concat('K', mid(innum,2,length(innum)));
innum字段
第一个字符1批量修改成K