Hi, If you are generating the id yourself a good strategy is to use UUID that are "guaranteed" to be "universally" unique. If you are developing for the Microsoft platform, there is an API functions that returns you a UUID and this number is guaranteed to be unique.
If you are working in Java, you can download the source code of a UUID generator. Bye, --- Tom Gao <[EMAIL PROTECTED]> wrote: > hi guys, > > I'm trying to generate randomly a number as the > primary key the key is to > be an integer in mysql. So like auto_increment I can > insert values and the > pk can be generated automatically. > > could someone point me to the right direction > please > > thanks > Tom > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list > archive) > > To request this thread, e-mail > <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > __________________________________________________ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
