Forum Moderators: coopster

Message Too Old, No Replies

Creating Stored Procedures in PhpMyAdmin 2.6.2-rc1

         

Murali_PDI

6:03 am on Aug 12, 2006 (gmt 0)

10+ Year Member



Hi,

Can Any one Help me how to create a Stored Procedure from PhpMyadmin 2.6.2-rc1

My Code:
---------

CREATE PROCEDURE sp_test() BEGIN SELECT "Hello"; END;

Iam getting the following 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 'SELECT "Hello"' at line 3

Iam in Need of the Solution and No other way for me to do,I mean I was told not to use any other Tool to Compile Stored Procedures.

The Only Way i have to Use the PhpMyAdmin to Compile Stored Procedures,Functions and Triggers.

Mysql Version : 5.0.22
php : 5.0.3
phpmyadmin : 2.6.2-rc1

Please Help, Iam In Need Of this and it's very urgent.
Is that any Particulars regarding Version Support for Creating Stored Procedures from PhpMyAdmin?

Thanks,

Murali.V

dreamcatcher

8:59 am on Aug 17, 2006 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Hi Murali,

Did you get this sorted out? I have bumped the topic for you in case someone who knows the solution missed it first time around.

dc