mysql if else 语句修改字段

UPDATE tb_track_scale_record
SET trainWeight = (  
CASE
WHEN grossWeight IS NOT NULL THEN tareWeight  
WHEN tareWeight IS NOT NULL THEN tareWeight  
END
);