Re: If Exists Trigger syntax

[Peter Brawley]

END IF not ENDIF, but If( Exists...) is entirely unnecessary, that logic is included in the Where clause of the Update statement ...

CREATE TRIGGER incr_t BEFORE INSERT ON t FOR EACH ROW
UPDATE distributors SET licenses=licenses+1 WHERE name=NEW.distributor;