create trigger audit_log before insert on employees_test
for each row
begin
insert into audit (emp_no,name) values(new.id,new.name);
end;
创建触发器语法:
create trigger "trigger_name" event on table_name
for each row
begin
trigger_action
end;
其中event包含:insert、update、delete