创建触发器,删除学生数据时,将删除的数据备份到数据表student_bf,以备误删除时进行数据恢复。
delimiter $$
create trigger students
before delete on student
for each row begin
insert into student_bf
select *
from student
where sno=old.sno;
end;$$
创建触发器,插入学生成绩时,限制必须在0-100之间,设置为0.
delimiter $
create trigger GWJ
before insert on sc for each row
begin
if new.grade<0 or new.grade>100
then