Conclusion
In this chapter we looked at conditional and iterative control
structures in the MySQL stored program language. Almost any nontrivial
program will need to make some kind of decision based on input data,
and these decisions will usually be expressed as IF
or CASE
statements.
Looping is another extremely common programming task—especially
common in stored programs that need to iterate through the outputs
from some SQL statement. MySQL provides a number of alternative ways
to format a loop, including a simple loop terminated by a LEAVE
statement, a REPEAT UNTIL
loop, and a WHILE
loop.
Get MySQL Stored Procedure Programming now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.