Seed RAND( ) randomly : RAND « Function « SQL / MySQL






  1. SQL / MySQL
  2. Function
  3. RAND

Seed RAND( ) randomly

     
mysql>
mysql> SELECT RAND(UNIX_TIMESTAMP( )) AS rand1,
    -> RAND(CONNECTION_ID( )) AS rand2,
    -> RAND(UNIX_TIMESTAMP( )+CONNECTION_ID( )) AS rand3;
+--------------------+-------------------+-------------------+
| rand1              | rand2             | rand3             |
+--------------------+-------------------+-------------------+
| 0.0815259293481018 | 0.681954370515379 | 0.608259872168545 |
+--------------------+-------------------+-------------------+
1 row in set (0.00 sec)

mysql>








Related examples in the same category

1.Each time you seed the generator with a given value, RAND( ) will produce a repeatable series of numbers:
2.Selection with a random Column
3.To select a single winner at random from the combined results of the three tables
4.Generating Random Numbers
5.Randomizing a Set of Rows
6.Add a column of random numbers to the column output list, alias it, and refer to the alias for sorting
7.Selecting Random Items from a Set of Rows
8.To draw five winning entries at random from a table named drawing that contains contest entries, use RAND( ) i
9.get some random numbers
10.Get some random numbers in the range 1-100
11.Get the name and the number of each player whose name consists of the pattern m.n. The point can be any random