Reset primary key auto_increment

Question

Possible duplicate:
Reset primary key in mysql?

Is there any solution when I

delete from t1;

and then insert objects so the identifier starts again with id = 1?

 insert into t1 values(...);

+7

Nickool Jun 05 '11 at 8:08

source share

2 answers

Resets auto_increment columns back to 0.

+3

eroomydna Jun 05 '11 at 10:02

source share

aioobe · Accepted Answer · 2011-06-05T08:09:51+0000

[...] then insert objects so the identifier starts again with id = 1?

You can ALTER TABLE as follows:

 ALTER TABLE t1 AUTO_INCREMENT = 1;