David T-G wrote:
Well, I do, though I'm not surprised that I shouldn't. I still don't
know anything about left, right, inner, and outer joins; they sound like
belly buttons to me :-)
The best thing to do is find a website with some sample data and sample
queries and see how they actually work
Cal Evans wrote:
Always start with a *fully* normalized design. You can always denormalize for speed but it's real hard to normalize once you are in production.
I'd rather be 'stupid' about how normalized my data is and then write
caching into my program (or use MySQL 4's query cache, which
IMHO, etc.
Always start with a *fully* (ok, by fully I mean 3rd normal form...mainly
because I still don't fully understand 4th and don't even pretend to
understand 5th) normalized design. You can always denormalize for speed but
it's real hard to normalize once you are in production.
Vocal
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Cal, et al --
...and then Cal Evans said...
%
% IMHO, etc.
*grin*
%
% Always start with a *fully* (ok, by fully I mean 3rd normal form...mainly
% because I still don't fully understand 4th and don't even pretend to
Yeah; I'm in the same boat
to normalize out to a table
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Cal, et al --
...and then Cal Evans said...
%
...
% % product then has vocalRangeTypeID as a FK.
%
% Right. That means another lookup, but it would certainly work.
%
% If by lookup you mean another trip to the database, not necessarily, left
%
-
From: David T-G [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 14, 2003 8:17 PM
To: mysql users
Cc: Cal Evans
Subject: Re: when to normalize out to a table
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Cal, et al --
...and then Cal Evans said...
%
...
% % product then has vocalRangeTypeID
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Cal, et al --
...and then Cal Evans said...
%
% http://froogle.google.com/froogle?q=sql+for+dummiesbtnG=Froogle+Search
% http://froogle.google.com/froogle?q=sql+for+smartiesbtnG=Froogle+Search
%