-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello, all --
...and then David T-G said...
%
% I apologize in advance for asking kindergarten-level questions on the
% list, but my head is getting really bruised from this one. I'm trying to
I still don't understand it all ;-) but I have a somewh
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Monday, December 09, 2002 6:00 PM
> To: Jon Frisby
> Subject: Re: RE: relational is relational is relational, but ...
>
>
> Your message cannot be posted because it appears to be
> Really, the issue is that you don't want a primary key that is volatile.
> It doesn't matter if it has business meaning.
Or user meaning, ie users find them useful signs. Fair enough, but if you
take that as a rationale for choosing PK values that begin by having meaning
to users, you leave your
On Tue, 3 Dec 2002, Jon Frisby wrote:
> However, from a DB design standpoint, it is generally considered
> MASSIVELY unwise for your PRIMARY KEY value to have any
> "business-meaning". If it has no "business-meaning", it never needs to
> change. Ever.
Really, the issue is that you don't want a
David,
Not bang on. A foreign key is a key which is the value of a key from a
'parent' table. In MySQL, if the table and its parent are InnoDB, the db
will prevent you from editing the parent key 'out of sync' as you say.
PB
-
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Hi again,
l users
> Subject: relational is relational is relational, but ...
> ++ ++
> | SALES | | CUSTOMERS |
> +-+---+--+ +--+-+
> | pro
d purposes, relational.
-JF
> -Original Message-
> From: David T-G [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, December 03, 2002 1:36 PM
> To: mysql users
> Subject: relational is relational is relational, but ...
>
>
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SH
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi again, all --
I apologize in advance for asking kindergarten-level questions on the
list, but my head is getting really bruised from this one. I'm trying to
understand what makes a relational (not necessarily transactional)
database and how, in wh
