/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 vote284 views1 answer
Check if a column is a primary key in sql server
SQL
7 votes286 views1 answer
Oracle pagination query rownum
SQL
0 vote251 views2 answers
How to find max and min salary in sql
SQL
0 vote264 views1 answer
Inserted row count tsql
SQL
0 vote263 views1 answer
How to get table current identity value in sql server
SQL
0 vote258 views2 answers
Sql regex vowel
SQL
1 vote263 views1 answer
How to select rows with no matching entry in another table?
SQL
0 vote270 views1 answer
Oarcale list objects
SQL
1 vote257 views1 answer
Neo4j display all nodes and relationships
SQL
32 votes269 views6 answers
Insert into values select
SQL