Problems using LOOP..END LOOP, label and LEAVE

[Roland Bouman]

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.