Thread: RAND()
View Single Post

   
  #5 (permalink)  
Old 05-02-2008, 05:05 AM
Tigger
 
Posts: n/a
Default Re: RAND()


"Jerry Stuckle" <jstucklex@attglobal.net> wrote in message
news:n8GdnZSDT8M7gIrVnZ2dnUVZ_vKdnZ2d@comcast.com. ..
> Cosmic programmer wrote:
>> How good is the rand function of MySQL? How can it be improved?
>>
>> Thx.
>>
>> --
>> When you argue with a fool, chances are he's doing the same

>
> It's as good as pretty much any pseudo-random number generator. Why do
> you think it needs to be improved?
>
> --
> ==================
> Remove the "x" from my email address
> Jerry Stuckle
> JDS Computer Training Corp.
> jstucklex@attglobal.net
> ==================
>


I remember an older version had issues with generating the same random
number sequences when called from identical code routines.

The solution was to add a random seed from the language your using to
shuffle the pack first, so to speak.

--
Tony
http://www.mccreath.org.uk


Reply With Quote