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 vote99 views2 answers
Find Overlapping sql
SQL
1 vote94 views1 answer
Check constraint to check if date greater than todays date
SQL
4 votes96 views1 answer
Search column by name mysql
SQL
2 votes161 views5 answers
Install postgresql 10 centos 7
SQL
0 vote102 views1 answer
Sql offfset
SQL
0 vote55 views1 answer
Insert and initialize a SQL column with value dependent on another column data
SQL
9 votes113 views5 answers
Laravel to sql
SQL
1 vote96 views1 answer
Postgresql must appear in the group by clause or be used in an aggregate function
SQL
0 vote103 views1 answer
Which sql statement would you use to remove a view called emp_dept_vu from your schema?
SQL
-1 vote105 views1 answer
Mysql order by on condition
SQL