Table internal counter

[expired user #3438]'s profile image [expired user #3438] posted 16 years ago in General Permalink
Hey!

Where can I reset the table's auto_increment counter?

Thanks
ansgar's profile image ansgar posted 16 years ago Permalink
Rightclick the table in the tree or in the list view, click "Alter table ..." and edit the auto increment value. It's always safe to set it to 0, also for tables with rows in it. MySQL will correct the value as needed.
[expired user #3438]'s profile image [expired user #3438] posted 16 years ago Permalink
Thanks :D

Please login to leave a reply, or register at first.