MySQL Forums
Forum List  »  Stored Procedures

Re: How to do this ?
Posted by: Beat Vontobel
Date: November 25, 2005 11:23AM

I just see that you probably should add another BEGIN ... END around the multiple SELECT statements between IF ... THEN and ELSE. You can only have a single statement after an IF ... THEN or ELSE if you don't use a BEGIN ... END block around it.

Options: ReplyQuote


Subject
Views
Written By
Posted
2127
November 23, 2005 12:11PM
1545
November 24, 2005 08:01PM
Re: How to do this ?
1535
November 25, 2005 11:23AM
1510
November 25, 2005 01:16PM
1442
November 27, 2005 07:52AM
1488
November 27, 2005 08:57AM


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.