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

5 votes188 views2 answers
Add column postgres with default value
SQL
6 votes263 views3 answers
Mysql remove user privileges
SQL
0 vote287 views1 answer
ORA-00942
SQL
2 votes186 views3 answers
Access denied for user 'root'@'localhost' mariadb
SQL
16 votes199 views4 answers
Sort by sql
SQL
3 votes184 views1 answer
Mysql CURRENT_TIMESTAMP()
SQL
1 vote196 views3 answers
Union in sql
SQL
4 votes261 views1 answer
Sql delete multiple conditions
SQL
1 vote202 views1 answer
Oracle sql create or replace view
SQL
0 vote206 views1 answer
Add sqlite3 in lumen
SQL