select 字段1+字段2 as 字段3 from ...
UPDATE 表 SET 字段3 = 字段1+字段2
UPDATE 表 SET 字段3 = 字段1 & 字段2;或者UPDATE 表 SET 字段3 = 字段1 + 字段2;