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

2 votes221 views1 answer
Mysql now format
SQL
15 votes197 views4 answers
Pl sql
SQL
2 votes212 views3 answers
Oracle show column of table
SQL
0 vote198 views1 answer
Não é possível executar uma operação DML dentro de uma consulta
SQL
7 votes209 views4 answers
What is my mysql version
SQL
0 vote207 views1 answer
Sql select with apostrohpe
SQL
5 votes196 views2 answers
Copy data from one database to another
SQL
1 vote229 views2 answers
Postgresql check privileges on schema
SQL
1 vote211 views2 answers
Sql queries practice
SQL
0 vote194 views1 answer
Pl/sql loop example
SQL