Re: generating random integer id

2002-08-19 Thread Francisco
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, y

Re: generating random integer id

2002-08-17 Thread Tom Gao
I wish to use mysql to do the rand id generation... Tom - Original Message - From: "David Lloyd" <[EMAIL PROTECTED]> To: "Tom Gao" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Saturday, August 17, 2002 11:59 PM Subject: Re: generating r

Re: generating random integer id

2002-08-17 Thread David Lloyd
[ mysql, query ] > could someone point me to the right direction please Are you generating it in MySQL (using sql) or are you using a programming language to do it? DSL - Before posting, please check: http://www.mysql.com

Re: generating random integer id

2002-08-17 Thread Tom Gao
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