/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 vote121 views2 answers
Test sqlsrv connection
SQL
1 vote108 views1 answer
MySQL AND Operator
SQL
0 vote115 views2 answers
Soql last year
SQL
0 vote127 views1 answer
SqlFunction does not exist
SQL
17 votes146 views1 answer
Selecting name that contain certain word in sql
SQL
2 votes114 views1 answer
Select from array in psql
SQL
0 vote119 views1 answer
How to move a columns location in mysql
SQL
0 vote120 views1 answer
Oracle 11g forget password
SQL
12 votes118 views2 answers
Insert multiple rows from another table sql
SQL
0 vote114 views1 answer
SQL Server INSERT INTO SELECT By Complete Examples - NAYCode.com
SQL