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 vote252 views3 answers
Get count of null in column sql
SQL
0 vote160 views1 answer
Restart sql server command line linux
SQL
0 vote227 views1 answer
Sql select rows between 1000 and 2000
SQL
0 vote234 views1 answer
Dynamic where clause in sql server stored procedure
SQL
1 vote172 views1 answer
Update foreign key value in mysql
SQL
1 vote164 views3 answers
Mysql Server Start
SQL
2 votes211 views1 answer
Datefromparts mssql
SQL
0 vote170 views1 answer
Cara menampilkan tabel yang tidak mengandung kata di sql server
SQL
6 votes161 views2 answers
Find mysql version linux
SQL
0 vote178 views1 answer
Postgresql in vs any performance
SQL