MySQL触发器：阻止删除计算机系学生并回滚操作

CREATE TRIGGER trg_delete_student BEFORE DELETE ON student_info FOR EACH ROW BEGIN IF OLD.department = '计算机系' THEN SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = '不能删除计算机系的学生！'; ROLLBACK; END IF; END;