Userid Auto Increment Issue

[boxingscene]

Originally Posted by Paul M

If you dont view them with a sort order set, then they are not going to necessarily be listed in order, MySQL does not care about storing rows in any order internally.

That makes sense. My developer just told me because my database is so big (almost 30 gigs) that phpmyadmin is not necessarily going to sort that much date in numerical order.

When I ran a test query below, everything came up fine and in order with no IDs skipped.

SELECT * FROM `user` WHERE `userid` BETWEEN 12986000 AND 12986500 ORDER BY `userid` ASC limit 0,100