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: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 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=jschwa...@the- > >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 To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org