I am combining several databases, each with 20 tables, many, but not all, tables having an auto increment id field starting at 1.

How can I combine them without manually changing each insert statement?

Thanks.