Mysql - How to quit/exit from stored procedure

Question

I have a very simple question but I didn't get any simple code to exit from SP using Mysql. Can anyone share with me how to do that?

CREATE PROCEDURE SP_Reporting(IN tablename VARCHAR(20))

BEGIN

     IF tablename IS NULL THEN

          #Exit this stored procedure here

     END IF;

   #proceed the code

END;

Answer 1

Use the below query:

CREATE PROCEDURE SP_Reporting(IN tablename VARCHAR(20))

proc_label:BEGIN

     IF tablename IS NULL THEN

          LEAVE proc_label;

     END IF;

     #proceed the code

END;