怎么在mysql循环插入数据

DELIMITER //

CREATE PROCEDURE InsertData()
BEGIN
  DECLARE i INT DEFAULT 1;
  WHILE i <= 100 DO
    INSERT INTO your_table (column1, column2) VALUES (i, CONCAT('Data', i));
    SET i = i + 1;
  END WHILE;
END //

DELIMITER ;

-- 调用存储过程
CALL InsertData();

import mysql.connector

# 连接到MySQL数据库
cnx = mysql.connector.connect(user='your_username', password='your_password',
                              host='your_host', database='your_database')

cursor = cnx.cursor()

# 循环插入数据
for i in range(1, 101):
    query = ("INSERT INTO your_table (column1, column2) VALUES (%s, %s)")
    data = (i, f'Data{i}')
    cursor.execute(query, data)

# 提交事务
cnx.commit()

# 关闭连接
cursor.close()
cnx.close()