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 vote166 views2 answers
Impala rename column name
SQL
0 vote140 views1 answer
Mysql jdbc timezone
SQL
1 vote149 views1 answer
Date_part mysql
SQL
1 vote172 views1 answer
Sql view where tables have same column name combine results
SQL
1 vote178 views1 answer
Mysql sort by date column
SQL
0 vote145 views1 answer
SQL authentication error
SQL
3 votes140 views2 answers
Sql paging query
SQL
0 vote143 views1 answer
How to use group_concat in sql server
SQL
0 vote149 views1 answer
Mysql count with two joins
SQL
1 vote199 views1 answer
Mysql connect command
SQL