how to generate a unique random number in mysql code example
Example 1: generate random & unique mysql string
DO
SELECT LEFT(UUID(), 8) INTO @var;
INSERT INTO col (@var);
WHILE there_is_a_unique_constraint_violation
Example 2: how to generate a unique random number in mysql
#query
SELECT FLOOR(RAND() * 99999)
AS random_num
FROM YourTableName
WHERE "random_num"
NOT IN (
SELECT YourColumnName FROM YourTableName) LIMIT 1