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 votes142 views5 answers
Sql select
SQL
0 vote125 views1 answer
INSERT INTO table using OpenQuery
SQL
0 vote137 views1 answer
SQL FROM-Klausel
SQL
3 votes133 views1 answer
Sql server version query
SQL
1 vote144 views1 answer
Create sqlite database in laravel
SQL
3 votes131 views3 answers
Into in sql
SQL
0 vote169 views1 answer
Jpa generationtype sequence mysql
SQL
0 vote143 views1 answer
Psql show db
SQL
0 vote129 views1 answer
ORACLE SUBSTRING SYNTAX
SQL
1 vote136 views1 answer
Postgres concat_ws
SQL