Stored procedure help

[boyindie86]

I have created the following procedure in mysql administrator, but it doesn't like the syntax for some reason can anyone see a problem

CREATE DEFINER=`jshort`@`localhost` PROCEDURE `sp_myedit`(IN p_Id int(32) , IN p_firstname varchar(20), in p_lastname varchar(20))
BEGIN
UPDATE names
set
 
FirstName=p_firstname
Lastname =p_lastname
where id = p_id
Go
 
END
 

[Atli]

Do you get any errors?

[r035198x]

I have created the following procedure in mysql administrator, but it doesn't like the syntax for some reason can anyone see a problem

CREATE DEFINER=`jshort`@`localhost` PROCEDURE `sp_myedit`(IN p_Id int(32) , IN p_firstname varchar(20), in p_lastname varchar(20))
BEGIN
UPDATE names
set
 
FirstName=p_firstname
Lastname =p_lastname
where id = p_id
Go
 
END
 

Shouldn't you have a comma in
FirstName=p_firstname, Lastname =p_lastname

[boyindie86]

Shouldn't you have a comma in
FirstName=p_firstname, Lastname =p_lastname

I jus get the famous error 1064 syntax error :(

I tried putting the comma in but to no avail

[r035198x]

I jus get the famous error 1064 syntax error :(

I tried putting the comma in but to no avail

Put Go after the END