mysql 生成测试数据

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100),
    email VARCHAR(100),
    age INT
);

DELIMITER //

CREATE PROCEDURE generate_test_data()
BEGIN
    DECLARE i INT DEFAULT 1;
    WHILE i <= 1000 DO
        INSERT INTO users (name, email, age) VALUES (
            CONCAT('User', i),
            CONCAT('user', i, '@example.com'),
            FLOOR(RAND() * 50) + 20
        );
        SET i = i + 1;
    END WHILE;
END //

DELIMITER ;

CALL generate_test_data();

import mysql.connector
import random

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

cursor = db.cursor()

# 生成并插入测试数据
for i in range(1, 1001):
    name = f"User{i}"
    email = f"user{i}@example.com"
    age = random.randint(20, 70)
    sql = f"INSERT INTO users (name, email, age) VALUES ('{name}', '{email}', {age})"
    cursor.execute(sql)

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