Re: [NF] Trigger question

On 2017-08-15 23:06, mbsoftwaresolutions@mbsoftwaresolutions.com wrote:

MariaDB backend (but could be SQL Server too)

Given this trigger: UPDATE MyTable SET cItemID = new.cID WHERE cItemID = old.cID

My question: will this trigger fire even if the old.cID = new.cID? Or do I need to add to the WHERE clause something like "....and old.cID <> new.cID"

My testing seems to indicate that I need to add the extra condition. Makes total sense on re-thought. These triggers fire on just the action, regardless of true change.