mysql 循环插入

import mysql.connector

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

cursor = db.cursor()

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

# 循环插入数据
for i in range(10):
    data = (i, f"Data{i}")
    cursor.execute(sql, data)
    db.commit()

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

# 批量插入示例
sql = "INSERT INTO yourtable (column1, column2) VALUES (%s, %%s)"
val = [
    (1, 'Data1'),
    (2, 'Data2'),
    # ... 更多数据
]
cursor.executemany(sql, val)
db.commit()

try:
    cursor.execute("START TRANSACTION")
    for i in range(10):
        data = (i, f"Data{i}")
        cursor.execute(sql, data)
    db.commit()
except mysql.connector.Error as err:
    db.rollback()
    print(f"Error: {err}")
finally:
    cursor.close()
    db.close()