mysql批量存储过程

DELIMITER //

CREATE PROCEDURE BatchInsert(IN tableName VARCHAR(255), IN data JSON)
BEGIN
    DECLARE i INT DEFAULT 0;
    DECLARE rowCount INT;
    DECLARE columnNames VARCHAR(255);
    DECLARE columnValues VARCHAR(255);
    DECLARE columns JSON;
    DECLARE values JSON;

    SET rowCount = JSON_LENGTH(data);
    SET columns = JSON_KEYS(data);
    SET values = JSON_EXTRACT(data, '$[*]');

    WHILE i < rowCount DO
        SET columnNames = JSON_UNQUOTE(JSON_EXTRACT(columns, CONCAT('$[', i, ']')));
        SET columnValues = JSON_UNQUOTE(JSON_EXTRACT(values, CONCAT('$[', i, ']')));

        SET @sql = CONCAT('INSERT INTO ', tableName, ' (', columnNames, ') VALUES (', columnValues, ')');

        PREPARE stmt FROM @sql;
        EXECUTE stmt;
        DEALLOCATE PREPARE stmt;

        SET i = i + 1;
    END WHILE;
END //

DELIMITER ;

CALL BatchInsert('your_table_name', '[{"column1": "value1", "column2": "value2"}, {"column1": "value3", "column2": "value4"}]');