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

2 votes171 views1 answer
Mysql sql add created updated timestamp to existing table
SQL
2 votes185 views3 answers
Copy data from one table column to another table column in sql
SQL
-1 vote190 views1 answer
Mysql change database charset and collation
SQL
3 votes169 views1 answer
Sql server version query
SQL
0 vote162 views1 answer
Plpgsql coalesce equivalent for empty string
SQL
0 vote219 views1 answer
Double in sql server example
SQL
0 vote171 views1 answer
Alter table myisam to innodb
SQL
2 votes189 views1 answer
Oracle apex who is connected
SQL
5 votes216 views3 answers
Sql limit offset
SQL
13 votes126 views2 answers
Oracle all source
SQL