MySQL can I insert specific ids into an auto-increment column

Question

I accidentally deleted some rows in my database, but I have a copy of the data in a backup. Is it possible to insert the rows back in with the same id (auto-increment field). Or do I have to use the auto-increment generated id then update all the relationships manually?

Accepted Answer

You can, just by setting the field when INSERTing. Autoincrement only works if no value is specified for the field.

MySQL can I insert specific ids into an auto-increment column

Solution

Problem