Re: Trigger Help!

[Peter Brawley]

Something like this?

delimiter go
create trigger t1upd after update on t1 for each row
if new.status=3 and new.status<>old.status then
insert into t2(...colnames...) values(...,new.status,...);
end if;
go
delimiter ;