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.
Post History
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. CR...
Answer
#1: Initial revision
by
Moshi
·
2020-09-29T01:26:30Z (about 4 years ago)
I don't know any SQL at all, so credits go to the top answer of *[Mysql - How to quit/exit from stored procedure](https://stackoverflow.com/a/6260325)* on StackOverflow.
-----
You can simply wrap the code in a label and LEAVE the label, ex.
```sql
CREATE PROCEDURE Example_Proc()
proc_label:BEGIN
IF <condition> THEN
LEAVE proc_label;
END IF;
#proceed
END;
```