Re: best way to have a unique key

[Krishna Chandra Prajapati]

uuid()

Krishna

On Fri, Jan 21, 2011 at 12:02 AM, Anthony Pace <anthony.pace@stripped>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=1
>
>