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

1 vote329 views1 answer
Join to find results not in another table
SQL
0 vote300 views1 answer
Mysql group rows with same value
SQL
10 votes315 views2 answers
Reset mysql root password mac
SQL
1 vote352 views1 answer
Sql server delete top 1000
SQL
0 vote288 views1 answer
Plsql trigger insert update
SQL
0 vote339 views1 answer
Drop-toys-table
SQL
0 vote406 views1 answer
Mysql get longest string in column
SQL
0 vote330 views1 answer
Sql select where more than one record exists
SQL
4 votes381 views4 answers
Mysql get date from datetime
SQL
0 vote318 views1 answer
Jdbc sql connection string
SQL