List:General Discussion« Previous MessageNext Message »
From:Peter Brawley Date:November 7 2005 6:51pm
Subject:Re: Stored Procedure Question
View as plain text  
Jesse,

>BEGIN
>  INSERT INTO Campers (FirstName, LastName, UserName, Password) VALUES
>(cFirstName, cLastName, cUserName, cPassword) // ERROR RIGHT HERE.
>  AddedID = LAST_INSERT_ID()
>END;

First, there's a right parenthesis missing. Second, the expression

  AddedID = LAST_INSERT_ID()

will evaluate to 1, 0 or Null depending on whether AddedID = 
Last_Insert_Id() or whether either is Null---likely not what you intend. 
To assign a value inline, use the ':=' operator.

PB

------

Jesse Castleberry wrote:

>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
>
>
>  
>


-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.362 / Virus Database: 267.12.8/162 - Release Date: 11/5/2005

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