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 vote147 views1 answer
Oracle create program if no exists
SQL
0 vote148 views1 answer
Cast float mysql
SQL
1 vote168 views1 answer
Sql to mongodb query converter
SQL
50 votes235 views6 answers
Install mysql on ubuntu
SQL
0 vote138 views1 answer
Postgresql parse json array
SQL
2 votes133 views1 answer
Mysql find tables with name
SQL
0 vote135 views1 answer
How to get data between a last week in mysql
SQL
3 votes142 views1 answer
Only join in sql
SQL
8 votes159 views10 answers
Sql
SQL
0 vote154 views1 answer
Mysql cast null to string
SQL