CSV import - Force all ID numbers - urgent question

[Aurélio Pereira]

Hello,

I always use to have this option off when import, so my ID's are always created with the auto-increment from the core.

By mistake, i turned on this option on and imported a few lines with the wrong ID.

Now it looks like this:

 

Now everytime i add a new product is auto-incrementing from the wrong ID (999214332....999214333....etc...).
I want to get back to old ID, how can i do it?

Thank you.

[Crezzur.com]

You can change the MYSQL increment id like this

ALTER TABLE your_table_name AUTO_INCREMENT=1001;