delimiter #
CREATE TRIGGER Trig_defaillant
BEFORE INSERT
ON Defaillance
FOR EACH ROW
BEGIN
	DECLARE nbrAbs INT;
	SET nbrAbs = (SELECT COUNT(*) FROM Absence WHERE id_abs = NEW.id_abs);
	IF nbrAbs = 4 THEN
		INSERT INTO Defaillance VALUES (NEW.id_abs, null, NEW.remarques);
	ELSEIF nbrAbs = 5 THEN
		UPDATE Defaillance SET Date_Def = curdate() WHERE id_Def = NEW.id_abs;
END IF;
END;
#