Jump to content

simple stored procedure not working on mysql 5.0


zohab

Recommended Posts

Hi all,

 

I wrote simple stored procedure and it is not working and giving error,

 

CREATE PROCEDURE simpleproc 
     BEGIN
       select * from tablename
     END

 

I got this example syntax from following url

 

http://dev.mysql.com/doc/refman/5.1/en/create-procedure.html

 

any idea what is going wrong?

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.