Re: trigger with condition

[Peter Brawley]

Two problems ...

1. The Trigger is defined on sourcetable but the Update statement fails to refer to it.

2. The Join is missing a joining condition.

Some logic is missing from your description, so I can only guess at the solution, something like ...

CREATE TRIGGER ‘sync’ AFTER UPDATE ON sourcetable FOR EACH ROW
BEGIN
  UPDATE db_destination.table_content d
  JOIN sourcetable s ON d.destination_id=s.source_id
  SET d.introtext = s.introtext 
  WHERE d.destination_id = NEW.source_id;
END;

Read the manual page for Triggers to see how to use NEW and OLD.