Reset auto_increment

[Rayn]

Is there a way I can reset tables that I have deleted ?

Like I my tables is like this

1
2
6
7
34
36

how would I be able to reset that to

1
2
3
4
5
6

thanks
- Dan

[tha_mink]

Why would you need to do that?

[Rayn]

because I have around 3000 of them that are mixed up and I would like to make it atleast a little bit easyer to search through.

Why would you ask that question?

[tha_mink]

Well first I am going under the assumption that you meant records instead of tables. Unless you have 3000 tables that are numbered 1,2,3,4.

So assuming you meant record and assuming you are talking about an id colunm in a table, I asked my question because YOU are not really searching throught them, the server is, and what difference could it possibly make if the id is 300 or 56?

And I asked the question because if you reset all your id values...it could upset data in other tables that rely on the id field.

If you REALLY wanted to do it you could select all the data except the field you want to reset into a file...drop the table...reload the data. But that just seems kinda silly