/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 vote334 views1 answer
Alter add syntax
SQL
0 vote327 views1 answer
How to to get current date in sql
SQL
0 vote323 views1 answer
Fetcht he leftmost word in a comma separated string in sql
SQL
0 vote317 views1 answer
Safe mysql
SQL
1 vote338 views2 answers
Find nth highest salary of an employee
SQL
0 vote310 views1 answer
Get time component of datetime sql
SQL
1 vote331 views1 answer
Ora-01950 no privileges on tablespace
SQL
0 vote328 views1 answer
Sql Top 5 sutradara dengan filem terbanyak
SQL
0 vote340 views1 answer
Sql cmd no truncate
SQL
0 vote311 views1 answer
Tsql cmd exec script from file
SQL