use inventory;
DROP PROCEDURE IF EXISTS `inventory`.`array_push_fifo`;
DELIMITER //
CREATE DEFINER=`root`@`localhost` PROCEDURE `inventory`.`array_push_fifo`(INOUT `my_array` VARCHAR(255), IN `new_value` VARCHAR(255))
BEGIN
    -- Check if the array is empty
    IF my_array IS NULL THEN
        SET my_array = new_value;
    ELSE
        -- Concatenate the new value to the existing array with a delimiter
        SET my_array = CONCAT(my_array, ',', new_value);
    END IF;
END//
DELIMITER ;