delimiter #
CREATE TRIGGER Date_par_defaut
BEFORE INSERT ON Absence
FOR EACH ROW
BEGIN
	UPDATE Absence SET dat_abs = CURRENT_DATE();
END