If Exists Trigger syntax

[James Anderson]

I am not sure what is wrong with the following syntax.

I have tried breaking the sql up and executing the select statement by itself, no problem.

Suggestions very welcome.

James


Error

SQL query: Documentation

CREATE TRIGGER decrement_licenses BEFORE INSERT ON licenses
FOR EACH
ROW BEGIN
IF EXISTS
(
SELECT *
FROM distributors
WHERE name = NEW.distributor
AND licenses >0
)
THEN
UPDATE distributors SET licenses = licenses +1 WHERE name = NEW.distributor;
ENDIF;
END;

MySQL said: Documentation

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 6