Re: Updating a row from another table - trigger/procedure or function ?

[Peter Brawley]

Is this what you mean?

CREATE TRIGGER update_current_address
AFTER UPDATE ON migration
FOR EACH ROW BEGIN
  IF NEW.done = 1 THEN
    UPDATE client SET current_address=OLD.new_address WHERE cID=OLD.cID;
  END IF;
END;

PB
http://www.artfulsoftware.com