/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

1 vote130 views1 answer
Function difference_in_hours(timestamp with time zone) does not exist
SQL
-3 votes100 views1 answer
Remove spaces sql 2008
SQL
0 vote127 views1 answer
Space not removing from column in sql
SQL
1 vote102 views1 answer
Oracle sql create view
SQL
0 vote109 views1 answer
Pl sql round
SQL
0 vote100 views1 answer
Power bi find all ids not in other tables
SQL
11 votes290 views4 answers
Round in sql
SQL
0 vote111 views2 answers
Mysql get routine parameter list
SQL
0 vote144 views1 answer
Oracle plsql sleep
SQL
7 votes124 views1 answer
Return insert results in POSTGRESQL
SQL