题解 | 触发器的语法及使用
构造一个触发器audit_log
https://www.nowcoder.com/practice/7e920bb2e1e74c4e83750f5c16033e2e
create trigger audit_trigger after insert on employees_test for each row begin
insert into
audit (EMP_no, NAME)
values
(NEW.ID, NEW.NAME); #需要有分号
end;
