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 vote144 views1 answer
SQL Where-Klausel
SQL
5 votes106 views1 answer
Mysql change primary key
SQL
0 vote205 views1 answer
Which MySQL data type to use for storing boolean values
SQL
58 votes274 views4 answers
Mysql drop column
SQL
-3 votes115 views2 answers
How to enable mysql authentication on ubuntu 18.04
SQL
0 vote119 views1 answer
Mysql docker image arjun
SQL
0 vote114 views1 answer
C# datetime to sql server datetime
SQL
1 vote107 views1 answer
Mysql select another database
SQL
5 votes106 views1 answer
Sql first day of current year
SQL
11 votes117 views6 answers
Distinct sql
SQL