On Sat, 16 Apr 2005, David Blomstrom wrote:
>
>--- Kim Briggs <[EMAIL PROTECTED]> wrote:
>> David,
>>
>> In reading through miscellaneous database design
>> text on the web, I
>> read just the other day that you should not try to
>> include meaningful
>> data in your key values. I assume there w
On Sat, 16 Apr 2005, David Blomstrom wrote:
>I think my question is more oriented towards PHP, but
>I'd like to ask it on this list, as I suspect the
>solution may involve MySQL.
>
>I'm about to start developing an enormous database
>focusing on the animal kingdom and want to find a key
>system mo
P.O. box 166
Lakewood NM 88254
http://www.gunmuse.com
469 228 2183
-Original Message-
From: Kim Briggs [mailto:[EMAIL PROTECTED]
Sent: Saturday, April 16, 2005 10:23 PM
To: David Blomstrom
Cc: mysql@lists.mysql.com
Subject: Re: Relative Numeric Values
David,
In reading through miscellaneous database
David,
I agree with Kim. Trying to encode information into primary keys is a
bit like trying to write a legal contract in chalk on a sidewalk. The
contract is washed away next time it rains, the neat looking key order
is washed away by errors, species discoveries & reclassifications. The
PK doe
--- Kim Briggs <[EMAIL PROTECTED]> wrote:
> David,
>
> In reading through miscellaneous database design
> text on the web, I
> read just the other day that you should not try to
> include meaningful
> data in your key values. I assume there will be
> some kind of "lookup"
> tables for species, p
David,
In reading through miscellaneous database design text on the web, I
read just the other day that you should not try to include meaningful
data in your key values. I assume there will be some kind of "lookup"
tables for species, phylum, whatever. Trying to make your key field
"smart" seems