EXiT Posted May 21, 2008 Share Posted May 21, 2008 I was inserting users into the database with a userid the userid started off like 1,2,3... and it has jumped from 8 to 5000. Im not sure how to get it back down. Everytime i insert a new user it auto increments from 5000 Any ideas? Quote Link to comment Share on other sites More sharing options...
bobinindia Posted May 21, 2008 Share Posted May 21, 2008 Once it thinks it has had an id of 5000 it will still auto increment from there even if you empty the table. If you need the ids to start from 1 again you may need to re create the table. Quote Link to comment Share on other sites More sharing options...
rhodesa Posted May 21, 2008 Share Posted May 21, 2008 Are you saying it jumps by 5000 every time? Check out this: http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#option_mysqld_auto-increment-increment Quote Link to comment Share on other sites More sharing options...
darkmonk Posted June 2, 2008 Share Posted June 2, 2008 hi EXiT i cnt message you back for some reason. but ye would be awesome if you could help!!! do have have experience with orpg'S?? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.