mysql数据库触发器的操作

       （1）创建触发器：

delimiter $$use insurance$$CREATE TRIGGER trig_staffInfo_updateAFTER UPDATEON insurance.staffinfo FOR EACH ROWBEGIN    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 触发器名