MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Cal Evans Date:January 15 2003 3:42am
Subject:RE: when to normalize out to a table
View as plain text  
http://froogle.google.com/froogle?q=sql+for+dummies&btnG=Froogle+Search
http://froogle.google.com/froogle?q=sql+for+smarties&btnG=Froogle+Search
http://froogle.google.com/froogle?q=mysql+paul+dubois&btnG=Froogle+Search
(first book in the list)

I can personally recommend the first two and while I've never met him, I do
not hesitate to recommend the author of the third.  :)

These are all portable, energy efficient and almost never crash unless
thrown.

Also, using the table structures we've discussed, something like:

Select p.productID,
       p.title,
       v.description as range
  from product p left join voicingType v on p.voicingTypeID =
v.voicingTypeID
where productID = 4

should get you a result set back with a productID, title and the description
of the range.

=C=

*
* Cal Evans
* Stay plugged into your audience.
* http://www.christianperformer.com
*


-----Original Message-----
From: David T-G [mailto:davidtg-mysql@stripped]
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 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
% join this table to your product select statement and bring in all the data
% at once.

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 :-)

I've done some reading on joins and haven't figured it out yet.  Pointers
to favorite tutorials are appreciated, but I'm trying not to flat-out ask
the list to explain it to me (though that's fine with me at this point,
too).


%
% =C=


Thanks again & HAND

mysql query,
:-D
- --
David T-G                      * There is too much animal courage in
(play) davidtg@stripped * society and not sufficient moral courage.
(work) davidtgwork@stripped  -- Mary Baker Eddy, "Science and Health"
http://justpickone.org/davidtg/      Shpx gur Pbzzhavpngvbaf Qrprapl Npg!

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (FreeBSD)

iD8DBQE+JMSNGb7uCXufRwARAhDlAJ4mEQfLWxMPs+liVE/aUTNs08dwcgCfeRNT
FowEnZRXzwiyBtkjLXGbaK4=
=mi3l
-----END PGP SIGNATURE-----

---------------------------------------------------------------------
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 <mysql-thread129971@stripped>
To unsubscribe, e-mail <mysql-unsubscribe-cal=calevans.com@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


Thread
when to normalize out to a tableDavid T-G15 Jan
  • RE: when to normalize out to a tableCal Evans15 Jan
    • Re: when to normalize out to a tableDavid T-G15 Jan
      • RE: when to normalize out to a tableCal Evans15 Jan
        • Re: when to normalize out to a tableDavid T-G15 Jan
          • RE: when to normalize out to a tableCal Evans15 Jan
            • Re: when to normalize out to a tableDavid T-G15 Jan
          • Re: when to normalize out to a tableMichael T. Babcock23 Feb
    • Re: when to normalize out to a tableMichael T. Babcock15 Jan