RAND: Generate random number

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

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

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

Previous                                                 Next                                                 Home