CREATE TRIGGER 触发器名 BEFORE|AFTER 触发事件 ON 表名 FOR EACH ROW 执行语句;

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

触发器的使用场景应该不是很多吧？ 触发器的相关资料： https://blog.csdn.net/weixin_29599033/article/details/113235650

https://www.cnblogs.com/geaozhang/p/6819648.html

https://www.cnblogs.com/phpper/p/7587031.html