From: Ray (raystilltech.net)
Date: Fri Oct 16 2009 - 12:09:50 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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).
>
> Regards,
>
> Jerry Schwartz
> The Infoshop by Global Information Incorporated
> 195 Farmington Ave.
> Farmington, CT 06032
>
> 860.674.8796 / FAX: 860.674.8341
>
> www.the-infoshop.com
>
> >-----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.
> >Thanks
> >Ray
> >
> >* 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-
> >infoshop.com

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.
Ray

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]