/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 vote168 views1 answer
Connection error in mysql workbench
SQL
0 vote213 views1 answer
Mysql add root password
SQL
0 vote225 views1 answer
Xamarin sql lite create table if not exist
SQL
0 vote206 views1 answer
Redirection 301 htaccess nom de domaine
SQL
0 vote253 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception: syntax error in sql statement
SQL
0 vote172 views1 answer
Sql count how many times a value appears
SQL
7 votes220 views3 answers
Restore postgres database from sql file
SQL
0 vote225 views1 answer
Convert rows to columns in sql server
SQL
0 vote196 views1 answer
Metada in sql
SQL
48 votes218 views3 answers
Psql create database
SQL