题解 | 41#构造一个触发器audit_log#

create trigger audit_log
after insert on employees_test
for each row 
begin 
    insert into audit values(new.id,new.name);
end 

思路：熟悉构造触发器的语法，

create trigger xxx
  after insert on 表名
  for each row
  begin
      insert/delete/update语句
  end