mysql游标分割字符串

DELIMITER //

CREATE PROCEDURE SplitString()
BEGIN
    DECLARE done INT DEFAULT FALSE;
    DECLARE cur_str VARCHAR(255);
    DECLARE cur_val VARCHAR(255);
    DECLARE cur_index INT DEFAULT 1;
    DECLARE delimiter CHAR(1) DEFAULT ',';

    -- 假设我们有一个包含逗号分隔的字符串的表
    DECLARE cur CURSOR FOR SELECT data FROM example_table;
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;

    OPEN cur;

    read_loop: LOOP
        FETCH cur INTO cur_str;
        IF done THEN
            LEAVE read_loop;
        END IF;

        -- 分割字符串并逐行处理
        WHILE cur_index <= LENGTH(cur_str) - LENGTH(REPLACE(cur_str, delimiter, '')) + 1 DO
            SET cur_val = SUBSTRING_INDEX(SUBSTRING_INDEX(cur_str, delimiter, cur_index), delimiter, -1);
            -- 在这里进行逐行处理，例如插入到另一张表
            INSERT INTO split_table (value) VALUES (cur_val);
            SET cur_index = cur_index + 1;
        END WHILE;

        SET cur_index = 1;
    END LOOP;

    CLOSE cur;
END //

DELIMITER ;