mysql数据库触发器的操作

       （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 触发器名