创建触发器:
CREATE trigger <触发器名>
< BEFORE | AFTER > <INSERT | UPDATE | DELETE >
ON <表名>
FOR EACH Row
<触发器主体>
< BEFORE | AFTER > <INSERT | UPDATE | DELETE >
ON <表名>
FOR EACH Row
<触发器主体>
create TRIGGER audid_log after insert on employees_test for each row begin insert into audit values(new.id,new.name); end