i had written these code but it gives me syntax error
where headcountdetail is stored procedure and coulmn1 and column2 are coulmns of table2
CREATE TRIGGER HeadCount AFTER INSERT ON table2
FOR EACH ROW BEGIN
IF(NEW. coulmn1>2 AND NEW. coulmn1 < 4 ) begin
exec HeadCountDetail(NEW.coulmn1,NEW.coulmn2);
END;
END;