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? Link to comment https://forums.phpfreaks.com/topic/106662-mysql-userid-help/ 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. Link to comment https://forums.phpfreaks.com/topic/106662-mysql-userid-help/#findComment-546714 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 Link to comment https://forums.phpfreaks.com/topic/106662-mysql-userid-help/#findComment-546719 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?? Link to comment https://forums.phpfreaks.com/topic/106662-mysql-userid-help/#findComment-555839 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.