#1064 - You have an error in your SQL syntax

[josep subira]

Hi
Im new in sql and Im trying to create trigger to update a date field on a table. It gives me an error and Im not able to find where is the mistake... any help? thanks



DELIMITER $$
CREATE TRIGGER subject1 AFTER INSERT ON table1
FOR EACH ROW BEGIN
DECLARE variable1 int;
SET variable1 = (select dayJob from table1);
IF variable1 > 0 THEN
table1.newdate = DATE_ADD(table1.newdate,INTERVAL variable1 DAY)
end if
END$$

DELIMITER ;