MySQL

In this guide, we will explain how to create an AFTER DELETE Trigger in MySQL with syntax and examples. Description An AFTER DELETE Trigger means that MySQL will fire this trigger after…

In this guide, we will explain how to use the WHILE statement (WHILE LOOP) in MySQL with syntax and examples. Description In MySQL, the WHILE statement is used when you are not…

In this guide, we will explain how to use the RETURN statement in MySQL with syntax and examples. Description In MySQL, the RETURN statement is used when you are want to exit…

In this guide, we will explain how to use the REPEAT statement (REPEAT UNTIL LOOP) in MySQL with syntax and examples. Description In MySQL, the REPEAT statement is used when you do…

In this guide, we will explain how to use the LOOP statement in MySQL with syntax and examples. Description In MySQL, the LOOP statement is used when you are not…

In this guide, we will explain how to use the LEAVE statement in MySQL with syntax and examples. Description In MySQL, the LEAVE statement is used when you want to exit a…

In this guide, we will explain how to use the ITERATE statement in MySQL with syntax and examples. Description In MySQL, the ITERATE statement is used when you want a loop body…

In this guide, we will explain how to use the IF-THEN-ELSE statement in MySQL with syntax and examples. Description In MySQL, the IF-THEN-ELSE statement is used to execute code when a condition…

In this guide, we will explain how to use the CASE statement in MySQL with syntax and examples. Description In MySQL, the CASE statement has the functionality of an IF-THEN-ELSE statement and…

In this guide, we will explain how to use the Mysql OPEN statement to open a cursor in MySQL with syntax and examples. Description Once you've declared your cursor in MySQL, the next step…