mysql set column equal to another automatic
snippet in sql

mysql set column equal to another automatic

user3465

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