в 13:44, 26 мая 2010

2010-05-26T13:44:56Z

Admin: 1 версия

2010-05-26T09:49:50Z

1 версия

Новая страница

== RAND(20)==



<source lang="sql">
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></source>

== RAND(), RAND(N) returns a random floating-point value v in the range 0 ==

<p>If a constant integer argument N is specified, it is used as the seed value, which produces a repeatable sequence of column values.</p>



<source lang="sql">
mysql>
mysql> SELECT RAND();
+------------------+
| RAND() |
+------------------+
| 0.72570215698863 |
+------------------+
1 row in set (0.00 sec)
mysql>
mysql> 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>
mysql> SELECT RAND();
+------------------+
| RAND() |
+------------------+
| 0.49934750655605 |
+------------------+
1 row in set (0.00 sec)
mysql>
mysql> SELECT RAND();
+------------------+
| RAND() |
+------------------+
| 0.31963109254803 |
+------------------+
1 row in set (0.00 sec)</source>

== To obtain a random integer in the range the range 7 ==



<source lang="sql">
mysql>
mysql> SELECT FLOOR(7 + (RAND() * 5));
+-------------------------+
| FLOOR(7 + (RAND() * 5)) |
+-------------------------+
| 7 |
+-------------------------+
1 row in set (0.00 sec)
mysql></source>

← Предыдущая	Версия 13:44, 26 мая 2010
(нет различий)

MySQL Tutorial/Math Numeric Functions/RAND - История изменений

в 13:44, 26 мая 2010

Admin: 1 версия