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 vote338 views1 answer
Cube oracle
SQL
-1 vote293 views3 answers
Check table exist postgresql
SQL
1 vote737 views1 answer
Athena query timestamp greater than
SQL
1 vote334 views1 answer
T-sql disable system versioning
SQL
0 vote315 views1 answer
Sqlite löschen einer tabelle
SQL
0 vote297 views1 answer
Commit transaction sql
SQL
19 votes310 views6 answers
Sql drop table if exists
SQL
3 votes292 views1 answer
Oracle user quota on tablespace
SQL
1 vote294 views1 answer
Oracle apex run 404
SQL
0 vote359 views2 answers
Sql query print strings and int
SQL