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
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi, all --
I wonder if there's a best-practice line of when to bother to normalize
data out to a table. Certainly I wouldn't want to have a table of
integers and have a column in another table point into it :-) and almost
certainly I'd want to point
://www.christianperformer.com
*
-Original Message-
From: David T-G [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 14, 2003 5:49 PM
To: mysql users
Subject: when to normalize out to a table
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi, all --
I wonder if there's a best-practice line of when
-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
%