/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

2 votes143 views1 answer
Creating a view SQL
SQL
0 vote126 views2 answers
How to retrive image from sql to picturebox usinf image location
SQL
2 votes141 views6 answers
In operator in sql
SQL
0 vote101 views1 answer
Oracle enable chain
SQL
0 vote101 views1 answer
Postgres float to int
SQL
0 vote111 views1 answer
Changing name of column and datatype in sql
SQL
0 vote124 views1 answer
Postgresql inheritance
SQL
0 vote99 views1 answer
Create domain sql
SQL
0 vote107 views1 answer
Psql list view rules
SQL
5 votes95 views1 answer
Mysql select greater than yesterday
SQL