MySQL Forums
Forum List  »  Stored Procedures

Re: Just can't seem to create a stored procedure with phpMyAdmin
Posted by: Sandeep Kadam
Date: May 23, 2006 05:41AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Just can't seem to create a stored procedure with phpMyAdmin
5552
May 23, 2006 05:41AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.