mysql 更新存储过程,使用MySql Workbench更新存储过程中的语句

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.

解决方案We should specify the type of parameter(In,Out,InOut) passing to stored procedure.