16 Aug
2017
16 Aug
'17
3:06 a.m.
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"
???
tia, --Mike