Re: Just can't seem to create a stored procedure with phpMyAdmin

[Sandeep Kadam]

hi

I'm also facing same problem i have following version installed on my machine

MySQL - 5.0.16-nt
phpMyAdmin - 2.8.1
php 5

my procedure code:

CREATE PROCEDURE add_footer( IN footerId varchar( 30 ) )
BEGIN
INSERT INTO header_master( header_id )VALUES (footerId);
END

I'm executing this code in my phpmyadmin interface and im getting this error

SQL query:

CREATE PROCEDURE add_footer( IN footerId varchar( 30 ) ) BEGIN INSERT INTO header_master( header_id )
VALUES (

footerId
);



MySQL said:

#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 'INSERT INTO header_master( header_id )VALUES (footerId)' at line



Edited 1 time(s). Last edit at 05/23/2006 05:44AM by Sandeep Kadam.