• i had written these code

    it give me syntax error

    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;