Need Help converting Stored Procedure

[Jesse Castleberry]

I am converting a MS SQL Server ASP application over to use MySQL. I have two simple stored procedures that I need to convert. I have very little experience with MS SQL, and none-what-so-ever with stored procedures in MySQL, so I really don't know what this should look like. I'll post the first one, and if I'm able to figure it out, I'll attempt my second one by myself. Here's the code from MS SQL:

CREATE Procedure sp_InsertNewCamper
(
@FirstName NVarChar(30),
@LastName NVarChar(30),
@UserName NVarChar(30),
@Password NVarChar(30)
)
As
INSERT INTO Campers (FirstName, LastName, UserName, Password)
VALUES (@FirstName, @LastName, @UserName, @Password)

return @@Identity

GO

Thanks,
Jesse