AUTO_INCREMENT values will be reused if you delete the row with the biggest AUTO_INCREMENT value in any group. So,empty the table if you want to count from 1 again on a column with AUTO_INCREMENT values . Is it what do you want ?
alter
table
tablename auto_increment
=
1
;