通过使用MySQL在变量中传递列数组和值数组来插入

DELIMITER //

CREATE PROCEDURE insert_data(IN col_array VARCHAR(255), IN val_array VARCHAR(255))
BEGIN
    DECLARE i INT DEFAULT 1;
    DECLARE col_name VARCHAR(255);
    DECLARE val_value VARCHAR(255);
    DECLARE insert_query VARCHAR(1000);

    SET col_array = CONCAT(col_array, ',');
    SET val_array = CONCAT(val_array, ',');

    WHILE i <= LENGTH(col_array) DO
        SET col_name = SUBSTRING_INDEX(SUBSTRING_INDEX(col_array, ',', i), ',', -1);
        SET val_value = SUBSTRING_INDEX(SUBSTRING_INDEX(val_array, ',', i), ',', -1);

        SET insert_query = CONCAT('INSERT INTO your_table (', col_name, ') VALUES (', val_value, ');');

        PREPARE stmt FROM insert_query;
        EXECUTE stmt;

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

DELIMITER ;

CALL insert_data('column1,column2,column3', 'value1,value2,value3');