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 vote256 views1 answer
Oracle string substitution
SQL
0 vote216 views1 answer
Mysql select top 2
SQL
0 vote238 views1 answer
Store query result in variable sql
SQL
0 vote267 views1 answer
Mysqlcli how to load external sql file
SQL
0 vote263 views1 answer
List column names of multiple tables psql
SQL
20 votes261 views2 answers
Counting in sql
SQL
0 vote264 views1 answer
Check sql database table lock
SQL
0 vote260 views1 answer
Compression of dabatase mysqldumo
SQL
1 vote281 views1 answer
Cross schema query oracle 2 users
SQL
1 vote254 views2 answers
Postgresql list columns
SQL