Reset primary key auto_increment [duplicate]

This question already has answers here: Closed 11 years ago.

Possible Duplicate:

Reset primary key in mysql?

Is there any solution开发者_StackOverflow中文版 to when I

delete from t1;

and then insert entities force the id to begin from id=1 again?

insert into t1 values(...);

---

[...] then insert entities force the id to begin from id=1 again?

You can ALTER TABLE like this:

ALTER TABLE t1 AUTO_INCREMENT = 1;

Documentation here: MySQL ALTER TABLE Syntax

---

Try truncate table http://dev.mysql.com/doc/refman/5.1/en/truncate-table.html

This resets auto_increment columns back to 0.