Welcome to Software Development on Codidact!
Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.
Comments on Is there an equivalent way of returning early in a MySQL stored procedure?
Parent
Is there an equivalent way of returning early in a MySQL stored procedure?
In programming instead of arrowcode where one has many layers of indented if statements, you can return a result as soon as possible. So instead of,
if
if
end if
end if
It looks like
if
return
end if
if
return
end if
A MySQL stored procedure does not return a value, is there an equivalent way of returning early if only to make the code easier to read?
Post
I don't know any SQL at all, so credits go to the top answer of Mysql - How to quit/exit from stored procedure on StackOverflow.
You can simply wrap the code in a label and LEAVE the label, ex.
CREATE PROCEDURE Example_Proc()
proc_label:BEGIN
IF <condition> THEN
LEAVE proc_label;
END IF;
#proceed
END;
0 comment threads