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

20 votes149 views4 answers
Sqlite create table if not exists
SQL
0 vote167 views1 answer
Sqlite version check
SQL
0 vote162 views1 answer
How to alter length character varying postgres
SQL
10 votes139 views2 answers
Linux command line import mysql database
SQL
0 vote178 views1 answer
SQL Cut part string
SQL
0 vote146 views1 answer
Add timestamp column to existing table ms sql server
SQL
1 vote142 views1 answer
Database Queries
SQL
4 votes110 views1 answer
Oracle sleep
SQL
0 vote184 views1 answer
Drop domain postgresql
SQL
0 vote162 views1 answer
Connect postgresql using a connection string
SQL