Re: Advice on Random Numbers

2001-05-24 Thread Aigars Grins
> > > > *] I need to generate a RANDOM UNIQUE number for every new record. Is > > there an > > > > *] easy way to accomplish this inside of mySQL. > > > > *] > > > > What are the requirements for 'random' and 'unique'? Do you need some sort > > of cryptographic randomness? Does uniqueness be kept

Re: Advice on Random Numbers

2001-05-24 Thread Kip Turk
On Thu, 24 May 2001, Aigars Grins wrote: > > > *] I need to generate a RANDOM UNIQUE number for every new record. Is > there an > > > *] easy way to accomplish this inside of mySQL. > > > *] > > What are the requirements for 'random' and 'unique'? Do you need some sort > of cryptographic randomne

Re: Advice on Random Numbers

2001-05-24 Thread Aigars Grins
> > *] I need to generate a RANDOM UNIQUE number for every new record. Is there an > > *] easy way to accomplish this inside of mySQL. > > *] What are the requirements for 'random' and 'unique'? Do you need some sort of cryptographic randomness? Does uniqueness be kept across tables? If you 'onl

Re: Advice on Random Numbers

2001-05-23 Thread Michael Bacarella
> *] I need to generate a RANDOM UNIQUE number for every new record. Is there an > *] easy way to accomplish this inside of mySQL. > *] > > The way I do this for session ids is through a perl function that I > wrote a long time ago. Essentially I create a really long string of > mixed case al

Re: Advice on Random Numbers

2001-05-23 Thread Peter L. Berghold
On Wed, May 23, 2001 at 02:22:02PM -0400, Dave Carter spake thusly: *] I need to generate a RANDOM UNIQUE number for every new record. Is there an *] easy way to accomplish this inside of mySQL. *] The way I do this for session ids is through a perl function that I wrote a long time ago. Essen

Advice on Random Numbers

2001-05-23 Thread Dave Carter
I need to generate a RANDOM UNIQUE number for every new record. Is there an easy way to accomplish this inside of mySQL. TIA Dave Carter Chief Web Architect Accelerated Business Technologies, Inc. http://www.abti.cc 717.464.2970 (mail filter bologna: sql,database,query) --