Updating the primary key

Rated 4.66/5 based on 860 customer reviews

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.

Leave a Reply