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 vote142 views2 answers
Postgresql change user role grant
SQL
4 votes158 views6 answers
List all tables in postgres
SQL
2 votes186 views1 answer
Dbms transaction (psql)
SQL
0 vote158 views1 answer
How to check common records in 2 table
SQL
0 vote142 views1 answer
Get number of rows in every table mysql
SQL
0 vote153 views1 answer
Sql how to get courses that i have made prerequisites
SQL
0 vote142 views1 answer
Nth max in my sql
SQL
0 vote158 views1 answer
Check if has alpha characters sql
SQL
1 vote168 views1 answer
Spark sql convert string to date
SQL
0 vote187 views1 answer
Mysql subtract month from timestamp
SQL