> In an SQL server, you'd use a SEQUENCE: > > SELECT NEXT VALUE FOR MY_BLA_SEQ FROM <...> >
Here's a good read about how Flickr manage their unique IDs using MySQL: http://code.flickr.com/blog/2010/02/08/ticket-servers-distributed-unique-primary-keys-on-the-cheap/ clint
