/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

7 votes282 views1 answer
Forge server hosting
SQL
3 votes306 views2 answers
Oracle sql select all days between two dates except weekends
SQL
28 votes310 views4 answers
Delete database mysql
SQL
0 vote308 views1 answer
Lost connection to mysql
SQL
0 vote294 views1 answer
Sql server datetime to string
SQL
3 votes302 views1 answer
Set default today mysql
SQL
0 vote293 views1 answer
Import big data to mysql
SQL
0 vote350 views1 answer
Site:av.ru "files"
SQL
0 vote354 views1 answer
Hierarchal database table
SQL
2 votes325 views1 answer
Where clause for child record apex
SQL