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 vote196 views1 answer
Inserting values with beekeeper get error null value in column createdAt violates not-null constraint
SQL
0 vote178 views2 answers
Sqlite
SQL
0 vote187 views1 answer
Sql on-premises
SQL
0 vote206 views1 answer
Sort by
SQL
0 vote195 views1 answer
Postgresql linux password
SQL
-1 vote134 views2 answers
On delete set default sql server
SQL
0 vote190 views1 answer
Typical max-connect-errors mysql
SQL
6 votes138 views2 answers
Spring data jpa application.properties mysql
SQL
1 vote187 views1 answer
Find a column in all tables postgres
SQL
0 vote172 views1 answer
Grepper sql workbench download
SQL