Re: Random Unique ID

2007. 03. 22, csütörtök keltezéssel 11.24-kor tedd ezt írta: > At 11:18 AM -0600 3/21/07, ccspencer@softhome.net wrote: > >Hello, > >I want to add a random unique ID to a Mysql table. Collisions > >are unlikely but possible so to handle those cases I'd like to > >regenerate the random ID until there is no collision and only > >then add my row. Any suggestions for a newbie as to the right > >way to go about doing this? > >Best, > >Craig > > Craig: > > Simple. > > Generate a "random unique ID" via whatever method you want. However, > before using, search your dB to see if it's already in use. If it is, > then generate another one and repeat. it's probably more efficient to try to insert with the generated ID at once, and repeat only if it fails. if the ID generation method is good enough, repeat will be needed only extremely rarely greets Zoltán Németh > > Cheers, > > tedd > -- > ------- > http://sperling.com > http://ancientstones.com ¤”ŸÍ9YJ<á½Ëç > ¸http://earthstones.com >