Problems using LOOP..END LOOP, label and LEAVE
Hi!
Can anyone help me out? Im running mysql 5.0.7, an im trying to set up a loop like so:
create procedure bogus()
begin
l: loop
if true then
leave l;
end if;
end loop l;
end;
but i keep getting 1064:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'l: loop
if true then
leave l;
end if;
end lo' at line 2
It seems to have to do with the label l:, because this compiles fine (although it will run "forever") :
create procedure bogus()
begin
declare v int;
loop
if true then
set v = 1;
end if;
end loop;
end;
Thanks in advance
Edited 1 time(s). Last edit at 06/29/2005 06:25AM by Roland Bouman.
Subject
Views
Written By
Posted
Problems using LOOP..END LOOP, label and LEAVE
5306
June 29, 2005 06:25AM
2390
June 29, 2005 07:26AM
2477
June 30, 2005 12:38AM
2408
June 30, 2005 04:57AM
2286
June 30, 2005 05:41AM
2337
July 01, 2005 04:17AM
2308
July 01, 2005 05:23AM
2288
July 01, 2005 06:04AM
2878
July 01, 2005 06:29AM
2359
July 01, 2005 07:11AM
4581
July 01, 2005 04:39PM
2433
July 17, 2005 01:24AM
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.