mysql模拟数据

import mysql.connector
import random
from faker import Faker

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

cursor = db.cursor()

# 创建表
cursor.execute("CREATE TABLE IF NOT EXISTS users (id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255), email VARCHAR(255))")

fake = Faker()

# 插入模拟数据
for _ in range(100):
    name = fake.name()
    email = fake.email()
    cursor.execute("INSERT INTO users (name, email) VALUES (%s, %s)", (name, email))

db.commit()

# 查询并打印数据
cursor.execute("SELECT * FROM users")
result = cursor.fetchall()
for row in result:
    print(row)

cursor.close()
db.close()