MySQL IF() Function Boolean Example
Open your MySQL Query Editor then copy & paste the below code to get the value of IF() MySQL Function Boolean Example:
SELECT IF(TRUE, TRUE, FALSE), IF(FALSE, TRUE, FALSE), IF(NULL, TRUE, FALSE) ; -- MySQL IF() Function Compares Three Expressions -- -- if [Expression1/Value1] evaluates to true, returns [Expression2/Value2] -- else [Expression3/Value3]
-- is comment in MySQL -- in fact it is comment in MSSQL and Oracle as well
MySQL IF() Function Boolean Example - Result in MySQL Query Editor
Related Tutorial Examples
- MySQL IF() Function Number Value Example
- MySQL IF() Nested Function Example
- MySQL IF() Function NULL Value Example
- MySQL IF() Function Datetime Value Example
- MySQL IF() Function String Value Example
- MySQL IFNULL() Function NULL Value Example
- MySQL Stored Procedure Function: How to Drop a Stored Procedure Example
- MySQL Stored Procedure Function: Making hello world Function using aliase Example
- MySQL Stored Procedure: Creating Table using Stored Procedure Example
- Creating a Table(s) with datatype using SQL Command MySQL Example

No comments:
Post a Comment
leave your comments here..