Re: Problems using LOOP..END LOOP, label and LEAVE
Odd, I just gave it a go and it seems to work fine for me.
mysql> create procedure myproc()
-> begin
-> myloop: loop
-> leave myloop;
-> end loop;
-> end
-> //
Query OK, 0 rows affected (0.00 sec)
I'm using a brand new 5.7 intall.
Andrew Gilfrin
------------------
http://gilfster.blogspot.com
My MySQL related Blog
http://www.mysqldevelopment.com
MySQL Stored Procedure,Trigger, View.... (Just about most things these days) Information
Subject
Views
Written By
Posted
5261
June 29, 2005 06:25AM
2363
June 29, 2005 07:26AM
2449
June 30, 2005 12:38AM
2384
June 30, 2005 04:57AM
2261
June 30, 2005 05:41AM
2307
July 01, 2005 04:17AM
Re: Problems using LOOP..END LOOP, label and LEAVE
2286
July 01, 2005 05:23AM
2261
July 01, 2005 06:04AM
2854
July 01, 2005 06:29AM
2322
July 01, 2005 07:11AM
4541
July 01, 2005 04:39PM
2408
July 17, 2005 01:24AM
Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.
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.