为表中每个唯一值添加随机Id

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255) NOT NULL,
    email VARCHAR(255) NOT NULL UNIQUE
);

ALTER TABLE users ADD COLUMN random_id CHAR(36) NOT NULL UNIQUE;

import uuid
import mysql.connector

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

cursor = db.cursor()

# 查询现有用户
cursor.execute("SELECT id FROM users")

# 为每个用户生成并插入随机ID
for (user_id,) in cursor:
    random_id = str(uuid.uuid4())
    cursor.execute("UPDATE users SET random_id = %s WHERE id = %s", (random_id, user_id))

# 提交更改并关闭连接
db.commit()
cursor.close()
db.close()