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.