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

56 votes296 views5 answers
Psql create user
SQL
1 vote103 views1 answer
Pv mysql import
SQL
2 votes109 views1 answer
Mysql virtual column
SQL
0 vote115 views1 answer
Where name ends in SQL
SQL
0 vote105 views1 answer
Allow all local clients (local socket connections) to connect to the kodekloud_db1
SQL
1 vote124 views1 answer
Postgres left join
SQL
0 vote113 views1 answer
Sql find record cannot cast date
SQL
5 votes178 views1 answer
Oracle asynchronous procedure
SQL
32 votes108 views6 answers
Insert select
SQL
2 votes105 views2 answers
Get all tables using like
SQL