MySQL Forums
Forum List  »  InnoDB

Re: cursor iterating twice over last row
Posted by: Jenith Michael
Date: December 02, 2008 10:54AM

Use this condition after fetch,

IF NOT done THEN
// use your switch and other business process

end if;

Because the UNTIL works after your insert, case, thats why last row repeats

Cool

Jenith

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: cursor iterating twice over last row
5088
December 02, 2008 10:54AM


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.