1 列值的替换:
(1) 根据列值直接替换成相应标识符。
员工信息表中有xb字段,值为1和2 替换 为’男‘和’女‘
update jg_jzgjcsjzl set xb= case when xbm='1' then '男' when xbm='2' then '女' end
UPDATE Personnel SET salary = CASE WHEN salary >= 5000 THEN salary * 0.9 WHEN salary >= 2000 AND salary < 4600 THEN salary * 1.15 ELSE salary END;
(2)根据另一张表的信息替换本表中列(与另表对照)的值。
一个国标民族代码表,一张员工信息表 将员工的籍贯替换成代码(籍贯
a UPDATE test1 a
SET a.x__nativeplace =
(SELECT b.code FROM test2 b WHERE instr(a.x__nativeplace,b.info)>0)
(inter 就是b.info在a.x__nativeplace 中的位置,如果为0表示没找到)
根据两列相似的值更新另一列值)
b UPDATE overall a
SET a.x__nativeplace =
(SELECT b.info FROM gb_t2260 b WHERE b.code=a.x__nativeplace)
c update test a
set (a.prdn_st,avg_yield