Coalesce mysql

Mysql coalesce

#Avoid sum null
SELECT SUM(COALESCE(field_with_null_values, 0)) as s FROM tablename

#Avoid concat string null
SELECT CONCAT(name_never_null, ' ', COALESCE(surname_with_null_values, '')) as complete_name FROM users

Source: grepper.com

Coalesce mysql

The COALESCE() function returns the first non-null value in a list.

Example : SELECT COALESCE(NULL, NULL, 'W3Schools.com', NULL, 'Example.com');

output : 'W3Schools.com'

-1

Source: grepper.com

Similar codes

0 vote292 views1 answer
How to get nth number in sql
SQL
0 vote281 views1 answer
Mysql sum with group by
SQL
0 vote272 views1 answer
Oserror mysql_config not found virtualenv
SQL
1 vote262 views1 answer
User privileges postgresql information_schema
SQL
4 votes270 views1 answer
Oracle select first 10 rows
SQL
0 vote291 views1 answer
Mysql default tls v1.3 ciphersuites
SQL
0 vote267 views1 answer
Generate random & unique mysql string
SQL
0 vote278 views1 answer
Which lock mode is not available in sql
SQL
0 vote260 views1 answer
Select only one row sql
SQL
1 vote290 views1 answer
Code: "ER_TRUNCATED_WRONG_VALUE", errno: 1292, sqlMessage: "Incorrect date value: '2021-03-20T18:30:00.000Z' for column 'mgfdate' at row 1", sqlState: "22007", index: 0, …}
SQL