Mysql coalesce

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

Similar codes

0 vote130 views1 answer
How much space does sql server take per row
SQL
6 votes105 views2 answers
Mysqldump password in file
SQL
0 vote50 views1 answer
FindAllBy
SQL
2 votes70 views1 answer
Latest record in sql
SQL
0 vote102 views1 answer
Get enginge db mysql
SQL
79 votes268 views6 answers
Grepper code
SQL
0 vote97 views1 answer
Find how many table doesn't contain column in mysql
SQL
-2 votes109 views1 answer
Create trigger syntax
SQL
1 vote177 views1 answer
Postgres set column based on another column
SQL
0 vote120 views1 answer
Is not numeric sql
SQL