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 vote309 views1 answer
Sql quary stuf
SQL
0 vote303 views3 answers
Java hide mysql login credentials
SQL
0 vote284 views1 answer
Hw to delete a procedure in pl sql
SQL
10 votes317 views2 answers
Doublon sql
SQL
8 votes310 views2 answers
Phpmyadmin default password
SQL
0 vote283 views1 answer
Mysql_error replacement
SQL
5 votes278 views2 answers
Copy data from one database to another
SQL
7 votes301 views3 answers
SQL create a new table
SQL
0 vote270 views1 answer
Mssql describe stored procedure sqlcmd
SQL
0 vote366 views1 answer
Drop table BigQuery table columns
SQL