How to create stored procedure in phpmyadmin?

[nzjohn007]

I am new to write stored procedure in phpmyadmin. Currently, I am using phpmyadmin 2.9.0.3. Mysql 5.0.27. I have tried to create a simple stored procedure below:

delimiter //

CREATE PROCEDURE test()
BEGIN
SELECT * FROM Product;
END;
//

But I always got a syntax error #1064.

Can anyone tell me how to get it work?

Thanks a lot!

[rathina]

Hi nzjohn007,

You may try this sample code on MySQL console instead of using PHPMyAdmin.

It will work.