某人某列批量更新为该人另外一列数据

某人某列批量更新为该人另外一列数据

1、单表简单更新

update test set E=C  

2、单表加工更新

update test set E='胖' where C >=66;

update test set E='瘦' where C <66

3、两个表联合更新

UPDATE testtwo 

SET testtwo.TC = (select TEST.E from TEST where TEST.B = testtwo.TA)

WHERE EXISTS(SELECT 1 FROM TEST WHERE TEST.B = testtwo.TA);

解释：testtwo.TC 目标表.目标字段；TEST.E源表.源字段；TEST.B = testtwo.TA  关联字段