Loops -> Repetitive tasks
3 types of loops in MySQL stored program:
- Simple loop using LOOP and END LOOP clauses
- WHILE and END WHILE clauses that runs while a condition is true
- REPEAT and UNTIL clauses that runs until a condition is true
Termination of loop -> LEAVE statement.
I will demonstrate the use of loops the simple loop way.