return keyword in mysql stored procedures

Question

Possible Duplicate:
Mysql - How to quit/exit from stored procedure

Is there something equivelant to php's, c++, c, java, whatever return statement?

can i do something like

IF @numRows >= 1 THEN
  RETURN
END IF;

in mysql stored procedures???

procedures return values all the time. is there something special about what you want to get from the proc? — ethrbunny, Oct 18 '12 at 12:18
I just want to end it, so it wont execute commands that are not necessary. — Not Amused, Oct 18 '12 at 12:19

score 1 · Accepted Answer · answered Oct 18 '12 at 12:25

1

Try this

Sp:BEGIN
    IF @numRows >= 1 THEN
        LEAVE Sp;
    END IF;

END$$

answered Oct 18 '12 at 12:25

iJade

It was already solved by Paolo Falabella, but he wouldn't post it as an answer. TY. – Not Amused Oct 18 '12 at 23:39

1 Answers1