/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 vote164 views2 answers
How to install mysql workbench in ubuntu 20.04
SQL
4 votes150 views1 answer
Oracle user tables
SQL
0 vote131 views1 answer
Sql query to select records entered in last 24 hours
SQL
0 vote150 views1 answer
Prodection ready postgres database step by step
SQL
3 votes143 views1 answer
Laravel paginate raw sql
SQL
0 vote181 views1 answer
Install postgresql 12 on debian 10
SQL
0 vote147 views1 answer
Recover deleted data from mysql database
SQL
0 vote140 views1 answer
Oracle select invalid views
SQL
1 vote155 views1 answer
Sql select whole row max column
SQL
0 vote174 views1 answer
Mysql trigger to delete old data
SQL