Re: Re: Create unique non-autoincrement key for 700,000records?

I think he knows how to use it, he didn't show us a certain example where and how he wants to use it, i just posted the way how i do generate an unique identifier, if he use the first mentioned way - AutoIncID+unix_timestamp - there can be a collision, when two users will attempt to perform this task on the same id at the same time. yes, it's not very probable but if you have system with many users it can happen "Robert Cummings" <robert@interjinn.com> pí¹e v diskusním pøíspìvku news:1229410766.9173.41.camel@localhost... > On Tue, 2008-12-16 at 07:35 +0100, Ondrej Kulaty wrote: >> I use md5(microtime()); > > I applaud the use of PHP on the "PHP" list... but I think the OP wants > an SQL query :) > > Cheers, > Rob. > -- > http://www.interjinn.com > Application and Templating Framework for PHP >