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

1 vote378 views1 answer
Opensuse restart MySQL
SQL
0 vote337 views1 answer
Count number of entires by months sql
SQL
0 vote356 views1 answer
How to print sql query
SQL
18 votes275 views2 answers
How to get all the tables displayed in oracle
SQL
0 vote317 views1 answer
Can we rollback data that are deleted using DELETE
SQL
7 votes338 views1 answer
Sql server management studio turn on line numbers
SQL
4 votes364 views6 answers
List all tables in postgres
SQL
0 vote318 views3 answers
Get free card roblox
SQL
19 votes330 views5 answers
Mysql between date range
SQL
0 vote385 views1 answer
Generate sql from specific migration ef core
SQL