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

28 votes291 views6 answers
Distinct sql
SQL
1 vote324 views1 answer
Mysql sort by date column
SQL
23 votes322 views4 answers
How to uninstall postgresql in ubuntu
SQL
40 votes428 views4 answers
PostgreSQL add column
SQL
0 vote325 views1 answer
Case when with count and combining similar values in sql
SQL
1 vote388 views1 answer
Ora-06502: pl/sql: numeric or value error: character string buffer too small
SQL
0 vote296 views1 answer
Count column of tables psql
SQL
2 votes317 views1 answer
Sql select min value from multiple columns
SQL
12 votes311 views1 answer
How to change the value of a table in sql
SQL
92 votes598 views6 answers
Substring
SQL