Answers for "if null don't update"

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;

Posted by: Guest on January-10-2022

Code answers related to "if null don't update"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "if null don't update"

Code answers related to "if null don't update"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "if null don't update"

Code answers related to "if null don't update"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us