CODE EXAMPLE FOR SQL

mysql set column equal to another automatic

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