update table1 set num = substr(num,0,instr(num,'-'))||(substr(num,instr(num,'-')+1) +9)
2.原字段是數(shù)字 使用+連接
UPDATE table1SET num = num+10
3.截取 update tc_report t set xlsfile=substr(xlsfile,6) where xlsfile like '%uku\%'
posted on 2012-11-12 10:20 wyx 閱讀(336) 評(píng)論(0) 編輯 收藏
Powered by: BlogJava Copyright © wyx