RE: insert random number into table

2009-10-19 Thread Jerry Schwartz
44 PM >To: Jerry Schwartz >Cc: Ray; >Subject: Re: insert random number into table > >I always maintain a timestamp in my random numbers. As long as my >precision is higher than my requests per second, wouldn't I be safe >from collisions? Assuming a time machine is not inven

Re: insert random number into table

2009-10-16 Thread Ray
On October 16, 2009 12:29:42 pm Jerry Schwartz wrote: > >-Original Message- > >From: Ray [mailto:r...@stilltech.net] > >Sent: Friday, October 16, 2009 1:10 PM > >To: mysql@lists.mysql.com > >Subject: Re: insert random number into table > > > >On O

Re: insert random number into table

2009-10-16 Thread Scott Haneda
I always maintain a timestamp in my random numbers. As long as my precision is higher than my requests per second, wouldn't I be safe from collisions? Assuming a time machine is not invented. -- Scott Iphone says hello. On Oct 16, 2009, at 11:29 AM, "Jerry Schwartz" > wrote: JS] Just remem

Re: insert random number into table

2009-10-16 Thread Scott Haneda
al Message- From: Ray [mailto:r...@stilltech.net] Sent: Friday, October 16, 2009 8:43 AM To: mysql@lists.mysql.com Subject: insert random number into table Hello All, I am trying to insert a unique random number* with each row when inserting into a table. I can do it in the application layer (php

RE: insert random number into table

2009-10-16 Thread Jerry Schwartz
>-Original Message- >From: Ray [mailto:r...@stilltech.net] >Sent: Friday, October 16, 2009 1:10 PM >To: mysql@lists.mysql.com >Subject: Re: insert random number into table > >On October 16, 2009 10:57:48 am Jerry Schwartz wrote: >> There is a RAND function i

RE: insert random number into table

2009-10-16 Thread Gavin Towey
u add more records. Regards, Gavin Towey -Original Message- From: Ray [mailto:r...@stilltech.net] Sent: Friday, October 16, 2009 8:43 AM To: mysql@lists.mysql.com Subject: insert random number into table Hello All, I am trying to insert a unique random number* with each row when insert

Re: insert random number into table

2009-10-16 Thread Ray
gt; > www.the-infoshop.com > > >-Original Message- > >From: Ray [mailto:r...@stilltech.net] > >Sent: Friday, October 16, 2009 11:43 AM > >To: mysql@lists.mysql.com > >Subject: insert random number into table > > > >Hello All, > >I a

RE: insert random number into table

2009-10-16 Thread Jerry Schwartz
2009 11:43 AM >To: mysql@lists.mysql.com >Subject: insert random number into table > >Hello All, >I am trying to insert a unique random number* with each row when inserting >into a table. I can do it in the application layer (php) but just wondering >if >there is an easier w

insert random number into table

2009-10-16 Thread Ray
Hello All, I am trying to insert a unique random number* with each row when inserting into a table. I can do it in the application layer (php) but just wondering if there is an easier way in the database layer. Thanks Ray * for example, when registering a person for a contest, I want to give th