I am currently trying to test my created trigger so I tried to insert this into my ’employee’ table:
IF (employee.lastname='new')
THEN
INSERT INTO employee_log (employee_id,action, action_date)
VALUES(555,'IF',CURRENT_DATE());
ELSE
INSERT INTO employee_log (employee_id,action, action_date)
VALUES(555,'notIF',CURRENT_DATE());
END IF
But when I try to add a record I get this error,please help me