mysql存储过程 批量插入

DELIMITER //

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

    SET columns = '';
    SET values = '';

    WHILE i < JSON_LENGTH(data) DO
        SET row = JSON_EXTRACT(data, CONCAT('$[', i, ']'));
        SET @columnNames = JSON_UNQUOTE(JSON_EXTRACT(JSON_KEYS(row), '$[0]'));
        SET @columnValues = JSON_UNQUOTE(JSON_EXTRACT(row, '$[0]'));

        SET columns = CONCAT(columns, IF(columns = '', '', ', '), @columnNames);
        SET values = CONCAT(values, IF(values = '', '', ', '), CONCAT("'", @columnValues, "'"));

        SET i = i + 1;
    END WHILE;

    SET @sql = CONCAT('INSERT INTO ', tableName, ' (', columns, ') VALUES (', values, ')');
    PREPARE stmt FROM @sql;
    EXECUTE stmt;
    DEALLOCATE PREPARE stmt;
END //

DELIMITER ;