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
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) in several tables.
Bye
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
Hello list, this is my first table for a simple php page and I'm hoping
someone could briefly review its structure. The only fields I'll be
sharing are property_name and type. Are they set up properly for select
join queries?
thank you, justin
Database=properties
Tables are available_properti
