Updating the primary key
So really, when the data needs to change, create the PK on an auto-increment field and let people modify the rest of the data, or delete the entire record when necessary.However, I don't think there's much difference between "adding a new line and removing the old line", and just modifying the row itself.
I am writing a script that has to update some rows without changing the contents of another script that creates a few tables.
You need to copy the existing target to a new name.
They add additional column ports to recieve new primary key column values you need to update.
sample: Once a record is created with a primary key, you really shouldn't be updating the primary key.
The point of a PK is that it uniquely identifies that row.