Update Statement in Stored Procedure using MySql Workbench

See more:

C#

MySQL

Hi all,

I am trying to use Stored Procedure to do an Update function to my table records, but apparently, my script doesn't seem to work. In which, I suspect that the SET command used is in Update function and the SET command used in Stored Procedure sort of 'clashes'. Correct me if I am wrong.

Please advice on how to get the Update function done in Stored Procedure.

Here's my version of Stored Procedure:
CREATE PROCEDURE mysql_biosys.edit_Site(site_Id_Parsed INT, site_Name_Entered VARCHAR(64), address_Entered VARCHAR(64), postal_code_Entered INT,
commence_Date_Entered VARCHAR(16), completion_Date_Entered VARCHAR(16))
BEGIN
UPDATE site
SET site_Name = site_Name_Entered,
address = address_Entered,
postal_Code = postal_code_Entered,
commence_Date = commence_Date_Entered,
completion_Date = completion_Date_Entered
WHERE site_Id = site_Id_Parsed;
END;
|

Thanks in advance.