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

14 votes286 views4 answers
Remove record from table sql
SQL
0 vote298 views1 answer
Mysql change default collation
SQL
1 vote284 views1 answer
Mysql show queries running
SQL
8 votes281 views5 answers
Grant permission in postgres
SQL
13 votes285 views2 answers
Get tables in database sql
SQL
0 vote273 views1 answer
Having trouble running COUNT in my INSERT INTO statement
SQL
0 vote281 views1 answer
Into operator in sql
SQL
0 vote279 views1 answer
FIND LOWEST SALARY EARNER IN SQL
SQL
0 vote286 views1 answer
Drop index in sql
SQL
0 vote347 views2 answers
Insert data into multiple tables mysql
SQL