1.建立學生信息表

-- 觸發器
-- 建立學生信息表
create table s1(id int unsigned auto_increment,name varchar(30),score tinyint unsigned,dept varchar(50),primary key(id)
);

2.建立學生補考信息表

-- 建立學生補考信息表
create table s2 like s1;

3.建立觸發器（一共建立了三個觸發器）

-- 建立觸發器
-- 插入觸發器
delimiter //
create trigger t1 after insert on s1 for each row
beginif NEW.score<60 theninsert into s2 values(new.id,new.name,new.score,new.dept);end if;
end//
delimiter ;
-- 刪除觸發器
delimiter //
create trigger t2 after delete on s1 for each row
begindelete from s2 where old.id = id;
end//
delimiter ;
-- 更新觸發器
delimiter //
create trigger t3 after update on s1 for each row
beginif new.score < 60 thenreplace into s2 value(new.id,new.name,new.score,new.dept);elsedelete from s2 where id = new.id;end if;
end//
delimiter ;

4.插入數據

-- 插入數據
insert into s1 value(null,'李四',60,'計算機科學');
insert into s1 value(null,'趙六',30,'會計');
insert into s1 value(null,'李四玉',70,'計算機科學');
insert into s1 value(null,'周五',80,'英語');
insert into s1 value(null,'趙強',10,'計算機科學');
insert into s1 value(null,'王七',98,'英語');

5.查詢結果

select * from s2;
select * from s1;

?查詢s1表

?查詢s2表

?