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

6 votes336 views2 answers
How to get yesterday date in mysql
SQL
1 vote321 views1 answer
Mariadb alter user host
SQL
-1 vote317 views1 answer
How to switch user in mysql
SQL
0 vote317 views2 answers
Nested query
SQL
1 vote298 views1 answer
Input in mysql
SQL
2 votes262 views1 answer
Sql group by different columns
SQL
5 votes353 views2 answers
Functions
SQL
1 vote331 views1 answer
Where database run
SQL
0 vote303 views1 answer
Json_remove mysql
SQL
50 votes450 views6 answers
Sql count duplicate rows
SQL