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 vote184 views1 answer
Get from database the most recent data limit by 5
SQL
13 votes213 views3 answers
Mysqldump structure only
SQL
0 vote148 views1 answer
Mysql read row
SQL
0 vote139 views1 answer
How to get employee having maximum experience in mysql
SQL
3 votes151 views2 answers
Sql server current date without time
SQL
0 vote148 views1 answer
How to solve ERROR 1049 (42000): Unknown database 'hbtn_0c_0'
SQL
0 vote180 views1 answer
Cannot insert duplicate key in object 'dbo.Instructor'. The duplicate key value is (2).
SQL
0 vote152 views1 answer
How to see password mysql vestacp
SQL
2 votes162 views5 answers
Tablespace ORACLE
SQL
24 votes168 views5 answers
List mysql users
SQL