mysql存储过程 批量插入不同值

DELIMITER //

CREATE PROCEDURE BatchInsert(IN values_list TEXT)
BEGIN
    DECLARE i INT DEFAULT 1;
    DECLARE value VARCHAR(255);
    DECLARE value_array TEXT DEFAULT CONCAT('(', REPLACE(values_list, ',', '),('), ')');
    DECLARE cur CURSOR FOR SELECT * FROM (SELECT * FROM (SELECT '1' AS col1, '2' AS col2) AS t) AS t2;
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET i = 0;

    OPEN cur;

    read_loop: LOOP
        FETCH cur INTO value;
        IF i = 0 THEN
            LEAVE read_loop;
        END IF;
        INSERT INTO your_table (col1, col2) VALUES (SUBSTRING_INDEX(SUBSTRING_INDEX(value, ',', 1), ',', -1), SUBSTRING_INDEX(SUBSTRING_INDEX(value, ',', -1), ',', 1));
        SET i = i + 1;
    END LOOP;

    CLOSE cur;
END //

DELIMITER ;

CALL BatchInsert('("value1_1","value1_2"),("value2_1","value2_2"),("value3_1","value3_2")');