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 vote380 views1 answer
Groupby sort sql hive
SQL
1 vote375 views1 answer
Sql dcl
SQL
0 vote343 views2 answers
Show slave status mysql
SQL
2 votes424 views2 answers
MySql FULL OUTER JOIN
SQL
0 vote364 views1 answer
How to to get current date in sql
SQL
7 votes379 views1 answer
Sql pagination oracle
SQL
0 vote392 views1 answer
Query builder doctrien return sql
SQL
1 vote344 views1 answer
Mysql show data from table
SQL
0 vote346 views1 answer
T-SQL Retry (deadlock)
SQL
14 votes376 views1 answer
Oracle alter table add column not null
SQL