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 vote118 views1 answer
How to use query in nosql
SQL
6 votes120 views2 answers
Mysql concatenate two columns into one
SQL
0 vote125 views1 answer
Plpgsql raise notice
SQL
1 vote139 views2 answers
Oracle leftmost characters
SQL
0 vote129 views2 answers
Mysql get routine parameter list
SQL
0 vote148 views1 answer
Wordpress sql find and replace
SQL
5 votes128 views1 answer
Add column table sql default value
SQL
0 vote162 views1 answer
Jpa generationtype sequence mysql
SQL
0 vote238 views1 answer
Sql server query all database objects
SQL
1 vote122 views1 answer
Psql datetime grather than
SQL