/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 vote299 views1 answer
How to delete duplicate rows in oracle
SQL
0 vote293 views1 answer
Sql server pivot rows to columns
SQL
0 vote277 views1 answer
Min and max salary and name in sql
SQL
0 vote299 views1 answer
How to find lowest in sql
SQL
0 vote263 views1 answer
Install mysql 8 linux
SQL
24 votes316 views4 answers
Postgres delete database
SQL
4 votes322 views1 answer
How to drop a database in sql server when it is in use
SQL
0 vote287 views2 answers
Close external port 3306 with iptables
SQL
0 vote286 views1 answer
Mssql view column data type
SQL
0 vote270 views2 answers
Change database postgres
SQL