I'm in the process of converting an old Access database into MySQL. I've successfully imported the various tables over (some quite large).
The Access versions of those tables all have an ID-type column that is a primary key (and auto-incremented). The issue I have is I'm trying to do the same for those equivalent table columns in MySQL.
The thing is, when I make that column a primary key it doesn't preserve the values in those columns (it renumbers them all). I need to make that column a primary key and auto-incrementable BUT without changing the values already there (which are unique integers).
Am I doing something wrong?
Many thanks, in advance.