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 vote120 views1 answer
How to print records of employees hired in particular month in oracle
SQL
0 vote123 views1 answer
Make parameters nullable in sql server
SQL
23 votes108 views6 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
1 vote110 views1 answer
Pentaho + pasar de excel a sql
SQL
1 vote133 views2 answers
How to combine 2 tables in MySQL
SQL
0 vote127 views1 answer
Yesql
SQL
1 vote117 views1 answer
Xampp import sql file command line
SQL
1 vote118 views1 answer
Create table tablename as select * from tablename
SQL
22 votes117 views3 answers
Sql cheat sheet
SQL
0 vote121 views1 answer
Postgresql on conflict pair
SQL