http://www.mysqlperformanceblog.com/2007/03/13/to-uuid-or-not-to-uuid/
> -----Original Message----- > From: Krishna Chandra Prajapati [mailto:prajapat...@gmail.com] > Sent: Thursday, January 20, 2011 10:45 AM > To: Anthony Pace > Cc: mysql. > Subject: Re: best way to have a unique key > > uuid() > > Krishna > > On Fri, Jan 21, 2011 at 12:02 AM, Anthony Pace > <anthony.p...@utoronto.ca>wrote: > > > Due to certain reasons, the company I am doing business > with has decided > > that the primary key, for an orders table, be a unique key; > however, I don't > > like the possibility of it conflicting if moved to another machine. > > > > What are some pitfalls of using a unique key, that is > generated by a server > > side script, rather than by mysql? > > What are the best ways to do this? > > > > Please keep in mind this variable will also be displayed on > the customer's > > Receipt, but again, since it's random, it doesn't have to > mean anything. > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > > http://lists.mysql.com/mysql?unsub=prajapat...@gmail.com > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org