Notifications
Q&A

Is there an equivalent way of returning early in a MySQL stored procedure?

+4
−0

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?

Why should this post be closed?

0 comments

1 answer

+3
−0

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;

1 comment

Oh, it is way uglier than in T-SQL which allows to simply RETURN (https://docs.microsoft.com/en-us/sql/t-sql/language-elements/return-transact-sql?view=sql-server-ver15) ‭Alexei‭ 30 days ago

Sign up to answer this question »