Math Numeric Functions MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. Math Numeric Functions
  4. To obtain a random integer in the range the range 7 = R 12
mysql>
mysql> SELECT FLOOR(7 + (RAND() * 5));
+-------------------------+
| FLOOR(7 + (RAND() * 5)) |
+-------------------------+
|                       7 |
+-------------------------+
1 row in set (0.00 sec)
mysql>