Re: Declare statement causing error 1064

[Peter Brawley]

You forgot a DELIMITER directive, which creaton of multiline stored routines needs so line-by-line execution is suspended, see the manual page for sprocs.

drop procedure ...
DELIMITER go
create procedure ...
begin
...
end;
go
DELIMITER ;