I'm trying to use the trigger below on my database but I keep getting the error
"#1235 - This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'". Could someone tell me what is wrong.
DELIMITER $$
CREATE TRIGGER grade_change AFTER UPDATE on takes
FOR EACH ROW BEGIN
IF (OLD.grade='F' OR OLD.grade IS NULL) AND NEW.grade != 'F' AND NEW.grade IS NOT NULL THEN
BEGIN
set @c=(SELECT credits FROM course WHERE course.course_id=NEW.course_id);
UPDATE student SET tot_cred=tot_cred+@c WHERE student.id=NEW.id;
END;
END IF;
END$$
DELIMITER ;