Shulou(Shulou.com)06/02 Report--

This article mainly introduces how mysql obtains random numbers within the range, which has a certain reference value. Interested friends can refer to it. I hope you will gain a lot after reading this article. Let's take a look at it.

To get a random integer R in the range of I ≤ R ≤ j, you need the expression FLOOR (I + RAND () * (j-I + 1)).

For example, to get a random integer in the range 1000 to 2000, including 1000 and 2000, use the following statement:

SELECT FLOOR (1000 + (RAND () * 1001)); Thank you for reading this article carefully. I hope the article "how to get random numbers in the range" shared by the editor will be helpful to everyone. At the same time, I also hope that you will support and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.