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 vote276 views1 answer
Mysql listing get a particu particular user firsdt
SQL
0 vote250 views1 answer
Sql where time stamp is in between
SQL
2 votes274 views1 answer
Mysql change data type of column
SQL
92 votes466 views6 answers
Substring
SQL
0 vote283 views1 answer
Ms sql print more than 1 variable
SQL
0 vote260 views1 answer
Excute raw query
SQL
1 vote284 views1 answer
Customer using hdfc bank sql query
SQL
0 vote265 views1 answer
How to find the most occuring in SQL
SQL
1 vote251 views1 answer
Sql exclude duplicates and find even id
SQL
1 vote264 views1 answer
Postgres first_value in gropby
SQL