Re: Need Help converting Stored Procedure

[Roland Bouman]

delimiter //

CREATE function sp_InsertNewCamper
(
p_FirstName VarChar(30),
p_LastName VarChar(30),
p_UserName VarChar(30),
p_Password VarChar(30)
)
returns int unsigned
begin
INSERT INTO Campers (FirstName, LastName, UserName, Password)
VALUES (p_FirstName, p_LastName, p_UserName, p_Password);
return last_insert_id()
end;
//

should do for most of it, but you must be carful for a bit. In your example, you use NVARCHAR wich is for the national character set. look for character set support in the mysq reference for details.



Edited 1 time(s). Last edit at 11/05/2005 07:45AM by Roland Bouman.