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 vote112 views1 answer
Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list'
SQL
16 votes118 views3 answers
Delete row psql
SQL
3 votes113 views4 answers
Psql list tables in schema
SQL
6 votes117 views2 answers
Mysql set primary key
SQL
4 votes79 views1 answer
Oracle sleep
SQL
0 vote112 views1 answer
Opensuse status MySQL
SQL
7 votes119 views1 answer
Oracle pagination query offset
SQL
0 vote109 views1 answer
Mysql earlier than date
SQL
0 vote128 views1 answer
Allow null in psql
SQL
1 vote122 views1 answer
Drop function
SQL