Forum Index » PHP + MySQL » mySQL question
| Posted on Sunday 8th February 2009 at 01:37 AM | |
Adam981 Junior Member |
is there a way to reset the ID for each user, because of my usersystem i had alot of "testing users" that i deleted so on my member page the user id list is jumped around. rather then 1234567 for my 7 users i have 1, 8, 11, 16, 17, 18, 19. |
| Posted on Monday 9th February 2009 at 12:00 AM | |
| Nathan Active Member |
delete the id and recreate it |
| Posted on Monday 9th February 2009 at 02:54 AM | |
| Adam981 Junior Member |
i dont want to delete and redo 7 members |
| Posted on Monday 9th February 2009 at 08:23 PM | |
| setsukemizuhara Newbie |
All you can do to reset the ID column if its auto increment. |
| Posted on Monday 9th February 2009 at 08:53 PM | |
| Nathan Active Member |
yeah thats the only way is to delete the id colum and recreate it |
| Posted on Tuesday 10th February 200 at 02:16 AM | |
| Adam981 Junior Member |
Yea shadow helped me out with this, thanks |