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 vote168 views1 answer
Mysql make date from 2 column
SQL
0 vote174 views1 answer
MySQL INSERT IGNORE Statement
SQL
0 vote157 views1 answer
Sql comparison operators
SQL
0 vote178 views1 answer
Postgresql check total storage
SQL
1 vote172 views1 answer
Sql in array query
SQL
1 vote177 views1 answer
Alter table column size oracle
SQL
0 vote165 views1 answer
Plpgsql if statement
SQL
2 votes152 views2 answers
Sqlite_busy: database is locked
SQL
0 vote166 views1 answer
Aktor yang pernah terlibat lebih dari 3 film di sql
SQL
1 vote156 views1 answer
Postgresql must appear in the group by clause or be used in an aggregate function
SQL