【mysql学习笔记29】触发器

创建

CREATE TRIGGER trigger_name
BEFORE/AFTER INSERT/UPDATE/DELETE
ON tb_name FOR EACH ROW – 行级触发器
BEGIN
trigger_statement;
END;

查看

SHOW TRIGGERS;

删除

DROP TRIGGER [schema_name.]trigger_name; --没有指定schema_name默认为当前数据库

案例

create trigger tb_user_insert_trigger after insert on tb_user for each row
begin
	insert into tb_logs(id,operation,operate_time,operate_id,operate_params) 
	values(null,'insert',now(),new.id,concat('插入的数据内容为:',new.content));
end;
1
2
3
4
5

create trigger tb_user_insert_trigger after update on tb_user for each row
begin
	insert into tb_logs(id,operation,operate_time,operate_id,operate_params) 
	values(null,'update',now(),new.id,concat('更新前数据:',old.content));
end;
1
2
3
4
5