MySQL Forums
Forum List  »  Triggers

Advanced Search
New Topic

Re: trigger with condition
Posted by: Peter Brawley
Date: November 30, 2013 11:37PM

Your trigger is conditioned on one specific column value. That's preposterous. NEW and OLD are not Trigger "extensions". They're intrinsic to MySQL Trigger logic, indeed they offer only way for the Trigger to identify the row being updated. Consider re-reading the manual page on Triggers.



Edited 1 time(s). Last edit at 12/01/2013 01:45PM by Peter Brawley.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
trigger with condition
2761
Martin Tomczyk
November 29, 2013 07:01AM
Re: trigger with condition
1403
Peter Brawley
November 29, 2013 12:27PM
Re: trigger with condition
1459
Martin Tomczyk
November 29, 2013 02:21PM
Re: trigger with condition
1349
Martin Tomczyk
November 30, 2013 04:03PM
Re: trigger with condition
1375
Peter Brawley
November 30, 2013 11:37PM
Re: trigger with condition
1305
Martin Tomczyk
December 01, 2013 03:52AM
Re: trigger with condition
1303
Peter Brawley
December 01, 2013 01:46PM
Re: trigger with condition
1326
Martin Tomczyk
December 01, 2013 03:21PM


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.