IFNULL()
This page is part of MariaDB's Documentation.
The parent of this page is: Functions for MariaDB Enterprise Server
Topics on this page:
Overview
A description for this Function has not yet been added to this Documentation.
EXAMPLES
SELECT IFNULL(10,20) AS result;
+--------+
| result |
+--------+
| 10 |
+--------+
SELECT IFNULL(NULL,1) AS result;
+--------+
| result |
+--------+
| 1 |
+--------+
SELECT IFNULL(10/0,2) AS result;
+--------+
| result |
+--------+
| 2.0000 |
+--------+
Warning (Code 1365): Division by 0
SELECT IFNULL(0/0,'first expression is NULL') AS result;
+--------------------------+
| result |
+--------------------------+
| first expression is NULL |
+--------------------------+
Warning (Code 1365): Division by 0
CHANGE HISTORY
EXTERNAL REFERENCES
Additional information on this topic may be found in the MariaDB Public Knowledge Base.