Topic: [SOLVED] mysql table back to 1 after delete

[anon]

I have a table with auto-increment. When i delete all data in the database, and then enter a new value, the id won't return to 1, it will auto-increment after the last deleted value.

e.g the new values id will be 5, not 1.

How do i get it to reset?

[toplay]

It's in the manual:

To change the value of the AUTO_INCREMENT counter to be used for new rows, do this:

ALTER TABLE t2 AUTO_INCREMENT = value;

[revraz]

If you have PHPMyAdmin, you can do it in there as well.

[anon]

How do i do that in phpmyadmin?

[fenway]

If you really want to empty a table, use TRUNCATE, and you won't have this problem.

[anon]

I don't want to just empty the table, i want it to reset back to 1 afterwards. Doesn't do that, carries on counting after I have deleted the entire table.

[revraz]

Under the Table, go to Operations.  You can set it there.

How do i do that in phpmyadmin?

[fenway]

I don't want to just empty the table, i want it to reset back to 1 afterwards. Doesn't do that, carries on counting after I have deleted the entire table.

You deleted the entire table, but you don't want to empty it? What does that mean?  TRUNCATE deletes and resets the counter properly.

[anon]

(not being smarmy here) I said I don't just want it to delete....

I want it to delete the entire table AND reset counter

I understand that Truncate does that now.