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

1 vote342 views1 answer
Full sql mode
SQL
0 vote375 views1 answer
Create a sql server database programmatically
SQL
0 vote319 views1 answer
Deleted table in sql trigger
SQL
0 vote352 views1 answer
Mysql sum with group by
SQL
0 vote365 views1 answer
Start stop mysql linux
SQL
0 vote353 views1 answer
ORACLE SUBSTRING SYNTAX
SQL
0 vote353 views1 answer
Check sql database table lock
SQL
0 vote368 views1 answer
Codeigniter MySQL - Issue with SELECT & GROUP BY
SQL
0 vote295 views1 answer
Denied
SQL
1 vote346 views1 answer
Oracle aleter trigger ora-01031
SQL