RAND(20) : RAND « Math Numeric Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. Math Numeric Functions
  3. RAND
SELECT RAND(20);
+------------------+
| RAND(20)         |
+------------------+
| 0.15888261251047 |
+------------------+
1 row in set (0.00 sec)

mysql>
mysql> SELECT RAND(20);
+------------------+
| RAND(20)         |
+------------------+
| 0.15888261251047 |
+------------------+
1 row in set (0.00 sec)

mysql>








21.30.RAND
21.30.1.RAND(), RAND(N) returns a random floating-point value v in the range 0 <= v < 1.0.
21.30.2.RAND(20)
21.30.3.To obtain a random integer in the range the range 7 <= R < 12