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 vote190 views2 answers
Sql join on comma separated field
SQL
2 votes199 views1 answer
Sql server case sensitive search
SQL
4 votes192 views1 answer
Oracle select first 10 rows
SQL
0 vote172 views1 answer
Sqlite3 not commit
SQL
0 vote198 views1 answer
Oracle list datafiles
SQL
0 vote201 views1 answer
Connect to nginx server mysql remotly
SQL
13 votes211 views2 answers
Sqlite rename table
SQL
9 votes198 views4 answers
Mysql set id auto increment
SQL
0 vote202 views3 answers
Classement rang mysql 7
SQL
0 vote202 views2 answers
Sql trigger difference between for and after
SQL