mysql 如何循环添加数据

import mysql.connector

# 连接到MySQL数据库
mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  password="yourpassword",
  database="yourdatabase"
)

mycursor = mydb.cursor()

# 插入数据的SQL语句
sql = "INSERT INTO yourtable (column1, column2) VALUES (%s, %s)"

# 循环添加数据
for i in range(10):
    val = (i, f"Data {i}")
    mycursor.execute(sql, val)

# 提交事务
mydb.commit()

print(mycursor.rowcount, "记录已插入。")

INSERT INTO yourtable (column1, column2) 
SELECT %s, %s 
FROM DUAL 
WHERE NOT EXISTS (
    SELECT 1 FROM yourtable WHERE column1 = %s
);

sql = "INSERT INTO yourtable (column1, column2) VALUES (%s, %s)"
val = [
    (1, 'Data 1'),
    (2, 'Data 2'),
    # ... 更多数据
]
mycursor.executemany(sql, val)
mydb.commit()

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