MySQL Forums
Forum List  »  Triggers

Re: Trigger Help!
Posted by: Peter Brawley
Date: November 03, 2013 03:01PM

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 ;

Options: ReplyQuote


Subject
Views
Written By
Posted
1725
October 28, 2013 12:15PM
Re: Trigger Help!
978
November 03, 2013 03:01PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.