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 vote151 views2 answers
Postgres autoincrement primary key
SQL
0 vote195 views1 answer
Sql server: concatinate column value without trailing or leading comma
SQL
16 votes161 views3 answers
Update table from another table
SQL
0 vote171 views1 answer
Get foreign table names mysql
SQL
3 votes146 views1 answer
Oracle list user grants
SQL
0 vote182 views2 answers
While mysql
SQL
0 vote153 views1 answer
Select password from user mysql
SQL
1 vote173 views2 answers
Sqlstate[hy000]: general error: 1005 can't create table (errno: 150 "foreign key constraint is incorrectly formed")
SQL
0 vote202 views1 answer
Sql filter rows with condition
SQL
2 votes161 views2 answers
Mysql show table column comments sql
SQL