MySQL Trigger if then ElseIf else's useCREATE PROCEDURE DBName.Proc_getgrade(Stu_no varchar(20),Cour_no varchar(10)) BEGINDECLARE Stu_gradeFloat; SelectGradeIntoStu_gradeFromGradewhereStudent_no=Stu_noandCourse_no=Cour_no; IfStu_grade>=90 Then
From http://www.cnblogs.com/ggjucheng/archive/2012/12/16/2820834.html
English from http://docs.oracle.com/javase/tutorial/java/nutsandbolts/if.html
If-then statement
If-then statements are the most basic control flow statements. It
Use of case, simple case functionA simple case expression that uses an expression to determine the return value.
Grammar:
Case Search_expression
When Expression1 THEN RESULT1
When Expression2 THEN result2
...
When Expressionn THEN Resultn
ELSE
4.2.2 The switch statement that expresses the side-by-side condition selection: If ... If...... If......In the real world, there is a special kind of conditional choice:If it is sunny tomorrow, I will wear a T-shirt;If it is cloudy tomorrow, I will
(Hdu step 8.1.8) Team Queue (when a person queues, if there is a person he knows before, then he can directly rank behind the person he knows, or else he will be at the end of the Team. In this case), javaqueue
Question:
Team Queue
If ... Then ... Else statementConditionally executes a set of statements based on the value of an expression.
If condition Then statements [Else elsestatements]
Or, use block-form syntax:
If condition Then[Statements][ElseIf condition-n
Like what:Select FirstName + lastName from employeeHere I want to first determine whether LastName is empty, if it is empty LastName returns the specified default value, and returns the value in the database without being empty.Select FirstName +
In Oracle development, the conditional expressions between If and then are full of "art" and require us to discover and appreciate them.
Appreciation 1: Three-value Logic
If an expression contains a null value, what is the final result of the
The conditional judgment statement in the shell is an upgrade to the previous "conditional test statement in the shell", meaning that the preceding test statement serves the IF~THEN~FI statement for the current judgment statement.We're still rolling
If statement a method that makes a variable or some other type of data to make a decision. For example, you may have a
Script to check if the Boolean value is True or FALSE, or the variable contains a number or string value.
Use the IF statement
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.