mysql 生成模拟数据

-- 创建一个示例表
CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(50),
    email VARCHAR(50),
    age INT
);

-- 插入模拟数据
INSERT INTO users (name, email, age)
SELECT
    CONCAT('User', RAND() * 1000),
    CONCAT('user', RAND() * 1000, '@example.com'),
    FLOOR(RAND() * 50) + 20
FROM
    (SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5) AS numbers
LIMIT 100;

import mysql.connector
import random

# 连接到 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(50),
    email VARCHAR(50),
    age INT
)
""")

# 插入模拟数据
for _ in range(100):
    name = f"User{random.randint(1, 1000)}"
    email = f"user{random.randint(1, 1000)}@example.com"
    age = random.randint(20, 70)
    cursor.execute("INSERT INTO users (name, email, age) VALUES (%s, %s, %s)", (name, email, age))

db.commit()
cursor.close()
db.close()

START TRANSACTION;
INSERT INTO users (name, email, age) VALUES (value1, value2, value3), (value4, value5, value6), ...;
COMMIT;