From: Perrin Harkins Date: May 28 2010 6:06pm Subject: Re: Using RAND to get a unique ID that has not been used yet List-Archive: http://lists.mysql.com/mysql/221746 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 On Fri, May 28, 2010 at 11:38 AM, Andre Matos wrote: > I have a table that uses auto_increment to generate the Id automatically working fine. > However, I need to create a new table where the Id must be a number generated > randomly, so I cannot use the auto_increment. You'd be better off using UUID in my opinion. - Perrin