Schwartz
Cc: Ray; mysql@lists.mysql.com
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 invented.
[JS] As long
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
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 way in the database layer.
Thanks
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 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
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 inserting
-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 in MySQL, but if you need to guarantee
[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) but just
wondering
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 jschwa...@the-infoshop.com
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 October 16, 2009 10:57:48 am Jerry Schwartz wrote