update 语法

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

posted @ 2004-12-08 17:05  Alvin  阅读(1975)  评论(1)    收藏  举报