如何循环编号并保存到表中

import mysql.connector

# 连接数据库
conn = mysql.connector.connect(
    host="localhost",
    user="your_username",
    password="your_password",
    database="your_database"
)

# 创建游标
cursor = conn.cursor()

# 查询最大编号
cursor.execute("SELECT MAX(编号) FROM your_table")
result = cursor.fetchone()
max_number = result[0] if result[0] else 0

# 循环生成并保存编号
for i in range(10):
    number = max_number + i + 1
    info = "相关信息" + str(i+1)

    # 插入记录到数据库表中
    cursor.execute("INSERT INTO your_table (编号, 相关信息) VALUES (%s, %s)", (number, info))

# 提交事务并关闭连接
conn.commit()
cursor.close()
conn.close()