/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

3 votes254 views3 answers
1396(hy00) mysql error
SQL
12 votes252 views4 answers
How to check mysql version ubuntu
SQL
0 vote234 views1 answer
Sql server alter table column nullable
SQL
0 vote225 views1 answer
Sqlite update where exists
SQL
0 vote230 views1 answer
Jenkins SQLCMD run
SQL
0 vote221 views1 answer
How to select even id in sql
SQL
0 vote225 views1 answer
Sql datediff month
SQL
0 vote212 views1 answer
Sql right characters
SQL
2 votes244 views1 answer
Drop all foreign key constraints mysql
SQL
0 vote228 views1 answer
Sql Top 5 sutradara dengan filem terbanyak
SQL