1
vote
Accepted
Understanding `WHERE x = NEW.x` Syntax
This is not actually a DBA question but rather a Boolean algebra question (which means it might be more at home on Stack Overflow.)
In short, you want the trigger to fire if EITHER:
a_number is ...
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
update × 946mysql × 300
sql-server × 225
postgresql × 224
trigger × 69
insert × 68
performance × 67
oracle × 60
join × 56
t-sql × 47
select × 33
locking × 33
subquery × 30
query-performance × 27
mariadb × 27
query × 26
sql-server-2008 × 25
sql-server-2008-r2 × 23
innodb × 20
index × 19
table × 19
delete × 19
sql-server-2012 × 18
sql-server-2016 × 17
optimization × 17