/SQL/How to generate a unique random number in mysql

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

Generate random & unique mysql string

DO 
    SELECT LEFT(UUID(), 8) INTO @var;
    INSERT INTO col (@var);
WHILE there_is_a_unique_constraint_violation

Similar codes

0 vote175 views1 answer
Top frequency in sql server
SQL
0 vote216 views1 answer
Get null value in sql
SQL
0 vote171 views1 answer
Sql date between one week
SQL
4 votes180 views1 answer
Oracle delete last row
SQL
1 vote183 views1 answer
Set mysql mode global query
SQL
1 vote190 views1 answer
Quit mysql
SQL
0 vote187 views5 answers
ABC TO FLEX BATTLE IM POOR
SQL
10 votes221 views2 answers
What is database
SQL
11 votes203 views4 answers
Reset identity column values in sql server
SQL
0 vote180 views1 answer
Oracle drop type
SQL