resetting a auto_increment column

admin

Administrator
Staff member
Hello,

I would like to reset a column using auto_increment to a certain value.

eg i have 5 entries but because i have deleted 3 auto_increment thinks the next entry will be number 9.

How can i set the 'counter' back to 6?

Thanks,
Shane
 
Back
Top