Congrats on the 1,000,000, posts
Announcement
Collapse
No announcement yet.
1,000,000, posts
Collapse
X
-
Originally posted by filburt1If you drop and reapply auto_increment, it could start to fill in blank IDs. If you delete post ID 2, then reapply auto_increment, suddenly it could be filled with a new post.
If the dateline had millisecond precision, it could be used as the primary key instead (provided no two posts share the same post time to the millisecond). The point of an ID is to uniquely identify data, not to necessarily describe it.
(I'm taking a database design class, but I knew this going into it anyway)
I did not know that reseting auto_increment would fill in unused IDs. Thanks for the information.
Comment
Related Topics
Collapse
-
by anwar513New Topics code;
Code:search?searchJSON=%7B%22date%22%3A%22lastVisit%22%2C%22view%22%3A%22topic%22%2C%22unread_only%22%3A1%2C%22sort%22%3A%7B%22lastcontent%22%3A%22desc%22%7D%2C%22exclude_type%22%3A
-
Channel: vBulletin 5 Connect Feedback
Fri 13 Feb '15, 5:41pm -
-
by TheGLForumModify the search string of TODAY'S POSTS to NOT show posts from a specific channel(s)? A way to filter what TODAYS POSTS displays?...
-
Channel: vB Cloud Support & Troubleshooting.
Sat 27 Sep '14, 1:27pm -
Comment