(1)创建触发器:
delimiter $$
use insurance$$
CREATE TRIGGER trig_staffInfo_update
AFTER UPDATE
ON insurance.staffinfo FOR EACH ROW
BEGIN
DECLARE collegeName VARCHAR(40);
DECLARE collegeNo VARCHAR(10);
DECLARE collegeCursor CURSOR for select college_name,no from college
where college_id=NEW.college_id;
OPEN collegeCursor;
FETCH collegeCursor into collegeName,collegeNo;
INSERT into staff_tmp(name,sex,college,no,gzzh,idnumber,htjzsj,htkssj,flag)
VALUES(NEW.name,NEW.sex,collegeName,collegeNo,NEW.gzzh,NEW.idnumber,NEW.htjzsj,NEW.htkssj,2);
END$$
(2)删除触发器:
drop trigger 触发器名