mysql操作触发器增删改查

1添加触发器

触发器类型
INSERT | UPDATE | DELETE


1、创建插入触发器dade1是触发器名称，dade_cs是表名称
CREATE TRIGGER dade1 AFTER INSERT ON dade_cs FOR EACH ROW
INSERT INTO dade_cs_2(name) VALUES(new.name);



2、创建更新触发器dade2是触发器名称，dade_cs是表名称
CREATE TRIGGER dade2 AFTER UPDATE  ON dade_cs FOR EACH ROW
INSERT INTO dade_cs_2(name) VALUES(new.name);



1、创建删除触发器dade3是触发器名称，dade_cs是表名称
CREATE TRIGGER dade6 AFTER DELETE ON dade_cs FOR EACH ROW
INSERT INTO dade_cs_2(name) VALUES(old.name);

2、修改触发器

删除触发器，在重新创建

3、删除触发器（dade1是触发器名称）

DROP TRIGGER dade1;

4、查询触发器

SELECT * FROM information_schema.`TRIGGERS` where EVENT_OBJECT_TABLE='dade_cs';
SELECT * FROM information_schema.`TRIGGERS` where TRIGGER_NAME='dade2';
SELECT * FROM information_schema.`TRIGGERS` where EVENT_MANIPULATION='UPDATE';

EVENT_OBJECT_TABLE数据库名
TRIGGER_NAME触发器名
EVENT_MANIPULATION触发器类型