我可以将现有的自动增量列更改为plain int（无增量），然后在添加记录后再将其更改回来

I have a table that has its primary key set to autoincrement. This table needs to be brought up to date via an import of data, but I want to assign the primary key based on the imported data not on the next incremented value. Also the data to import may not be in sequence - some ids might be missing (101,105,122 etc).I have a table that has its primary key set to