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 vote354 views1 answer
Error code 1292 mysql workbench
SQL
2 votes365 views2 answers
Get all tables using like
SQL
0 vote335 views1 answer
Oracle search columns in schema
SQL
0 vote317 views1 answer
Check sql query executed wp
SQL
0 vote387 views1 answer
Create-table-with-index-organization
SQL
0 vote357 views1 answer
Sql period overlap
SQL
0 vote353 views1 answer
Sql count null values in all columns
SQL
1 vote351 views1 answer
Sql pick random row
SQL
0 vote338 views1 answer
Java spring boot connect to sql server
SQL
0 vote404 views1 answer
Mysl like insert a variable
SQL