/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 vote338 views1 answer
Sql server update column based on another table
SQL
0 vote378 views1 answer
Get clob size oracle
SQL
0 vote362 views1 answer
Alter check command
SQL
13 votes350 views2 answers
Sql count distinct group by
SQL
0 vote337 views1 answer
Oracle gather table statistics
SQL
1 vote353 views1 answer
Mysql data from file
SQL
0 vote349 views1 answer
Mysql set column equal to another automatic
SQL
0 vote370 views1 answer
Firebase sql
SQL
12 votes343 views1 answer
Script to add new column in table sql
SQL
0 vote354 views1 answer
Sql server select record with max id
SQL