CREATE TRIGGER trigger6 BEFORE INSERT ON student_scores FOR EACH ROW BEGIN DECLARE student_count INT; DECLARE course_count INT; SELECT COUNT(*) INTO student_count FROM students WHERE student_id = NEW.student_id; SELECT COUNT(*) INTO course_count FROM courses WHERE course_id = NEW.course_id; IF student_count = 0 THEN SELECT '该生不存在,请确认后再添加' AS message; DELETE FROM student_scores WHERE student_id = NEW.student_id; END IF; IF course_count = 0 THEN SELECT '该课程号不存在,请确认后再添加' AS message; DELETE FROM student_scores WHERE course_id = NEW.course_id; END IF; IF NEW.score < 0 OR NEW.score > 100 THEN SELECT '该成绩有误,请更正!' AS message; DELETE FROM student_scores WHERE student_id = NEW.student_id AND course_id = NEW.course_id; END IF; END;