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 vote129 views1 answer
Oracle user last connected
SQL
0 vote126 views1 answer
Best sql collation
SQL
0 vote165 views5 answers
Select concat alter table mysql
SQL
8 votes133 views1 answer
Oracle all_source package body
SQL
0 vote171 views1 answer
Sql pivot table
SQL
1 vote137 views2 answers
Sql server concat string and int
SQL
1 vote133 views1 answer
Multiple count in sql
SQL
-1 vote135 views3 answers
MySQL shutdown unexpectedly
SQL
0 vote120 views1 answer
Sqlite3 now
SQL
3 votes155 views1 answer
Apex set debug level
SQL