MySQL Forums
Forum List  »  PHP

Generate random unique IDs
Posted by: Steven R
Date: September 17, 2008 01:58AM

I need to assign a random but unique ID to each row. The best way I can think of is as described here:
http://forums.mysql.com/read.php?10,205640,205643#msg-205643

I was wondering if that's really the best, most efficient way to do it?
Filling a table with 100 million rows for the 8-digit IDs (0 to 99,999,999) seems demanding. Or is there some other function/trickery within PHP or MySQL that could be used?

Thanks!

Options: ReplyQuote


Subject
Written By
Posted
Generate random unique IDs
September 17, 2008 01:58AM
September 17, 2008 10:28PM
September 24, 2008 05:08PM
January 29, 2009 08:09AM
January 29, 2009 11:58PM
September 30, 2008 07:58PM
October 03, 2008 11:57PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.