/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

8 votes179 views1 answer
Oracle add month
SQL
0 vote193 views1 answer
Sql server datetime to string
SQL
0 vote192 views1 answer
Pl sql join 3 tables
SQL
4 votes193 views1 answer
Data types in sql
SQL
0 vote193 views1 answer
New rails app with mysql
SQL
0 vote201 views1 answer
Create table with float datatype in sql server
SQL
0 vote199 views1 answer
Write a PL/SQL to print even numbers upto 100.
SQL
0 vote203 views1 answer
Postgresql function ROUND
SQL
0 vote194 views1 answer
Error: connect ECONNREFUSED 127.0.0.1:5432 at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1148:16
SQL
0 vote198 views1 answer
Mysql root permission denied lost
SQL