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 vote158 views1 answer
Sql_inner_join
SQL
4 votes134 views2 answers
Oracle default date format
SQL
0 vote126 views1 answer
Update using case in mysql
SQL
0 vote135 views1 answer
SAP Return
SQL
1 vote151 views2 answers
Setval max id postgresql sequence
SQL
0 vote152 views1 answer
Sql select sum group by id laravel join
SQL
4 votes135 views2 answers
Sql vs mysql
SQL
0 vote154 views2 answers
Transaction php
SQL
5 votes147 views1 answer
Oracle asynchronous update
SQL
3 votes137 views2 answers
Mysql create timestamp column
SQL