People are occasionally moved between different departments. I want to create a procedure that accepts a name (name of person) and a department(department that person is assigned to) and changes the person's department assignment to a new department.
for example:
create procedure assign (
in name VARCHAR(256),
in department VARCHAR(256)
)
comment "move work to new department"
BEGIN
UPDATE name
SET department = newdepartment
END$$
please ask if you need more information for better understanding.
Asked by Redsam121
(3 rep)
May 31, 2019, 08:31 AM
Last activity: Jun 1, 2019, 02:57 AM
Last activity: Jun 1, 2019, 02:57 AM