mysql生成随机数据

-- 生成一个随机的整数
SELECT FLOOR(RAND() * 100) AS random_int;

-- 生成一个随机的字符串
SELECT CONCAT('user_', FLOOR(RAND() * 100)) AS random_string;

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(10):
    random_int = random.randint(1, 100)
    random_string = 'user_' + str(random.randint(1, 100))
    sql = "INSERT INTO yourtable (random_int, random_string) VALUES (%s, %s)"
    val = (random_int, random_string)
    cursor.execute(sql, val)

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

sql = "INSERT INTO yourtable (random_int, random_string) VALUES (%s, %2)"
val = [
    (random.randint(1, 100), 'user_' + str(random.randint(1, 100))) for _ in range(1000)
]
cursor.executemany(sql, val)
db.commit()