update 语法

update bugs  set skey = replace(substring(bg_short_desc,15,5),'/','')
where bugs.bg_project =4  and bugs.bg_category = 8

原文地址:https://www.cnblogs.com/Alvin/p/74515.html