MySQL coalesce() Function Example

MySQL coalesce() Function Example

Open your MySQL Query Editor then copy & paste the below code to get the value of coalesce() MySQL Function Example:

  select coalesce(NULL, NULL*10, -10, 10*NULL, NULL);

MySQL coalesce() Function:
returns first non null value from a list of values or expressions

MySQL coalesce() Function Example - Result in MySQL Query Editor

 

Related Tutorial Examples

1. MySQL isnull() Function Example
2. MySQL strcmp() Function Number Value Example
3. MySQL strcmp() Function NULL Value Example
4. MySQL strcmp() Function Example
5. MySQL interval() Function Example
6. MySQL IF() Function Boolean Value Example
7. MySQL Stored Procedure Function: How to Drop a Stored Procedure Example
8. MySQL Stored Procedure Function: Making hello world Function using aliase Example
9. MySQL Stored Procedure: Creating Table using Stored Procedure Example
10. Aliase column name in SQL Command MySQL Example