Sunday, April 15, 2012

Re: CREATE MySQL PROCEDURE

I even stripped the code down to this:


create procedure mak_nums
begin

   insert into Tmp_Elements (Cell, n, k) values (1,2,2);

end;

And I get the error:

Error 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 'begin    insert into Tmp_Elements (Cell, n, k) values (1,2,2); end' at line 2

I verified the SQL insert statement does work by itself.

No comments:

Post a Comment