/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 vote189 views1 answer
Access refused mysql xampp server
SQL
1 vote210 views1 answer
Psql connect to another database
SQL
7 votes191 views3 answers
Postgre describe table
SQL
26 votes444 views6 answers
Modify column name in sql
SQL
0 vote205 views1 answer
To_date sql
SQL
0 vote146 views1 answer
Oracle sql developer script output limit
SQL
0 vote202 views1 answer
How to print records of employees hired in particular month in oracle
SQL
5 votes230 views2 answers
Mysql dump mysql db cli
SQL
0 vote204 views1 answer
Postgres can integer fields be negative
SQL
4 votes254 views2 answers
Installing sql on ubuntu
SQL