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

3 votes162 views1 answer
Force using index oracle
SQL
1 vote145 views1 answer
Sql server: difference between hashtable and table declared using declare keyword
SQL
0 vote145 views1 answer
Oracle enable chain
SQL
0 vote169 views1 answer
Import sql inside hide sql
SQL
16 votes150 views6 answers
Insert sql
SQL
0 vote136 views1 answer
Mysql change default collation
SQL
0 vote128 views2 answers
Mysql slave status
SQL
0 vote160 views1 answer
Repeatable read trong sql server
SQL
7 votes148 views3 answers
Convert ansi sql
SQL
9 votes153 views5 answers
Laravel to sql
SQL