创建条目时，在列中生成随机且唯一的ID

Question

How can I make it so when an entry is created in a table, one of the columns unique_id automatically gets filled with a randomly generated integer? Can this be done straight from mysql? I've seen that you can automatically fill it with a timestamp and such, so is it possible to automatically fill it with a randomly generated integer?

Answer 1

you can try this

SELECT FLOOR(10000 + RAND() * 89999) AS my_random_number
FROM mytable
WHERE "my_random_number" NOT IN (SELECT id FROM mytable)
LIMIT 1

OR SImply this SELECT FLOOR(RAND() * 1000000);