mysql数据模拟

import mysql.connector
from faker import Faker

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

cursor = conn.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))

# 提交事务
conn.commit()

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

ALTER DATABASE your_database CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE users CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

conn = mysql.connector.connect(
    host="localhost",
    user="your_username",
    password="your_password",
    database="your_database",
    charset='utf8mb4'
)

sql = "INSERT INTO users (name, email, phone) VALUES (%s, %s, %s)"
val = [
    (fake.name(), fake.email(), fake.phone_number()),
    # ...更多数据
]
cursor.executemany(sql, val)