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  阅读(1960)  评论(1编辑  收藏  举报