/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

23 votes122 views6 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote186 views1 answer
Osm2pgsql mac
SQL
0 vote135 views1 answer
Pl/sql loop example
SQL
0 vote134 views2 answers
SQL Server Standard
SQL
0 vote135 views1 answer
Coalesce for comma separated in sql server
SQL
3 votes145 views3 answers
Raw select laravel
SQL
0 vote131 views1 answer
Psql list rules
SQL
0 vote246 views1 answer
Multiple replace value mssql
SQL
0 vote134 views1 answer
How to declare variable date in mysql
SQL
0 vote148 views3 answers
How to assign custom id in mysql
SQL