update 表名
set 字段名=
case
when 字段名 is NULL then 10
else 字段名 + 10
end
WHERE MVMSCODE='0112'
转载于:https://www.cnblogs.com/kelebing/archive/2006/09/18/507498.html
转载于:https://www.cnblogs.com/kelebing/archive/2006/09/18/507498.html