update test4_10
set age=2012-extract(year from birthday) where age is null
update test4_10
set class=replace(class,'级','') update test4_10
set class=replace(class,' ','')
update dbtest set test=4 select * from dbscore
update test4_10
set age=2012-extract(year from birthday) where age is null
update test4_10
set class=replace(class,'级','') update test4_10
set class=replace(class,' ','')
update dbtest set test=4 select * from dbscore
下一篇:大物练习题(信计专业)