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 vote302 views1 answer
Csv to sqlite python
SQL
0 vote298 views1 answer
T-SQL Create Trigger
SQL
4 votes238 views3 answers
Create table if not exists postgresql
SQL
19 votes290 views6 answers
What is mySQL
SQL
0 vote303 views1 answer
Shortcut run sql pgadmin
SQL
0 vote314 views1 answer
Oracle sql developer closed connection
SQL
0 vote286 views1 answer
Trigger stock phpmyadmin output message
SQL
0 vote282 views2 answers
Demmarrer un service mysql teminal cmd
SQL
1 vote280 views1 answer
Get table which have specific columns in mysql
SQL
1 vote304 views1 answer
Epoch time converter in snowflake
SQL