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

6 votes275 views1 answer
Phpmyadmin password root
SQL
0 vote279 views1 answer
Replace string in whole database mysql stackoverflow
SQL
0 vote276 views1 answer
Sql value exists in column
SQL
1 vote253 views2 answers
Procedure pl/sql
SQL
-1 vote303 views3 answers
PS5
SQL
4 votes285 views2 answers
Show all database inside postgresql
SQL
0 vote270 views1 answer
How to avoid duplicate records in sqlite
SQL
0 vote297 views1 answer
SQL FROM-Klausel
SQL
0 vote296 views1 answer
Mysqli_connect using prepare statement
SQL
0 vote299 views1 answer
Mysql value ends with
SQL