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 vote178 views1 answer
Uuid sqlalcomany
SQL
0 vote176 views1 answer
Mysql export and import
SQL
0 vote171 views1 answer
Get server date mysql
SQL
0 vote215 views1 answer
Cartesian product sql
SQL
0 vote182 views1 answer
C# select Mysql
SQL
0 vote219 views1 answer
SQLSTATE[01000]: Warning: 1265 Data truncated for column 'job_type' at row 1 (SQL: insert into
SQL
7 votes188 views4 answers
Lowest salary in sql
SQL
0 vote188 views1 answer
Copying query result to excel
SQL
1 vote179 views1 answer
Psql filed name alter
SQL
2 votes185 views5 answers
Eloquest how to select one specific column in database
SQL