The script runs, says '1 row updated', but the trigger does not run, it's not in the overview of all triggers in the database.
Does it mean it is only local within if-ele statement?
If so, how to make it global?