/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

5 votes294 views1 answer
Invalid column name sql
SQL
11 votes273 views2 answers
Oracle all source
SQL
19 votes282 views5 answers
Change column name mysql command line
SQL
3 votes386 views1 answer
How to get yesterday date in sql
SQL
0 vote299 views1 answer
Tablas bootstrap responsive sql server para datos vivos
SQL
1 vote291 views1 answer
Wordpress change http to https phpmyadmin
SQL
0 vote284 views1 answer
Start stop mysql linux
SQL
25 votes294 views6 answers
Import mysql database command line
SQL
9 votes277 views4 answers
How to create new user and database postgresql in ubuntu
SQL
0 vote262 views1 answer
Oracle search in date columns
SQL