MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Cal Evans Date:January 15 2003 2:06am
Subject:RE: when to normalize out to a table
View as plain text  
%
% vocalRangeType
% ---
% vocalRangeTypeID
% ===
% description
% ===
%
% 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.

=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 7:53 PM
To: mysql users
Cc: Cal Evans
Subject: Re: when to normalize out to a table

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