使用循环在用户注册后插入语句

import mysql.connector

# 用户注册信息
user_info = {
    'username': 'John',
    'email': 'john@example.com',
    'password': 'password123'
}

# 连接数据库
conn = mysql.connector.connect(
    host='localhost',
    user='root',
    password='password',
    database='mydatabase'
)

# 获取数据库游标
cursor = conn.cursor()

# 循环插入语句
for i in range(5):
    # 构建插入语句
    insert_query = "INSERT INTO users (username, email, password) VALUES (%s, %s, %s)"
    values = (user_info['username'], user_info['email'], user_info['password'])
    
    # 执行插入语句
    cursor.execute(insert_query, values)
    conn.commit()

# 关闭数据库连接
cursor.close()
conn.close()