Re: Update of a single column triggers update of unrelated one

[irek kordirko]

Yannick Gansemans Wrote:
-------------------------------------------------------
>
> Why is the name field updated by the trigger? How
> do I avoid that (the update trigger should be able
> to detect if a vaulue was passed for the 'name'
> column)?

You cannot detect if the update changes some column or not.
NEW.column always contains a new value of a column, even the column is not updated.
However, you can compare an OLD.value with a NEW.value - if they differ that means the update changed the column.