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.

Reply via email to