How can we generate the same sequence of random numbers in MySQL?

When invoked with an integer argument, RAND( ) uses that value to seed the random number generator. Each time you seed the generator with a given value, RAND( ) will produce the same sequence of random numbers. Following example will demonstrate it −

Example

mysql> Select RAND(1), RAND(1), Rand(1);
+---------------------+---------------------+---------------------+
| RAND(1)             | RAND(1)             | Rand(1)             |
+---------------------+---------------------+---------------------+
| 0.40540353712197724 | 0.40540353712197724 | 0.40540353712197724 |
+---------------------+---------------------+---------------------+
1 row in set (0.00 sec)

Vikyath Ram

Published on 20-Feb-2018 14:39:01

• Related Questions & Answers
• How can we generate Strong numbers in Python?
• Generate random numbers in Arduino
• How does Python generate random numbers?
• How to generate 5 random numbers in MySQL stored procedure?
• Generate pseudo-random numbers in Python
• Generate Random Integer Numbers in Java
• Generate array of random unique numbers in PHP?
• Generate random numbers using C++11 random library
• How to generate large random numbers in Java?
• How to generate random numbers between two numbers in JavaScript?
• How to generate random numbers with sequence and store in a data frame column in R?
• Java program to generate random numbers
• I am calling RAND() function two times in the same query then will it generate same random number two times or will it generate two different random numbers?
• Generate Random Long type numbers in Java
• Generate random characters and numbers in JavaScript?