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
