DELIMITER //

CREATE PROCEDURE change_owner (
IN fr_user_id int,
IN to_user_id int,
IN p_account_id int)
BEGIN
start transaction;

UPDATE accountowner SET user_id = to_user_id WHERE account_id = p_account_id;

commit;
END; //
DELIMITER ;