Using Label and Goto

[Hub Hensgens]

Hi,



I'm converting several big procedures from SQL-server to MySQL. In the SQL-server-procedures 'goto'-statements are used. According to the white paper on Stored Procedures (pag 28) MySQL also has a goto-statement.
When I try to define a label with the Label-statement a 'MySQL execution error #1064 You have an error in your SQL-statement' occurs.

I tried a little procedure and it still doesn't run. How is this? Does the label-statement exists?


Create procedure test ()
begin

goto label_eind;
label label_begin;
select * from topic;
goto label_begin;
label label_end;

end;

sincere Hubert