/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

14 votes122 views1 answer
Oracle new column
SQL
0 vote128 views1 answer
Set engine to innodb
SQL
3 votes127 views2 answers
How to delete git repo locally
SQL
0 vote121 views1 answer
Select row with latest date mysql
SQL
31 votes119 views3 answers
Sql count(*)
SQL
2 votes108 views1 answer
Sqlite3 show columns name
SQL
0 vote106 views1 answer
Dump only schema
SQL
-1 vote184 views2 answers
An error occurred while installing mysql2 (0.3.20), and Bundler cannot continue.
SQL
0 vote140 views1 answer
Sql_inner_join
SQL
1 vote116 views2 answers
How to search date in sql query
SQL