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 vote260 views1 answer
Mysql identified by syntax error
SQL
0 vote258 views1 answer
How to find unique key in sql
SQL
1 vote270 views3 answers
Showing all columns in an sqlite table
SQL
2 votes320 views1 answer
Remove foreign key constraints in postgres
SQL
1 vote256 views1 answer
Index a database column sql
SQL
25 votes300 views4 answers
Import mysql dump command line
SQL
0 vote318 views1 answer
Osm2pgsql mac
SQL
-2 votes280 views2 answers
Union all in sql
SQL
1 vote262 views1 answer
Sql where last 12 months
SQL
0 vote248 views1 answer
Object Information
SQL