>ON UPDATE CASCADE ?
I believe he's talking about triggers.
I believe he's talking about triggers.
On Mon, Aug 24, 2015 at 8:00 PM, Berend Tober <btober@xxxxxxxxxxxx> wrote:
Melvin Davidson wrote:
9.
>1) What happens if someone mis-types the account-id?
> To correct that, you also need to correct the FK field in the
other dozen tables.
>2) What happens when your company starts a new project (or buys a
I would not consider the general use of natural primary keys to be
best practice.
Let's assume your account_id field is used as a foreign key in a
dozen other tables.
1) What happens if someone mis-types the account-id?
To correct that, you also need to correct the FK field in the
other dozen tables.
... ON UPDATE CASCADE ?
--
Melvin Davidson
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.![]()
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
