delimiter //
create trigger tmp_trg
after insert or delete or update on tmp_table
for each row
begin
if updating then
insert into de_log values ('U',new.name,new.secret);
end if;
if inserting then
insert into de_log values ('I',new.name,new.secret);
end if;
if deleting then
insert into de_log values ('D',old.name,old.name);
end if;
end;//我想在一个表中创建一个trigger,insert/delete/update 上面这样好象不行 请高手指教
create trigger tmp_trg
after insert or delete or update on tmp_table
for each row
begin
if updating then
insert into de_log values ('U',new.name,new.secret);
end if;
if inserting then
insert into de_log values ('I',new.name,new.secret);
end if;
if deleting then
insert into de_log values ('D',old.name,old.name);
end if;
end;//我想在一个表中创建一个trigger,insert/delete/update 上面这样好象不行 请高手指教
after insert or delete or update on tmp_table
必须一次一个。
比如:after insert on tmp_table after delete on tmp_table after update on tmp_table
create or replace trigger tmp_trg before insert or delete or update on tmp_table