1
explain extended select rand(999999),rand();
2
id select_type table type possible_keys key key_len ref rows filtered Extra
3
1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL No tables used
5
Note 1003 select rand(999999) AS `rand(999999)`,rand() AS `rand()`
7
ERROR 42S22: Unknown column 'rand' in 'field list'
8
CREATE TABLE t1 (a INT);
9
INSERT INTO t1 VALUES (1),(1),(1),(2);
10
SELECT RAND(2) * 1000, RAND(a) * 1000 FROM t1;
11
RAND(2) * 1000 RAND(a) * 1000
12
655.586646549019 405.403537121977
13
122.346619258026 405.403537121977
14
644.97318737672 405.403537121977
15
857.826109843167 655.586646549019
16
SELECT RAND(2) * 1000, RAND(a) * 1000 FROM t1 WHERE a = 1;
17
RAND(2) * 1000 RAND(a) * 1000
18
655.586646549019 405.403537121977
19
122.346619258026 405.403537121977
20
644.97318737672 405.403537121977
21
INSERT INTO t1 VALUES (3);
22
SELECT RAND(2) * 1000, RAND(a) * 1000 FROM t1;
23
RAND(2) * 1000 RAND(a) * 1000
24
655.586646549019 405.403537121977
25
122.346619258026 405.403537121977
26
644.97318737672 405.403537121977
27
857.826109843167 655.586646549019
28
354.211017819318 905.76975597606
29
SELECT RAND(2) * 1000, RAND(a) * 1000 FROM t1 WHERE a = 1;
30
RAND(2) * 1000 RAND(a) * 1000
31
655.586646549019 405.403537121977
32
122.346619258026 405.403537121977
33
644.97318737672 405.403537121977