MySQL: Set to default value on update

Question

Is it possible to set a column to its default value (or any specified value) on update when no value is specifically given in the statement? I was thinking that a trigger might accomplish this. Something like

IF ISNULL(NEW.column) THEN
 NEW.column = value
END IF;

didn't work.

Answer 1

MySQL has function called DEFAULT(), which gets the default value from specified column.

UPDATE tbl SET col = DEFAULT(col);

MySQL Reference