In MySQL, the ITERATE statement is used when you are want a loop body to execute again. It is used within the LOOP statement, WHILE statement, and REPEAT statement.
Let's look at an example that shows how to use the ITERATE statement in MySQL:
In this ITERATE 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 2500. Once income is greater than or equal to 2500, the LEAVE statement would terminate the LOOP.