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 vote356 views1 answer
Unable to convert mysql date/time value to system.datetime
SQL
0 vote385 views2 answers
Mysql cast to varchar
SQL
58 votes640 views6 answers
Create new user in postgres
SQL
0 vote295 views2 answers
Postgresql could not start server mac
SQL
2 votes379 views2 answers
Asp.net core with postgresql deploy on ubuntu
SQL
0 vote328 views1 answer
Mysql grant user wildcard database
SQL
1 vote323 views2 answers
Sql convert datetime to year month
SQL
5 votes327 views1 answer
Update sql user password
SQL
0 vote344 views1 answer
Sql composite key
SQL
1 vote352 views1 answer
Spark sql concatenate string and int
SQL