mysql 随机生成id

CREATE TABLE example (
    id CHAR(36) NOT NULL PRIMARY KEY,
    name VARCHAR(255) NOT NULL
);

INSERT INTO example (id, name) VALUES (UUID(), 'John Doe');

import mysql.connector
import random

db = mysql.connector.connect(
    host="localhost",
    user="yourusername",
    password="yourpassword",
    database="yourdatabase"
)

cursor = db.cursor()

random_id = random.randint(100000000000000000, 999999999999999999)
sql = "INSERT INTO example (id, name) VALUES (%s, %s)"
val = (random_id, 'John Doe')

cursor.execute(sql, val)
db.commit()

INSERT INTO example (id, name)
SELECT * FROM (SELECT %s AS id, 'John Doe' AS name) AS tmp
WHERE NOT EXISTS (
    SELECT id FROM example WHERE id = %s
) LIMIT 1;