MySql 触发器案例

/*显示全部触发器*/

SHOW TRIGGERS;

/*删除触发器*/

DROP TRIGGER FinancialInsCompanyAdd;  

 

delimiter $$
CREATE TRIGGER FinancialInsCompanyAdd

BEFORE

INSERT ON tb_sys_insurancecom FOR EACH ROW

BEGIN

IF new.cuorgcode LIKE 'QYJT.%' THEN
IF new.ccompanytype = '1' THEN /*保险公司*/
INSERT INTO financialplatform.tb_sts_inscompany
(cid,cuorgcode,ccreatetime,cname,ccode,csort)
VALUES
(new.cid,new.cuorgcode,NOW(),new.cname,new.cnumber,999);
END IF;

END IF;

END$$

delimiter ;