创建触发器:
CREATE trigger <触发器名>
 < 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