Change AutoIndex number Mysql

Question

In my table I have auto increment id which is having its number like 1 to 66,440 and next number is 88846790 + increment from here till 88846900.

There is no records in between 66440 to 88846790

I want my next auto increment number to be 66441 but its taking 88846791, can you help me in setting next auto increment to 66441,

Answer 1

Click to copy

alter table tablename AUTO_INCREMENT=664441 

should do