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 vote204 views1 answer
Select only one row sql
SQL
0 vote206 views6 answers
Unique key in sql
SQL
-1 vote163 views1 answer
Mysql how to set update or create
SQL
0 vote234 views1 answer
Where to find pg_hba.conf in ubuntu
SQL
11 votes281 views2 answers
Import mysql dump command line windows
SQL
0 vote219 views1 answer
From _sqlite3 import * ImportError: DLL load failed: Das angegebene Modul wurde nicht gefunden.
SQL
0 vote238 views1 answer
Why do we need data structure in sql
SQL
0 vote215 views1 answer
Oracle running queries sql
SQL
1 vote221 views1 answer
Postgresql create table with timestamp
SQL
0 vote211 views1 answer
How to connect pgadmin with excel
SQL