get auto increment to work at such a number... help :(
Posted: Tue Dec 30, 2003 2:36 pm
hi. i have a MySQL table of users, so when they sign up they are assigned an id number, so the first user gets 1, the second 2, and so on.
well, i created an account through phpmyadmin with id 100000, just to test a few things out. now when a new user makes an account they are given the next numbers up from 100000, so 100001, 100002 etc...
i have deleted the account with id 100000, and all with ids above that, but new accounts are still going up from 100000. I have turned auto-increment off, but then all the new accounts made get id 0. i then turned auto_increment back on, but i still ahve the same problem. what can i do to get new account's IDs starting from the highest numebr currently in the table, as they should?
please help, and thanks for reading.
well, i created an account through phpmyadmin with id 100000, just to test a few things out. now when a new user makes an account they are given the next numbers up from 100000, so 100001, 100002 etc...
i have deleted the account with id 100000, and all with ids above that, but new accounts are still going up from 100000. I have turned auto-increment off, but then all the new accounts made get id 0. i then turned auto_increment back on, but i still ahve the same problem. what can i do to get new account's IDs starting from the highest numebr currently in the table, as they should?
please help, and thanks for reading.