MySQL添加触发器相关操作

首先修改执行符为|

delimiter |

添加出发前先保证不存在同名的触发器

drop trigger if exists trigger_after_tab1_insert|

添加触发器吧

-- 增
create trigger trigger_after_tab1_insert
after insert
on tab1 for each row
begin
insert into tab2(`tabname`,`recid`,`action`,`datetime`) values('tab1', new.raid, '1', unix_timestamp(now()));
end|
-- 删
create trigger trigger_after_tab1_delete
after delete
on tab1 for each row
begin
insert into tab2(`tabname`,`recid`,`action`,`datetime`) values('tab1', old.raid, '-1', unix_timestamp(now()));
end|
-- 改
create trigger trigger_after_tab1_update
after update
on tab1 for each row
begin
insert into tab2(`tabname`,`recid`,`action`,`datetime`) values('tab1', new.raid, '0', unix_timestamp(now()));
end|

最后记得把执行符改回来

delimiter ;

 

after是执行后，也可以使用before，在执行之前