Hi.
On Tue, May 28, 2002 at 06:51:11PM -0400, [EMAIL PROTECTED] wrote:
> How do you reference a column name in another table to avoid repeating the
> values?
I am not sure if I understand you correctly, but I assume you mean this:
Given the following table layout (it's a simplification in that
Hi.
On Tue, May 28, 2002 at 04:32:20PM -0700, [EMAIL PROTECTED] wrote:
> Thanks for the reply! Should I change the structure such that all
> varchar fields are in the same table?
I see no reason for this. It may make a (minor) speed difference, but
you should only ever change your table layout
TED]
Subject: Re: first mysql table; syntax qustion
Hi.
Looks okay, except that you probably want to reference via pro_id and
d_id in table available_properties (given that I understood your table
layout correctly). It is usally considered bad design to repeat the
values itself (the varchars
How do you reference a column name in another table to avoid repeating the
values?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Benjamin
Pflugmann
Sent: Tuesday, May 28, 2002 6:24 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: first mysql
Hi.
Looks okay, except that you probably want to reference via pro_id and
d_id in table available_properties (given that I understood your table
layout correctly). It is usally considered bad design to repeat the
values itself (the varchars) in several tables.
Bye,
Benjamin.
On Tue, M
