mysql set the value of a select to the value of another column in select code example

Example: mysql set column equal to another automatic

CREATE TRIGGER foobar AFTER UPDATE ON table
  FOR EACH ROW SET foo = foo + NEW.bar;