List:General Discussion« Previous MessageNext Message »
From:Jesse Castleberry Date:November 7 2005 6:26pm
Subject:Stored Procedure Question
View as plain text  
I've got a stored procedure I'm trying to convert from MS SQL.  I've gotton
so far with it, but it's complaining about the INSERT command. It's a very
simple stored procedure, so it should easy to figure out, but I'm not
familiar with the MySQL Stored Procedure syntax.  If someone can point out
what I'm doing wrong here, I'd appreciate it:

CREATE Procedure sp_InsertNewCamper
(
in cFirstName NVarChar(30),
in cLastName NVarChar(30),
in cUserName NVarChar(30),
in cPassword NVarChar(30),
out AddedID Int
)
BEGIN
  INSERT INTO Campers (FirstName, LastName, UserName, Password) VALUES
(cFirstName, cLastName, cUserName, cPassword) // ERROR RIGHT HERE.
  AddedID = LAST_INSERT_ID()
END;

It complains about the INSERT INTO command where I've indicated above, with
a Syntac error.  What is the proper syntax for this?

Thanks,
Jesse

Thread
Stored Procedure QuestionJesse Castleberry7 Nov
  • Re: Stored Procedure QuestionSGreen7 Nov
  • Re: Stored Procedure QuestionPeter Brawley7 Nov