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

0 vote122 views1 answer
Top frequency in sql server
SQL
0 vote123 views1 answer
Parent: [Error: SQLITE_READONLY: attempt to write a readonly database] {
SQL
0 vote123 views1 answer
MQL4 mql4 run ea on all symbols by adding to just one chart
SQL
0 vote123 views1 answer
R dbConnect(odbc::odbc() to ms sql server remote
SQL
2 votes124 views1 answer
How to check if a row is null in sql
SQL
4 votes117 views1 answer
Check database name postgresql
SQL
6 votes171 views3 answers
[2021-10-05T13:43:48.961Z] error Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote125 views1 answer
Number(10 2) in sql means
SQL
8 votes133 views2 answers
Alert table name mysql
SQL
-2 votes128 views1 answer
Group functions in sql
SQL