mysql学习--（六）--触发器、游标 、handler

触发器

删除员工表 的信息，自动添加到离职员工表中去
– delete 没有new,有old
– insert 没有old,有new
– update 有new，有old
– delete insert update 都是有两种触发方式(before、after)

create table leaveEmp as select * from emp;
delete from leaveemp;

drop trigger if exists Emp_del;

create trigger Emp_del after delete 
on emp for each row 
begin 
	 insert into leaveemp values (old.eno,old.ename,old.birthday,old.manager,old.job,old.sal,old.sex,old