Reader small image

You're reading from  Learn SQL using MySQL in One Day and Learn It Well

Product typeBook
Published inApr 2024
PublisherPackt
ISBN-139781836205678
Edition1st Edition
Right arrow
Author (1)
Jamie Chan
Jamie Chan
author image
Jamie Chan

Jamie Chan is a tutor and freelance programmer with years of experience and a dedicated passion for sharing the joy of programming with as many people as possible. With seven bestselling programming books on Amazon, Jamie's publications stand out for their ability to break down complex concepts into simple terms. Additionally, each book includes complete projects at the end, enabling hands-on learning and a deep understanding of the concepts presented.
Read more about Jamie Chan

Right arrow

IF statement

 

Let’s start with the IF statement. The syntax for the IF statement is as follows:

 

IF condition 1 is met THEN do task A;

ELSEIF condition 2 is met THEN do task B;

ELSEIF condition 3 is met THEN do task C;

ELSE do task Z;

END IF;

 

The IF statement first checks if the first condition is met. If it is, it’ll perform task A. If it is not, it’ll move on to the first ELSEIF statement. If this condition is met, it’ll perform task B. If it is not, it’ll move down the ELSEIF statements until it finds a condition that is met. If no conditions are met, it’ll perform task Z.

 

There can be as many ELSEIF statements as needed.

 

In addition, both the ELSEIF and ELSE statements are optional. You do not need to include them if there are no other conditions to check.

 

However, if you omit the ELSE statement and there exists a case that is not fulfilled by any of the IF and ELSEIF statements...

lock icon
The rest of the page is locked
Previous PageNext Page
You have been reading a chapter from
Learn SQL using MySQL in One Day and Learn It Well
Published in: Apr 2024Publisher: PacktISBN-13: 9781836205678

Author (1)

author image
Jamie Chan

Jamie Chan is a tutor and freelance programmer with years of experience and a dedicated passion for sharing the joy of programming with as many people as possible. With seven bestselling programming books on Amazon, Jamie's publications stand out for their ability to break down complex concepts into simple terms. Additionally, each book includes complete projects at the end, enabling hands-on learning and a deep understanding of the concepts presented.
Read more about Jamie Chan