DROP PROCEDURE IF EXISTS `update_product_location`;
DELIMITER ;;
CREATE PROCEDURE `update_product_location` (
    IN p_location VARCHAR(200),
    IN p_product_id INT,
    IN p_user_id INT,
    OUT p_status INT
)
proc:BEGIN
    IF p_location = '' OR p_location IS NULL THEN
        SET p_status = -1;
        LEAVE proc;
    END IF;
    UPDATE products SET location = p_location WHERE user_id = p_user_id AND id = p_product_id;
    SET p_status = 0;
END ;;
DELIMITER ;