If null don't update

UPDATE some_table SET
  column_1 = COALESCE(param_1, column_1),
  column_2 = COALESCE(param_2, column_2),
  column_3 = COALESCE(param_3, column_3),
  column_4 = COALESCE(param_4, column_4),
  column_5 = COALESCE(param_5, column_5)
WHERE id = some_id;

Source: stackoverflow.com

Similar codes

2 votes133 views1 answer
Oracle sql drop table purge
SQL
0 vote100 views0 answer
SQL
0 vote130 views1 answer
Trim sql oracle
SQL
0 vote137 views1 answer
Like sql for second letter of the family name
SQL
31 votes141 views1 answer
Postgresql add column with constraint
SQL
0 vote150 views1 answer
If column value is null then in mysql
SQL
38 votes201 views6 answers
Alter table mysql
SQL
0 vote148 views1 answer
Access denied for user 'root'@'localhost' (using password no) stackoverflow
SQL
0 vote144 views1 answer
Default order by in mysql
SQL
0 vote167 views1 answer
Where field is null sql knex
SQL