MySQL isnull() Function Example

MySQL isnull() Function Example

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

  select isnull(0), isnull(-10), isnull(NULL*10);

MySQL isnull() Function:
Check whether the given value or expression is null or not
returns 1 if null and 0 if non-null value

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

 

Related Tutorial Examples

  1. MySQL coalesce() 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: Variable Example
  8. MySQL Stored Procedure: Batch Salary Increment Example
  9. Operator precedence in SQL Command MySQL Example
  10. Arithmetic operators in SQL Command MySQL Example

No comments:

Post a Comment

leave your comments here..