after
insert
and logs into log
tableDROP TRIGGER IF EXISTS after_student_insert;
DELIMITER $$
CREATE TRIGGER after_student_insert BEFORE INSERT
ON students
FOR EACH ROW
BEGIN
INSERT INTO log (description)
VALUES ('One student inserted');
END$$
DELIMITER ;