Generating random unique numbers and insert them into a columun.

[JSANL]

Hey people,


I wanted to generate a random number (for a unique and unpredictable memberID) and insert it into every memberID column which has not a memberID already (equals NULL).
I dont want to change the already generated memberIDs in the meantime.

SELECT FLOOR(10000 + RAND() * 89999) AS random_number
FROM customer
WHERE "random_number" NOT IN (SELECT memberID FROM customer)
LIMIT 1

This is the SQL query to generate a unique random number (I hope :D).
So how can I manage the rest now?

Or even better, can I generate a random, unique and unpredictable ID automatically for every new member I create?

[Luuk]

Maybe it's easier ti use the MySQL function UUID_SHORT() for this?

Another solution might be to create a trigger