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 votes236 views2 answers
Postgres show table schema
SQL
4 votes228 views1 answer
Oracle session date format
SQL
0 vote249 views2 answers
Sql day from datetime
SQL
2 votes217 views1 answer
No data found oracle
SQL
3 votes222 views4 answers
Mysql create table from select statement
SQL
6 votes279 views2 answers
Oracle compile trigger
SQL
0 vote243 views1 answer
.sql File Run in PSQL
SQL
4 votes243 views2 answers
Mysql alter table set column unique
SQL
1 vote271 views2 answers
Laravel jwt generate token
SQL
4 votes220 views1 answer
Psql get sequences
SQL