Mega Code Archive

 

Categories / MySQL / Function

 

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>