it can be fixed, be it one method of another.>What then if it is discovered that the keyed in value was mis-typed?That is why SQL has UPDATE and DELETE statements. If a primary key is incorrect,
Yes, a DBA can use ON DELETE CASCADE and ON UPDATE CASCADE
to manually resolve the issue of a typo. At scale it is not a clear-cut solution, however.
David J.
