Name
IF-04: Use CASE and IF consistently
Synopsis
Any conditional statement that can be expressed as an
IF
statement can also be
expressed as a CASE
statement—and vice versa. While you might heatedly debate the
relative benefits of each over a few beers after work, it’s fairly
clear that you can write high-quality code no matter which
statement you employ.
However, randomly alternating between the two statements
does not lead to high-quality code. It’s harder to compare the
logic of two routines if—for instance—one expresses its branching
logic with the CASE
statement
while the other uses IF
. So try
not to mix IF
and CASE
arbitrarily within your
programs.
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.