将逗号分隔值的字符串转换为mysql存储过程的值

DELIMITER //

CREATE PROCEDURE ConvertCSVToValues(IN csvString TEXT)
BEGIN
    DECLARE tempValue VARCHAR(255);
    DECLARE done INT DEFAULT FALSE;
    DECLARE csvCursor CURSOR FOR SELECT value FROM csvTable;

    DROP TEMPORARY TABLE IF EXISTS csvTable;
    CREATE TEMPORARY TABLE csvTable (value VARCHAR(255));

    SET @csvString = csvString;
    SET @separator = ',';
    SET @start = 1;

    WHILE @start <= CHAR_LENGTH(@csvString) DO
        IF INSTR(SUBSTRING(@csvString, @start), @separator) = 0 THEN
            SET @value = SUBSTRING(@csvString, @start);
            SET @start = CHAR_LENGTH(@csvString) + 1;
        ELSE
            SET @value = SUBSTRING(@csvString, @start, INSTR(SUBSTRING(@csvString, @start), @separator) - 1);
            SET @start = @start + INSTR(SUBSTRING(@csvString, @start), @separator);
        END IF;

        INSERT INTO csvTable (value) VALUES (@value);
    END WHILE;

    OPEN csvCursor;

    FETCH csvCursor INTO tempValue;

    WHILE NOT done DO
        -- 处理每个值的逻辑
        -- 在这里可以将值插入到其他表格中或进行其他操作

        FETCH csvCursor INTO tempValue;
    END WHILE;

    CLOSE csvCursor;
    DROP TEMPORARY TABLE IF EXISTS csvTable;
END //

DELIMITER ;