From: Anthony Pace Date: January 20 2011 7:11pm Subject: Re: best way to have a unique key List-Archive: http://lists.mysql.com/mysql/224143 Message-Id: <4D3888DE.7080103@utoronto.ca> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit I know of uuid() my problem is that there can be conflicts when copying the DB to a different machine, or working with sections of the db on different machines for load balancing. On 1/20/2011 1:44 PM, Krishna Chandra Prajapati wrote: > > 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.