Set the value of a column to its default value
Deriving from insert into
, I just tried this, and it is as simple as
update mytable
set my_column = default
where my_column is null
See sqlfiddle
Deriving from insert into
, I just tried this, and it is as simple as
update mytable
set my_column = default
where my_column is null
See sqlfiddle