11.2.9 随机函数
1.RAND()函数
RAND()函数返回一个0到1之间的随机数。使用示例如下:
mysql> SELECT RAND(), RAND(), RAND();
+---------------------+--------------------+--------------------+
| RAND() | RAND() | RAND() |
+---------------------+--------------------+--------------------+
| 0.14092314908366943 | 0.6300797272753713 | 0.7276292198594931 |
+---------------------+--------------------+--------------------+
1 row in set (0.00 sec)
mysql> SELECT RAND(), RAND(), RAND();
+--------------------+--------------------+--------------------+
| RAND() | RAND()