EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Software Development Software Development Tutorials MariaDB Tutorial MariaDB IF
 

MariaDB IF

Sohel Sayyad
Article bySohel Sayyad
EDUCBA
Reviewed byRavi Rathore

Updated June 3, 2023

MariaDB IF

 

 

Definition of MariaDB IF Statement

MariaDB provides an IF conditional statement to the user, In which we can implement a basic IF conditional statement, IF search condition shows true or false statement during the SQL query execution. If the search condition does not match the specified value, then the SQL statement executes the else statement and consists of one or more words. IF () function totally differs from the IF statement as explained above statement. Normally IF statements have three different forms: IF – THEN statement, IF – THEN – ELSE statement, and IF-THEN – ELSEIF – ELSE statement. With the conditional statement, we can perform different operations.

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

Syntax:

If condition
begin
if above-mentioned condition is true then it execute following expression
true expression;
end
else
begin
if above-mentioned condition is false then it execute following expression
false expression
end;

Explanation:

In above syntax, we use an IF conditional statement with the condition, here IF condition is true, then it executes the true expression otherwise, it goes to the else part, and it runs the false expression when the IF condition is false, and we also use begin and end keywords to identify the IF – ELSE statement as shown in above syntax.

Flow Chart

Let’s set how the IF statement is working with the help of a flow chart as follows.

MariaDB IF

Explanation:

MariaDB IF statement should return a Boolean value.

After that, we can specify the select statement with an expression we need to execute, but it should be in parentheses.

In the above flowchart, we use START and EXIT in the IF statement to determine the IF statement.

The ELSE condition of the IF statement is optional and depends on the user.

How if statement works in MariaDB?

Let’s see how the IF statement works in MariaDB as below.

In IF statements, all the specified conditions with IF statements are executed sequentially, which means it executes the first condition from the statement. So let’s see how we can use IF statements in three different ways as follows.

1. IF – THEN statement

In this type, we only use IF – THEN statement, in which it executes only the IF part if the condition is true otherwise, it executes the THEN part, that means if the condition is false.

2. IF – THEN – ELSE statement

In this type, we use IF – THEN – ELSE statement, in which if condition is true, then it executes if expression, and if condition is false, then it executes the else part of the IF statement.

3. IF – THEN – ELSEIF statement.

In this, we used an ELSEIF statement with different expressions, and it executed the same as the above types.

When a condition is found that means true, then the IF-THEN-ELSE statement will execute related expressions otherwise not evaluate any expression.

If the condition is false, that means the ELSE part of the IF-THEN-ELSE statement will be executed. This is very impotent, not that the ELSEIF and ELSE both condition are optional.

Examples

Let’s see the different examples of IF statements in MariaDB below.

set @myId = (SELECT IF ((SELECT count(2) FROM `emp` WHERE `emp_id` = 2 AND `emp_dept`='2') = 3, TRUE, FALSE));

Explanation:

In the above example, we use the IF statement with the select and where clause, as shown in the above statement. Here we set the different values for the specified column mentioned in the above statement with a Boolean expression. We illustrate the final output of the above query using the following snapshot.

MariaDB IF 1

DELIMITER $$
USE sample $$
DROP PROCEDURE IF EXISTS my_demo $$
CREATE PROCEDURE
my_demo ()
BEGIN
IF 1=1
THEN
SELECT 1;
END IF;
END $$

Explanation:

In the above example, we use a delimiter to create a new procedure using an if statement. We use a sample database in this example, as shown in the above statement. After that, we create a new procedure using the create procedure statement, here, we create my_demo procedure. After that, we use IF – THEN statement as shown in the above statement. We illustrate the final output of the above query using the following snapshot.

MariaDB IF 2

Now let’s see how we can combine all IF statements as follows.

DELIMITER //
CREATE FUNCTION sample_demo ( count INT )
RETURNS varchar(20) DETERMINISTIC
BEGIN
DECLARE size varchar(20);
IF count < 500 THEN
SET size = 'Low';
ELSEIF count >= 500 AND count <= 4000 THEN
SET size = 'Medium';
ELSE
SET size = 'High';
END IF;
RETURN size;
END; //
DELIMITER ;

Explanation:

In the above example, we create a function name as sample_demo as shown in the above statement in which we set different values by using the IF statement such IF count is less than 500, THEN we set size is low, similarly ELSE IF count >= 500 AND count <= 4000 THEN we set size is medium and ELSE size is high. After that, we return the size, then the end function, and the end IF statement. We illustrate the final output of the above query using the following snapshot.

snapshot 3

Now see a simple example of an IF – ELSE statement as follows.

DELIMITER $
CREATE PROCEDURE my_pr()
BEGIN
IF 2 = 2 THEN
SELECT 'TRUE';
ELSE
SELECT 'FALSE';
END IF;
END $
DELIMITER ;
CALL my_pr;

Explanation:

In the above example, we created a procedure name demo1, as shown in the above statement, in which we use the IF ELSE statement, here condition is that IF we have 4 = 4, then select the true value otherwise, it returns the false values. When we execute the above statement, it simply shows the query is ok, so we need to execute the procedure by using the above-mentioned statement, such as call my_pr. We illustrate the final output of the above query using the following snapshot.

MariaDB IF 4

In the above screenshot, we show the procedure result, and when we run the call my_pr, the result is shown in the screenshot below.

CALL my_pr;

call my_pr

Conclusion

We hope from this article, you have understood the MariaDB IF statement. From this article, we have learned the basic syntax of the MariaDB IF statement, and we also see different examples of the MariaDB IF statement. This article taught us how and when to use MariaDB IF statements.

Recommended Articles

We hope that this EDUCBA information on “MariaDB IF” was beneficial to you. You can view EDUCBA’s recommended articles for more information.

  1. MariaDB Grant All Privileges
  2. MariaDB UPDATE
  3. AUTO INCREMENT in MariaDB
  4. MariaDB MaxScale

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

© 2025 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA
Free Software Development Course

Web development, programming languages, Software testing & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA Login

Forgot Password?

🚀 Limited Time Offer! - 🎁 ENROLL NOW