://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 design text on the web, I
read just
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 more
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 will be
some kind
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 more user friendly than the traditional
scientific
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
--- 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, phylum,
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