In MySQL, the LEAVE statement is used when you want to exit a block of code identified by a label_name, such as a LOOP statement, WHILE statement, or REPEAT statement.
Let's look at an example that shows how to use the LEAVE statement in MySQL:
In this LEAVE example, we have created a loop called label1 using the LOOP statement.
The ITERATE statement would cause the loop to repeat while income is less than 3000. Once income is greater than or equal to 3000, the LEAVE statement would terminate the LOOP.