mysql 如何造数据

import mysql.connector
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(100),
    email VARCHAR(100),
    phone VARCHAR(20)
)
""")

fake = Faker()

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

# 提交更改
db.commit()

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