Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
From: Ray (raystilltech.net)
Date: Fri Oct 16 2009 - 12:09:50 CDT
On October 16, 2009 10:57:48 am Jerry Schwartz wrote:
> There is a RAND function in MySQL, but if you need to guarantee that the
> identifiers are unique you should consider using an auto-increment field.
> If that isn't unique enough, you can use the UUID or UUID_SHORT functions.
> Theoretically, those should return values that are unique across the
> Internet (at least).
> Jerry Schwartz
> The Infoshop by Global Information Incorporated
> 195 Farmington Ave.
> Farmington, CT 06032
> 860.674.8796 / FAX: 860.674.8341
> >-----Original Message-----
> >From: Ray [mailto:raystilltech.net]
> >Sent: Friday, October 16, 2009 11:43 AM
> >To: mysqllists.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.
> >* for example, when registering a person for a contest, I want to give
> > them a unique, random identifier.
> >MySQL General Mailing List
> >For list archives: http://lists.mysql.com/mysql
> >To unsubscribe: http://lists.mysql.com/mysql?unsub=jschwartzthe-
Thanks for the replies. I think I'll use the php solution as it is the better
match for what I am trying to do. I'l keep the UUID functions in mind for
future use though.
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql