On Wed, 9 Jan 2002, Rick Emery wrote:
> First, you are describing a "one-to-many" relationship, bceasue one "file"
> record can be referenced by many "people" records. If this is the case, you
> may wish to re-design your tablse such that a "people record" contains a
> "file_id" field. You can
> So I designed my "files" and "people" tables without any direct
> relationship with one another, thinking to link them with the SELECT
> statement.
>
> What I completely forgot, up until this point, was that I would need to
> INSERT these records (from pre-written HTML/PHP forms), and there is n
he way that "mysqlshow" outputs the data. In reality,
each column is a UNIQUE index (-not- a PRIMARY KEY). For some reason,
that's what mysqlshow gives instead of UNIQUE.
Thanks for the input, though!
Erik
>
> -----Original Message-
> From: Erik Price [mailto:[EMA
EMAIL PROTECTED]]
Sent: Wednesday, January 09, 2002 11:14 AM
To: [EMAIL PROTECTED]
Cc: Etienne Marcotte
Subject: INSERTing into joined tables?
Hello, everyone --
I have received a great deal of help from many members of this list, so
I'd like to acknowledge that now. Someday, when I have my head
Hello, everyone --
I have received a great deal of help from many members of this list, so
I'd like to acknowledge that now. Someday, when I have my head wrapped
around this stuff, I hope to return the favor. In the meantime,
however, I have come across my worst brainbuster yet. Any help on
