CREATE OR REPLACE PROCEDURE 
    UpdateLocation( IN Location_id INT, IN New_location VARCHAR(1024) )
BEGIN
    UPDATE 
        location
    SET 
        location = New_location
    WHERE
        id = Location_id
    LIMIT
        1
    ;
END       