MySQL IFNULL() Function String Value Example
Open your MySQL Query Editor then copy & paste the below code to get the value of IFNULL() MySQL String Value Example:
-- SELECT IFNULL('Expression1','Expression2'), IFNULL('String1','String2'), IFNULL(NULL,'Expression2'); -- -- MySQL IFNULL() Function Deals With Two Expressions -- -- if [Expression1/Value1] evaluates to NULL, returns [Expression2/Value2] -- else [Expression1/Value1]
-- is comment in MySQL -- in fact it is comment in MSSQL and Oracle as well
MySQL IFNULL() Function String Value Example - Result in MySQL Query Editor
Related Tutorial Examples
- MySQL IFNULL() Function Datetime Example
- MySQL IFNULL() Nested Function Example
- MySQL IFNULL() Function Number Example
- MySQL IFNULL() Function Boolean Example
- MySQL IFNULL() Function NULL Value Example
- MySQL NULLIF() Function NULL Value Example
- How to Find MySQL Stored Procedure or Function Information
- SELECT all rows of a Table using SQL Command MySQL Example
- Inserting data into Table(s) using SQL Command MySQL Example
- Creating a Table(s) with datatype using SQL Command MySQL Example
No comments:
Post a Comment
leave your comments here..