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

5 votes304 views3 answers
Oracle first day of last year
SQL
1 vote296 views2 answers
Restart identity cascade
SQL
5 votes326 views2 answers
Mysqldump password
SQL
15 votes311 views5 answers
If null mysql
SQL
0 vote301 views1 answer
Create new schema mysql
SQL
3 votes301 views3 answers
C# sql select
SQL
5 votes295 views1 answer
Alter table add comment oracle
SQL
0 vote331 views1 answer
Select year from dual oracle
SQL
28 votes321 views6 answers
Foreign key
SQL
1 vote340 views1 answer
Alter database datafile maxsize 32g
SQL