Re: exit stored procedure - a newbie question
Just put a label at BEGIN and use LEAVE:
CREATE PROCEDURE `cwa`.`insertWord`(wordId mediumint(8),status tinyint(1), res INT)
foo:BEGIN
if word is null or word ='' then
set res = -1;
leave foo;
else
...
END
pem, Senior Software Dev., MySQL AB
Subject
Views
Written By
Posted
27040
June 11, 2005 02:51PM
14397
June 12, 2005 08:51AM
Re: exit stored procedure - a newbie question
12639
June 16, 2005 08:21AM
9310
June 16, 2005 08:23AM
7561
June 16, 2005 09:27AM
7344
June 16, 2005 10:25AM
5974
June 16, 2005 12:45PM
6281
June 17, 2005 06:59AM
10283
June 17, 2005 07:10AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.