On Mon, Aug 24, 2015 at 10:32 AM, Melvin Davidson <melvin6...@gmail.com> wrote:
> >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, > it can be fixed, be it one method of another. > 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.