Write the use of IE THEN... ELSE statement.
Answers
Answer:
ELSEIFOptional. You would use the ELSEIF condition when you want to execute a set of statements when a second condition (ie: condition2) is TRUE.ELSEOptional. You would use the ELSE condition when you want to execute a set of statements when none of the IF or ELSEIF conditions evaluated to TRUE.
Note
Once a condition is found to be TRUE, the IF-THEN-ELSE statement will execute the corresponding code and not evaluate the conditions any further.
If no condition is met, the ELSE portion of the IF-THEN-ELSE statement will be executed.
It is important to note that the ELSEIF and ELSE portions are optional.
Example
The following is example using the IF-THEN-ELSE statement in a MySQL function:
hope this can help you
IF condition is true do something or else do something else